Why does my CSV open in a single column in Excel?

Excel set to some European languages expects a semicolon as the separator. Choose "semicolon" when creating the CSV for those users.

What happens to objects inside objects?

They become columns with the full path, like "address.city". Lists inside objects are saved as JSON text in the cell.

Paste the content of a CSV and get JSON with one object per row, using the first row as the field names.

Tool

Options

ConvertCSV separatorFirst row is the headerConvert numbers and true/false

Original text

0 characters · 0 words · 0 lines

Result

0 characters · 0 words · 0 lines

Everything is processed in your browser. Your text and files are never sent to a server.Questions about this tool?

Convert CSV spreadsheets to JSON, with headers, separator detection and number conversion. Free and right in your browser.

Why does my CSV open in a single column in Excel?: Excel set to some European languages expects a semicolon as the separator. Choose "semicolon" when creating the CSV for those users.
What happens to objects inside objects?: They become columns with the full path, like "address.city". Lists inside objects are saved as JSON text in the cell.