Practical usage guide
What this tool does
CSV is a family of delimiter-separated formats rather than one perfectly uniform specification. This converter supports comma, tab, semicolon, and pipe delimiters, quoted fields, escaped double quotes, and line breaks inside quoted cells. It can also turn arrays of objects or arrays into delimited rows.
Use the preview as a data-shape check, not as a replacement for a database import validator. CSV cells are text, so values such as 00123, true, and 2026-07-15 are not automatically assigned application types.
Quick start
Choose the conversion direction
For CSV to JSON, select the delimiter and whether the first row is a header. For JSON to CSV, provide an array of objects or an array of arrays.
Check headers before converting
Make header names unique and meaningful. Trim accidental spaces if downstream systems treat name and name-space as different fields.
Validate a small sample
Review quoted commas, embedded line breaks, empty cells, and non-ASCII text before converting a much larger dataset.
Common use cases
Prepare spreadsheet data for an API
Convert a small export into an object array that is easier to inspect or send as a JSON request.
Create a flat CSV export
Turn a flat list of records into rows that can be opened in spreadsheet software or imported elsewhere.
Diagnose delimiter problems
Switch between comma, tab, semicolon, and pipe to identify why a file is being parsed into the wrong number of columns.
Limitations and important notes
Duplicate headers overwrite earlier columns
When converting header-based CSV to objects, repeated header names collapse into one property. Rename duplicate columns before conversion.
JSON to CSV is intended for flat values
Nested objects and arrays are not flattened. They can become generic text such as [object Object], so transform nested data first.
CSV values remain strings
The converter does not infer numbers, booleans, dates, or null. Apply types in the destination system with rules appropriate to your data.