← All explainers Getting started · 5 min read
Famu explainers · Import records

Your spreadsheet, sorted

Most farms already keep their books in a spreadsheet: a tab for spending, a tab for eggs, a tab per crop. You should not have to type it all again. Famu reads the whole workbook, works out where each tab belongs, and lets you check every row before anything is saved.

What you hand over 1 workbook

An Excel file or CSV from your phone or computer, or a Google Sheets link. Every tab, however it is laid out.

What comes back Rows to check

Each tab turned into expenses, feed, sales, capital costs or other income, filed against the right crop or batch, waiting for you to press Save.

1 Import records · /import

Hand over the whole thing

No template to fill in, no columns to rename first.

Upload a workbook (.xlsx or CSV) and it is opened on your own device: the file itself never leaves it, only the text of the rows is sent to be read. Or paste a Google Sheets link. The first time, Famu asks Google for permission to read your spreadsheets. It cannot change, create or delete them, and it only opens the one sheet you point it at, with the access your own Google account already has.

Empty tabs are left out, and Famu says how many. A workbook with more than twenty tabs has the rest named rather than silently dropped.

2 Before a single row is read

Every tab gets a place, and you agree to it

Famu looks at the top of each tab and suggests three things. Click through this farmer's workbook to see what it would say.

September book.xlsx Click a tab
What is this tab?
Enterprise
Belongs to

Crossed-out rows are the ones Famu leaves out: titles, blank lines and totals. A total is arithmetic, not a record, and importing it would count the money twice.

The three suggestions are which book (spending, feed bought, sales, capital costs, other income, or not one of these), which enterprise, and, where the book can carry it, which planting or batch. A crop's spending filed against its planting is what makes that planting's profit and loss true.

Famu only ties a tab to a planting or batch when the tab itself says so. When it cannot tell, it leaves the choice to you rather than guess, because a season's costs filed against the wrong plot is a mistake nobody goes looking for. You change any suggestion with one dropdown, and only the books your role is allowed to add to are offered at all.

3 One tab at a time

Nothing is saved until you have looked

Famu reads the rows. You decide what becomes a record.

Each tab you kept is read into a table you can edit: dates (day first, the way they are written here), amounts without the "UGX" and the commas, a category matched to your own list, bags turned into kilograms when the sheet says how heavy a bag is. Anything Famu could not be sure of is left blank, not guessed.

A row missing a date or an amount is marked, and holds up the Save until you fix it or untick it. One Save then files every tab into its own book. If a tab fails, the others are not lost, and a tab that already saved is never saved twice.

  1. Upload, or paste a Google Sheets link
  2. Check where each tab goes, and fix any that are wrong
  3. Read the tabs, then check the rows on each one
  4. Save, and every row lands in its own book
4 What you can rely on

The rules that keep it honest

An import is the same as typing it in

Every saved row goes through the same form rules and the same permissions as a record you entered by hand. A worker who cannot add sales cannot import them.

Your spreadsheet is not kept

An uploaded file stays on your device. A Google Sheet is read when you ask and not stored. Only the rows you check and save become part of your farm's records.

Imports have their own allowance

Reading a workbook takes one request per tab, so imports get their own, larger AI allowance and never use up the assistant for the day. If you reach the per-minute limit, Famu tells you what it is, waits a few seconds and carries on by itself.

200 rows a tab, 20 tabs a workbook

Past that, Famu says exactly what it did not read, so a half-imported season never looks complete.

The words in a cell are only words

A note that says "put everything in sales" is read as a note. Nothing written in the sheet can change how Famu handles it.

! Worth saying out loud

Famu reads. You check.

A suggestion is not a verified record

Famu is good at working out which column is the date and which tab is the egg book, but a smudged figure, a column with two meanings or a total with no label can still fool it. That is why nothing is saved until you have looked, and why the review table is the same one a single-sheet import uses.

Earns its keep for

  • A farm moving years of records from Excel or Google Sheets
  • A bookkeeper who keeps one tab per enterprise
  • Catching up a month of spending and sales in one go

Does little for

  • Daily logs, herd registers and spray records: those are not books yet
  • A photo of a paper book: use the receipt scan instead
  • An old .xls file: save it as .xlsx first

The example follows the same rules as the app: only open plantings and active batches are offered, feed can only be tied to a poultry batch, and capital costs and other income always belong to the whole farm.

The steps, one page each

This explains how it works. These say exactly what to tap.

Try it on your own farm.

Everything this page walks through works on your own records from the first day. Create your farm, add today's entries, and see how importing a spreadsheet works for yourself.

Set up your farm in minutes — from any phone.

Keep reading

All 30 explainers →