How to Format CSV/XLSX for Bulk Respondent Import
Data Management
•
40 Views
•
May 19, 2026
To upload recall spreadsheets successfully, ensure your files adhere to standard FoodQuant column mapping specifications.
Required Column Headers
When uploading dietary recall sheets, include headers for:
Respondent ID (or ID, Name)Food Description (e.g. cooked white rice)Amount Consumed (in grams, milliliters, or household measures)
Sample Layout
| Respondent ID | Food Name | Weight (g) |
| :--- | :--- | :--- |
| RESP001 | Cooked White Yam | 150 |
| RESP001 | Palm Oil | 10 |
| RESP002 | Boiled Catfish | 200 |
Chunked Upload Mechanics
For files exceeding 5MB, FoodQuant utilizes safe chunked uploads in the background. Do not close the window until the green completion check appears.
Was this article helpful?
Help us improve the Help Desk for researchers worldwide.
