Enter CSV in the editor and click 'Convert' to get JSON output.
A valid CSV input has a header row with column names, followed by data rows. Values must be separated by commas and each line represents a new record. You can export CSV files from Excel, Google Sheets, or any spreadsheet application. For example:
tool,category,platform Excel,Spreadsheet,Windows Google Sheets,Spreadsheet,Web Notion,Productivity,Cross-platform
The output will be a JSON array. Each CSV row becomes an object with column headers as keys. The output of the above CSV will be:
[
{
"tool": "Excel",
"category": "Spreadsheet",
"platform": "Windows"
},
{
"tool": "Google Sheets",
"category": "Spreadsheet",
"platform": "Web"
},
{
"tool": "Notion",
"category": "Productivity",
"platform": "Cross-platform"
}
]Use consecutive commas (,,) to represent empty values. If the empty value
is at the end of a row, just include a trailing comma.
The empty values in the CSV will be converted as empty strings. For example:
tool,category,platform Excel,,
is converted to
[
{
"tool": "Excel",
"category": "",
"platform": ""
}
]