When a consultant takes on a large farmer group, most of the early work is data: hundreds of names, land records and crops. Entered by hand, one record at a time, it is slow and error-prone. This episode sets out how to collect, clean and move large farmer data sets accurately.
The short version
- Collect in one standard sheet, one row per farmer.
- Clean before you enter anything: duplicates, spellings, units.
- Migrate old records by mapping fields, not by retyping.
- Check a sample against the originals after every batch.
Collecting Large Groups
Use one sheet with fixed columns, filled from original documents at the village.
- Fixed columns.Name, father's or husband's name, Aadhaar, mobile, village, survey number, area in hectares, crops.
- Fill at the village.From the Aadhaar card and land record, not from memory.
- One row per farmer.Plots in a linked sheet if a farmer has several.
- Record the source.Note who collected each row, and when.
Cleaning Before Entry
Remove duplicates, fix spellings to the portal's lists, and convert units.
| Problem | Fix |
|---|---|
| Same farmer twice | Match on Aadhaar number, not on name |
| Village spelt differently | Use the spelling in the portal's list |
| Area in acres or local units | Convert to hectares (acres ÷ 2.471) |
| Numbers stored as text or scientific notation | Format ID columns as Text before typing |
Illustrative workload. At about three minutes per farmer to clean and check, a 300-farmer group takes about 15 hours; entering it clean the first time avoids a second round.
Moving Old Records
Put old records into one format, map old fields to new ones, then check a sample.
- Gather old spreadsheets and notes into one common format.
- Remove duplicates and correct known errors.
- Map each old field to the new field; do not retype what can be copied.
- After each batch, check a sample of records against the original documents.
Check yourself
Tap an answer to see whether you are right, and why.
How should duplicate farmers be found?
- By name
- By Aadhaar number
- By village
Names are spelt differently too often.
How do you convert 5 acres to hectares?
- 5 × 2.471
- 5 ÷ 2.471
- 5 × 10
About 2.02 hectares.
Remember these things
- One standard sheet.
- Clean before entry.
- Map old fields; do not retype.
- Check samples after each batch.
Clean data at the start saves a second round of corrections. KrushiFlow validates these fields and submits farmer records to the portal in bulk.