MongoDB / Firebase exports
Take a `mongoexport` JSON dump and produce a CSV ready for Excel or BigQuery import.
Convert JSON to CSV online free. Paste or upload JSON arrays and download CSV files instantly.
JSON to CSV is a free online tool that convert JSON to CSV online free. Paste or upload JSON arrays and download CSV files instantly. No files are uploaded — everything is processed locally on your device.
JSON to CSV conversion transforms a JSON array of objects into a flat, comma-separated-values table that Excel, Google Sheets, and LibreOffice Calc open natively. This converter processes 50,000 rows in under 2 seconds on modern hardware and handles files with nested objects via dot-notation flattening. JSON is defined by ECMA-404 (and RFC 8259); CSV is described in RFC 4180. Converting between them is essential for data analysts receiving API responses or database exports in JSON but needing a spreadsheet to sort, filter, or visualize. JSON (JavaScript Object Notation) stores data hierarchically with nested objects and arrays. CSV stores data as a flat table with rows and columns. Converting between them requires flattening nested structures — for example, {"user": {"name": "Alice", "age": 30}} becomes two columns: "user.name" and "user.age" using dot notation. Nested arrays can be joined into a single cell or expanded into multiple rows depending on configuration. Common use cases: exporting API response data for reporting, converting MongoDB or Firebase exports into spreadsheets, preparing datasets for import into SQL databases or BI tools like Tableau, and sharing structured data with colleagues who work in Excel. Delimiter options cover US locales (comma), European locales (semicolon), and tab-separated format (TSV) used in data warehousing. Our converter processes everything locally in your browser using JavaScript — your data never leaves your device. This makes it safe for converting sensitive datasets containing personal information, financial records, or proprietary business data. There are no file size limits, no daily conversion caps, and no account required. Whether you searched for a JSON to CSV converter, JSON CSV converter, JSON to CSV parser, or simply wanted to convert a JSON file to CSV, parse JSON to CSV, or transform JSON into CSV format — this tool covers every variation.
Privacy guarantee: JSON to CSV processes all files directly in your browser using WebAssembly. No data is uploaded to any server, no information is collected, and the tool works offline after loading. Unlimited usage with no signup, no watermarks, and no file size limits.
Paste a JSON array of objects into the input area, or click the upload button to select a .json file from your device. The converter accepts arrays like [{...}, {...}] where each object becomes one CSV row.
Choose your delimiter (comma for Excel, semicolon for European locales, tab for TSV). Toggle whether to include a header row. Select how nested objects should be flattened — dot notation (address.city) or bracket notation (address[city]).
Review the CSV output in the preview pane. Click Download to save as a .csv file, or Copy to clipboard to paste directly into a spreadsheet or text editor.
JSON is defined by RFC 8259 (Tim Bray, Dec 2017) and the parallel ECMA-404 standard; CSV is defined by RFC 4180 (Yakov Shafranovich, Oct 2005). Modern V8 parses JSON at roughly 80–100 MB/s, so a typical 10,000-row API response converts to CSV in well under 100 ms client-side, no server round-trip needed.
| Scenario | Best Choice | Why |
|---|---|---|
| API response with flat objects | Browser converter (this tool) | No upload, instant, runs in a tab |
| Nested objects (address.city) | Dot notation flattening | Same convention as pandas json_normalize and Power Query |
| Nested arrays (tags[]) | Explode to multiple rows | Keeps each tag query-able vs joined string |
| European Excel locales | Semicolon delimiter | en-US Excel expects comma; de-DE/fr-FR expect semicolon (system list separator) |
| Files > 1.05M rows | Split CSV or use Parquet | Single Excel sheet caps at 1,048,576 rows × 16,384 cols |
| Long-term archival of nested data | Keep original JSON | Flattening loses structural fidelity |
Take a `mongoexport` JSON dump and produce a CSV ready for Excel or BigQuery import.
Paste a Postman or fetch() response and hand off to an analyst working in Sheets, no auth required.
Convert nested record exports into flat CSV columns matching your destination schema.
Standardize column headers across recurring analytics pipelines so dashboards do not break on schema drift.
Convert in-browser when data contains PII, financial records, or under-NDA content, no server ever sees the file.
Save responses, then export via Postman Collection Runner, or skip the loop and paste here.
Nested objects are flattened using dot notation for column names. For example, {"address": {"city": "NYC", "zip": "10001"}} becomes two columns: "address.city" with value "NYC" and "address.zip" with value "10001". Nested arrays are joined into a comma-separated string within a single cell by default.
Yes. Select comma as the delimiter for maximum compatibility with Excel. The output is a standard .csv file that Excel, Google Sheets, LibreOffice Calc, and all major spreadsheet applications open natively. For European versions of Excel that use semicolons, select the semicolon delimiter instead.
A JSON array of objects, like [{"name": "Alice", "age": 30}, {"name": "Bob", "age": 25}]. Each object becomes a row, and each unique key becomes a column header. A single JSON object (not in an array) is also supported and converts to a single-row CSV.
Upload the file using the file upload button rather than pasting. The converter processes files locally using your device hardware, so large files (10,000+ records) work fine on modern devices. Processing time depends on file size and your device speed — a 50,000-record file typically converts in a few seconds.
Yes. Copy the JSON response body from your API client (Postman, Insomnia, browser DevTools) and paste it directly into the input field. If the API returns a wrapper object like {"data": [{...}]}, paste only the array portion or the converter will attempt to flatten the wrapper.
CSV (Comma-Separated Values) uses commas as delimiters. TSV (Tab-Separated Values) uses tabs. TSV is useful when your data contains commas (like addresses). Select "tab" as the delimiter in this converter to produce TSV output. Both formats are supported by Excel and Google Sheets.
Paste your JSON array into the input pane (or upload a .json file), choose comma as the delimiter for Excel compatibility, then click Download to save the CSV. There is no upload, no signup, no email gate. Modern V8 parses JSON at roughly 80–100 MB/s, so a typical 10,000-record API response converts in well under 100 ms.
Yes. Nested objects are flattened with dot notation by default — the same convention used by pandas `json_normalize` and Power Query. So `{"address": {"city": "NYC"}}` becomes a column named `address.city`. For nested arrays you can either join values into a single cell or explode them into multiple rows.
Yes. Paste output from `mongoexport`, Firebase BigQuery exports, Postman saved responses, or Airtable exports directly. JSON is defined by RFC 8259 (Tim Bray, Dec 2017) and parallel ECMA-404 — any spec-compliant JSON parses cleanly here.
Excel for Windows requires a UTF-8 byte-order mark (the three bytes `EF BB BF`) at the start of the file or it falls back to Windows-1252 and mojibakes accented characters. This converter writes the BOM by default, so accented text in names, addresses, and product titles renders correctly in Excel for Windows.
CSV to JSON
Convert CSV data to JSON arrays instantly in your browser.
XML to JSON
Convert XML documents to JSON format in your browser — no server needed.
JSON to XML
Convert JSON data to XML format instantly in your browser.
YAML to JSON
Convert YAML to JSON format instantly in your browser.
Markdown to HTML
Convert Markdown text to HTML code instantly in your browser.
HTML to Markdown
Convert HTML code to Markdown format instantly in your browser.
CSV to Excel
Convert CSV files to Excel (.xlsx) spreadsheets instantly in your browser.
Markdown to PDF
Convert Markdown files to beautifully formatted PDF documents in your browser.
Merge PDF — Free Online
Combine multiple PDF files into one document — entirely in your browser, no uploads.
Compress Image — Free Online
Reduce image file size while preserving quality — no uploads, browser only.
QR Code Generator — Free Online
Generate QR codes for URLs, text, email, and more — entirely in your browser.
JSON Formatter — Free Online
Format, validate, and minify JSON data in your browser. Supports syntax highlighting.
MP4 to MP3 — Free Online
Extract audio from video files and save as MP3, entirely in your browser.
Password Generator — Free Online
Generate strong, random passwords with customizable length and character sets.
Hash Generator — Free Online
Generate SHA-1, SHA-256, SHA-384, and SHA-512 hashes from any text — entirely in your browser.