CSV to JSON: Spreadsheet to API Payload

A CSV export is the fastest way to move data out of a spreadsheet, and JSON is the fastest way to move it into an application. The conversion is one step, but the details decide whether the result works on the first try.

How the header row becomes keys

The first row is read as field names. Every following row becomes one object, with those names as keys. If a header cell is empty, the converter names the column `column_N` so no data is dropped.

Four things that break CSV parsing

• Commas inside values — `"Smith, John"` must be quoted, otherwise it splits into two columns
• Quotes inside quotes — escaped as `""` in standard CSV
• A byte-order mark at the start of Excel exports, which corrupts the first header name
• Ragged rows — a missing trailing cell shifts every value after it

Numbers arrive as strings

CSV has no types. Every value is text, so `30` becomes the string `"30"` unless you cast it later. This is usually what you want for identifiers (a phone number starting with zero stays intact) but not for arithmetic.

How to convert

1. 1Open the CSV to JSON tool.
2. 2Paste the CSV, including the header row.
3. 3Convert, then check that the first object has the keys you expect.
4. 4Copy the array into your seed file or API request.

Frequently asked questions

Can I convert Excel files directly?

Save as CSV first (File → Save as → CSV UTF-8). That preserves non-Latin characters; the plain CSV option may not.

Why is my JSON an array of strings?

Because CSV cells are text. Post-process the fields you need as numbers or booleans, or let your application parse them on read.

What about very large files?

Browser tools handle a few megabytes comfortably. For hundreds of megabytes, stream the conversion in code rather than pasting it into a page.