What changes when you convert JSON to CSV?
JSON and CSV represent structured data differently. Column types, nested values, attributes and empty cells may need checking after conversion.
- The source and target formats are fixed by this page, and one file is processed at a time.
- Open the finished CSV file and check fine details, layout and compatibility in the app where you plan to use it.
Source formatWhat is a JSON file?
JSON (JavaScript Object Notation) is the standard text format for structured data on the web. It stores information as readable key-value pairs and is used by almost every API and web app to exchange data.
How to open a JSON file
JSON opens in any text or code editor (VS Code, Notepad) and in the browser.
Output formatWhat is a CSV file?
CSV (Comma-Separated Values) is a simple, universal text format for tabular data. Each line is a row and commas separate the columns, which makes it easy to move data between spreadsheets, databases and almost any program.
How to open a CSV file
CSV opens in Excel, Google Sheets, LibreOffice Calc, or any plain-text editor.