CSV to JSON

Yes. Values wrapped in double quotes can contain commas, new lines and doubled quotes, as in standard CSV exported by Excel and Google Sheets. If a quote is never closed, the tool reports it with its line number, so you can find the broken row quickly instead of getting garbled output.

Values like 0123 are kept as text on purpose. Only plain numbers without leading zeros become JSON numbers. That protects PIN codes, phone numbers and IDs from being changed. You can also switch number detection off to keep every value as text, which suits many APIs.

Yes. The separator is detected from the first line, or you can choose comma, semicolon, tab or pipe yourself. Many European and some Indian Excel exports use semicolons, and database dumps often use tabs or pipes, so the right choice is usually picked for you.

Untick the header option and you get a list of lists instead of a list of objects. Each inner list holds one row's values in order. That suits files where column positions are fixed and known, or where you plan to add your own key names in code.

Each header cell becomes a key as written, with spaces at either end trimmed. A blank header becomes column1, column2 and so on, and a repeated name gets _2 added. If you need keys like first_name rather than 'First Name', rename the headers in your spreadsheet before exporting.

Plain numbers such as 42 or 3.5 become JSON numbers, true and false become booleans and null becomes null. Everything else, including numbers with leading zeros, stays a string, and empty cells become empty strings. Switch detection off if your API wants every value as text.

The tool reads CSV, which is plain text. An .xlsx file is a different format. In Excel or Google Sheets, use File, Save as or Download and choose CSV first. Choose CSV UTF-8 in Excel so that names in Indian scripts and the rupee sign are kept.

Yes. In Google Sheets choose File, Download, Comma-separated values, then open that file here. Google exports UTF-8 with commas, which the tool detects automatically. Each sheet tab is exported separately, so repeat this for every tab you need. Hidden columns are exported too, so delete any you don't need before downloading.

Conversion runs in your browser, so the limit depends on your device's memory. Files of several megabytes convert comfortably on a laptop. For very large exports, split the file or use a script on your own machine, because a giant JSON result is slow to view in any browser.

Yes. The JSON is indented so it's easy to read and check. If you need it on one line, paste the result into the JSON formatter and choose Minified. Then copy it straight into a request body, a database field or a configuration setting. Two-space indentation is used by default.

Completely empty lines, often found at the end of exported files, are skipped so you don't get empty records. A row with separators but no values still becomes a record with empty strings, because it might be meaningful in your data. That keeps the JSON list clean without any manual editing.

Yes, if the system accepts JSON. Many accept CSV directly, which is simpler. Marketiism imports contacts from a CSV file without any conversion. Use this tool when an API or script specifically wants a JSON list of records. Check the target system's import guide for the exact field names it expects.

No. The file is read and converted in your browser, so customer lists, prices and other records never reach our servers. Nothing is stored after you close the page. That's important for spreadsheets with personal details such as phone numbers and addresses. Close the tab when you're done and nothing remains.

Yes. Open a CSV from your phone's files or paste text, and download data.json when it's done. Reading long JSON is easier on a bigger screen, but the conversion works on any modern mobile browser, entirely on your device and without an app. It's handy for a quick check.

Yes. It's free with no sign-up and no limit on use. It's one of the free developer tools from Marketiism, together with the JSON to CSV converter and the JSON formatter. Marketiism also builds software for WhatsApp, billing and CRM. Use it as often as you need.