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.

Turn lists of JSON objects into CSV spreadsheets, and CSV spreadsheets into JSON. The conversion works both ways.

Tool

Options

ConvertCSV separator

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 JSON to CSV to open in Excel, or CSV to JSON. Flattens nested objects and detects the separator. Free and 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.