🧰Locly

Convert CSV to JSON & JSON to CSV

Convert between CSV and JSON formats instantly, processed locally in your browser

Delimiter:

About This Tool

Convert between CSV (Comma-Separated Values) and JSON (JavaScript Object Notation) formats instantly. This tool handles both directions: CSV to JSON for data processing, and JSON to CSV for spreadsheet import. All conversion is processed locally in your browser β€” your data never leaves your device.

How to Use

  1. Paste CSV in the left panel or JSON in the right panel
  2. Or click 'Upload File' to load a CSV or JSON file
  3. Adjust options: delimiter, header row, pretty print
  4. Click 'CSV β†’ JSON' or 'JSON β†’ CSV' to convert
  5. Copy the result or download as a file

Common Use Cases

  • Data analysis: Convert CSV exports to JSON for JavaScript processing
  • API development: Transform JSON API responses to CSV for spreadsheets
  • Database import: Convert between formats for different database tools
  • Spreadsheet work: Export JSON data to CSV for Excel or Google Sheets
  • Configuration: Convert config files between formats

FAQ

Q1: What JSON structure is expected?

For JSON to CSV, provide an array of objects with consistent keys. Each object becomes a row, and keys become column headers.

Q2: How are nested objects handled?

Nested objects are flattened using dot notation (e.g., 'address.city'). Arrays are joined with commas.

Q3: Can I use different delimiters?

Yes! Choose from comma, semicolon, tab, or pipe delimiters for CSV. This is useful for different regional formats or data with commas in values.

Q4: Is my data uploaded anywhere?

No. All conversion happens locally in your browser. Your data never leaves your device, making this safe for sensitive information.

Q5: What if my CSV has no header row?

Uncheck 'First row is header' and the converter will generate column names (col1, col2, etc.).

Related Tools

JSON FormatterJSON ↔ YAML