DataScrub

JSON ↔ CSV Converter

Convert between CSV, Excel, ODS, and JSON formats easily.

Drag & drop your file here

or click to browse

CSVTSVExcelODSJSON

Convert Between JSON and CSV Instantly

Data comes in many formats, and they don't always play nice together. APIs return JSON, spreadsheets expect CSV, and databases export in proprietary formats. DataScrub converts between JSON, CSV, Excel, and ODS with one click — no command-line tools or Python scripts needed.

How to Convert JSON to CSV

  1. Upload your JSON file or paste JSON text directly into the converter.
  2. The converter parses the structure automatically and detects keys as column headers.
  3. Preview the tabular result to verify the mapping looks correct.
  4. Download the output as CSV or Excel.

How to Convert CSV to JSON

  1. Upload your CSV, Excel, or ODS file into the converter.
  2. The converter reads the headers and rows and builds a JSON array of objects.
  3. Preview the JSON output to confirm the structure matches your expectations.
  4. Copy the JSON to your clipboard or download it as a file.

When You Need Format Conversion

  • Importing API data into Excel for reporting or analysis.
  • Exporting spreadsheets for use in web applications that consume JSON.
  • Preparing data for NoSQL databases that require JSON documents.
  • Sharing data with teams using different tools and formats.
  • Archiving data in a universal, human-readable format.

Tips for Smooth Conversions

  • JSON arrays of objects convert best to CSV — each object becomes a row and each key becomes a column.
  • Nested JSON will be flattened automatically, but deeply nested structures may produce many columns.
  • CSV with inconsistent columns across rows may result in empty fields in the output — check the preview carefully.
  • Use the preview step to catch conversion issues before downloading the final file.

Frequently Asked Questions

Does it handle nested JSON?

Yes. Nested objects are flattened into dot-notation column headers (e.g., "address.city"). Deeply nested structures will produce more columns, so review the preview to ensure the result meets your needs.

Can I convert Excel to JSON?

Yes. Upload an .xlsx, .xls, or .ods file and the converter will read the first sheet, treat the header row as keys, and produce a JSON array of objects. Each row becomes one object in the array.

What happens to special characters?

Special characters like commas, quotes, and Unicode are handled correctly. In CSV output, values containing commas or quotes are properly quoted. In JSON output, all characters are escaped according to the JSON specification.

Is there a file size limit?

Since all processing happens in your browser, the practical limit depends on your device's available memory. Files up to roughly 50 MB should work on most modern computers. Very large files may cause the browser to slow down or run out of memory.