CSV to JSON Converter
Convert CSV to a JSON array of objects in your browser. Header row becomes keys, numbers and booleans are typed automatically. Free and private.
About this tool
Paste CSV (or drop a .csv file) and get a clean JSON array of objects: the header row becomes the keys, and each following line becomes one object. Numbers and booleans are automatically typed, so "42" becomes 42 and "true" becomes true.
Quoted fields, embedded commas, and multi-line cells are handled correctly per RFC 4180, the cases where hand-rolled split(',') scripts silently corrupt data.
Common uses
- Convert a spreadsheet export into seed data for a database or fixture file.
- Feed CSV reports into a JavaScript or Python script as structured objects.
- Prepare bulk-import payloads for APIs that accept JSON arrays.
Automate via API
The same conversion is available as a REST endpoint for scripts, pipelines, and backends:
curl -X POST https://payloadly.com/api/v1/tools/csv-to-json \ -H "Content-Type: text/plain" \ -H "X-Api-Key: YOUR_API_KEY" \ --data-binary @input.csv
Worked examples
Real payloads from tools people use daily, with the exact output this converter produces. Every example runs in your browser, so you can load one and adapt it to your own data.
Convert a Shopify product export to JSON
Shopify's product export is CSV; converting to JSON gives you typed objects ready to send to the Admin API or a script.
Handle,Title,Vendor,Variant Price,Variant Inventory Qty classic-tee,Classic Tee,Atlas,19.99,120 canvas-tote,Canvas Tote,Atlas,24.00,58
[
{
"Handle": "classic-tee",
"Title": "Classic Tee",
"Vendor": "Atlas",
"Variant Price": 19.99,
"Variant Inventory Qty": 120
},
{
"Handle": "canvas-tote",
"Title": "Canvas Tote",
"Vendor": "Atlas",
"Variant Price": 24,
"Variant Inventory Qty": 58
}
]Convert a HubSpot contacts export to JSON
HubSpot exports contacts as CSV; the header row becomes object keys and numeric columns are typed automatically.
Email,First Name,Last Name,Lifecycle Stage grace@example.com,Grace,Hopper,customer ada@example.com,Ada,Lovelace,lead
[
{
"Email": "grace@example.com",
"First Name": "Grace",
"Last Name": "Hopper",
"Lifecycle Stage": "customer"
},
{
"Email": "ada@example.com",
"First Name": "Ada",
"Last Name": "Lovelace",
"Lifecycle Stage": "lead"
}
]Convert an Airtable CSV export to JSON
Airtable's grid view exports to CSV; converting back to JSON is handy for re-importing through the API.
Name,Status,Estimate Launch plan,In progress,5 Q3 roadmap,Done,8
[
{
"Name": "Launch plan",
"Status": "In progress",
"Estimate": 5
},
{
"Name": "Q3 roadmap",
"Status": "Done",
"Estimate": 8
}
]CSV notes
CSV (comma-separated values) is the lingua franca of spreadsheets, analytics exports, and bulk imports. It is tabular and flat: every row shares one set of columns, so nested structures must be flattened.
- Fields containing commas, quotes, or newlines must be quoted per RFC 4180.
- CSV has no type system; numbers and booleans are inferred on import.
- Nested objects are flattened to dot-notation columns (e.g. `user.name`).
JSON notes
JSON (JavaScript Object Notation) is the standard interchange format for web APIs, config files, and log pipelines. It is strict: keys must be double-quoted, trailing commas are invalid, and comments are not allowed.
- JSON does not support comments; they are stripped or rejected by parsers.
- Trailing commas after the last element are invalid JSON.
- Integers beyond 2^53 lose precision in JavaScript-based parsers.
Frequently asked questions
Is my data uploaded to a server?
No. This tool runs entirely in your browser using JavaScript, and there are no ads on the page. Nothing you paste or drop here is uploaded, logged, or stored, and you can verify that yourself: open your browser's developer tools and watch the Network tab while you convert (no requests leave the page), or disconnect from the internet after the page loads and keep working.
What should I watch out for when converting CSV to JSON?
Fields containing commas, quotes, or newlines must be quoted per RFC 4180. CSV has no type system; numbers and booleans are inferred on import. JSON does not support comments; they are stripped or rejected by parsers. Trailing commas after the last element are invalid JSON.
Is there a size limit or a fee?
The browser tool is free with no signup and comfortably handles files up to tens of megabytes (limited by your device's memory). For automated or bulk processing inside your own scripts and pipelines, use the paid REST API.
Related tools
Extract specific columns from a CSV in your browser. Pick columns by name, preserve quoting, drop the rest. Free, private, no upload.
Convert JSON arrays or objects to CSV in your browser. Flattens nested keys to dot notation, handles quoting per RFC 4180. Free, private, no upload.
Convert CSV to TSV in your browser. Correctly re-quotes fields containing tabs or newlines. Paste straight into Excel or Sheets. Free.
Flatten nested JSON to single-level dot-notation keys in your browser. Ideal for CSV prep, diffing, and key inventories. Free, no upload.