CSV with Dot-Notation Headers to Nested JSON
Use dot-notation columns to rebuild nested objects from a spreadsheet or a previous JSON-to-CSV export.
A specific workflow: CSV with Dot-Notation Headers to Nested JSON
A CSV export uses columns such as user.name and user.address.city, but your API expects a nested user object.
Example input
user.name,user.address.city Ari,Jakarta
Expected output
[
{
"user": { "name": "Ari", "address": { "city": "Jakarta" } }
}
]How to use CSV to JSON
Paste or upload your CSV
Paste CSV text or open one or more .csv files exported from Excel, Google Sheets or a database client. Everything stays on your machine.
Headers become JSON keys
The first row is read as the header row and each column name becomes a property on every record. Switch to the Table view first if you want to sanity-check how the columns were detected.
Copy or download the JSON
Get back a formatted array of objects you can paste straight into a test fixture, a seed script or an API request body.
Other Parsefy tools
JSON to CSVTurn JSON arrays and API responses into spreadsheet-ready CSV, with nested data flattened automatically.CSV to JSONTurn CSV and spreadsheet exports into structured JSON, with headers mapped to keys and types detected automatically.JSON FormatterBeautify and validate minified JSON with readable indentation and clear syntax error messages.CSV ViewerOpen CSV files as a readable table in your browser, without Excel and without uploading the file.JSON to ExcelExport JSON as a real .xlsx workbook with formatted headers, ready to open in Excel or Google Sheets.CSV to ExcelConvert CSV into a real .xlsx workbook with correct UTF-8 encoding and a formatted header row.Flatten Nested JSONCollapse deeply nested JSON into flat keys with dot or bracket notation, then export the result as CSV.JSON ValidatorCheck whether JSON is valid and pinpoint the exact line, column and snippet where parsing fails.JSON MinifierStrip whitespace from JSON to shrink payloads, with a before-and-after byte count.