The basic rule for Excel to JSON is simple: headers become field names, and each row becomes a JSON object.
[
{
"name": "Alice",
"email": "alice@example.com",
"active": true
}
]Clean the Sheet Before Conversion
- Use the first row as field names and avoid empty or duplicate headers.
- Keep each column to one kind of data.
- Decide whether date columns should remain text or become date strings.
- Remove merged cells, notes, and summary rows before conversion.
- If the file has multiple sheets, confirm which sheet the tool reads.
Common Issues
| Issue | Cause | Suggestion |
|---|---|---|
| Strange field names | Headers contain spaces, line breaks, or duplicates | Normalize headers first |
| Numbers become text | Cell formats are inconsistent | Check key fields after conversion |
| Empty values change | Different blank-cell rules | Normalize according to API needs |
| Dates look wrong | Excel dates may be serial values | Convert dates to text first |