--- title: "JSON CSV Converter" description: "Convert JSON to CSV and CSV to JSON online, both directions on one page. Paste a JSON array or a CSV file and get the other format instantly. Handles nested objects, quoted commas, custom delimiters, and headerless files. Runs in your browser." url: https://findutils.com/convert/json-to-csv/ category: convert --- # JSON CSV Converter Convert JSON to CSV and CSV to JSON online, both directions on one page. Paste a JSON array or a CSV file and get the other format instantly. Handles nested objects, quoted commas, custom delimiters, and headerless files. Runs in your browser. **Use this tool:** [JSON CSV Converter](https://findutils.com/convert/json-to-csv/) ## Programmatic access - REST id `json-to-csv`: POST https://api.findutils.com/api/tools/json-to-csv/execute (reference: https://findutils.com/api/json-to-csv/) - MCP tool `json_to_csv` on https://mcp.findutils.com (reference: https://findutils.com/mcp/json-to-csv/) ## Why Use Our JSON CSV Converter? JSON is the standard data format for APIs and web services, but spreadsheets, databases, and business intelligence tools expect tabular data in CSV format. Manually restructuring JSON arrays into rows and columns is tedious, error-prone, and impractical for datasets with hundreds or thousands of records. This converter bridges the gap instantly: paste a JSON array of objects, click Convert, and get a properly escaped CSV file ready for Excel, Google Sheets, or any data analysis pipeline. All processing happens in your browser, so your data stays private and never touches a server. ## JSON to CSV Conversion Tips - Always start with a JSON array of objects where each object has consistent keys. Inconsistent keys still work, but missing fields will produce empty cells in those columns. - Nested objects and arrays are stringified into a single CSV cell. If you need flat columns, flatten your JSON structure first using the jq Playground or a script before converting. - Check that your JSON is valid before converting. A missing comma or bracket will cause a parse error. Use the JSON Formatter to validate and fix syntax issues first. - For very large datasets (5,000+ rows), the conversion still runs in your browser but may take a moment. Let it finish before copying or downloading. - When opening CSV files in Excel, use the import wizard to set the delimiter to comma and encoding to UTF-8. This prevents character encoding issues with accented or special characters. ## Frequently Asked Questions ### What JSON format is supported? The converter works best with a JSON array of objects, for example [{"id":1,"name":"Alice"},{"id":2,"name":"Bob"}]. Each object in the array becomes a row in the CSV, and all unique keys across the objects become column headers. Single objects are also supported and produce a one-row CSV. ### How are nested objects and arrays handled? Nested objects and arrays are serialized as JSON strings within their CSV cell. For example, an address object like {"city":"London","zip":"E1"} appears as a single quoted string in the cell. If you need flat columns, preprocess your JSON to flatten nested structures before converting. ### Is the conversion secure and private? Yes. All conversion happens entirely in your browser using JavaScript. Your JSON data is never sent to any server, never stored, and never logged. This makes it safe for converting sensitive data including customer records, API responses with tokens, and proprietary datasets. ### Can I open the CSV result in Excel or Google Sheets? Yes. Click Download CSV to save a.csv file that opens directly in Microsoft Excel, Google Sheets, Apple Numbers, or LibreOffice Calc. For best results with special characters, use the UTF-8 encoding option when importing into Excel. ### Is there a file size or row limit? There is no server-side limit because all processing happens in your browser. In practice, the tool handles JSON arrays with thousands of objects and files up to several megabytes smoothly. Performance for very large datasets depends on your device's available memory. ### What happens when objects have different keys? The converter collects all unique keys from every object in the array and uses them as column headers. If an object is missing a particular key, the corresponding CSV cell is left empty. No data is lost, and the output remains a valid rectangular CSV. ### How are commas and special characters handled in values? Values containing commas, double quotes, or newlines are automatically wrapped in double quotes following the RFC 4180 CSV standard. Double quotes within values are escaped by doubling them. This ensures the CSV parses correctly in any compliant reader. ### Does this JSON to CSV converter require a signup? No. It is available with no signup, no usage limits. You can convert JSON to CSV as many times as you need without creating an account or paying for any plan. ### Can I convert CSV back to JSON on this page? Yes. This page converts both directions. Paste CSV instead of JSON and the tool switches to CSV to JSON automatically, or use the direction toggle above the editor. Each CSV row becomes one JSON object keyed by the header row. Turn off "First row is header" to get an array of arrays instead, which is the correct shape for a headerless file. The delimiter can be a comma, semicolon, tab, pipe, or any character you type. ### What is the difference between JSON to CSV and JSON to Excel? CSV is a plain text format that any spreadsheet application can open, while Excel (.xlsx) is a proprietary binary format with formatting, formulas, and multiple sheets. Converting JSON to CSV gives you maximum compatibility across tools. Once you have the CSV, you can import it into Excel and add formatting as needed. ### Can I use a delimiter other than a comma? Yes, the converter supports comma, semicolon, tab, and pipe delimiters. Choose the one that matches your CSV format. ### Can I convert NDJSON or JSON Lines (.jsonl) with this tool? No. This page reads one JSON document: an array of objects or a single object. A file with one JSON object per line is JSON Lines, also called NDJSON or JSONL, and it is not valid JSON as a whole. Use the NDJSON to CSV tool for that shape; it flattens nested keys, unions the columns across rows, and skips a bad line with a note. CSV to NDJSON does the reverse. ### What happens to empty values and empty lines? Empty values are converted to empty strings in JSON. Empty lines can be optionally skipped using the 'Skip empty lines' option. ## Related Tools - [JSON Formatter](https://findutils.com/developers/json-formatter/) - [JSON YAML Converter](https://findutils.com/developers/json-yaml-converter/) - [JSON to XML](https://findutils.com/convert/json-to-xml/) - [JSON Minifier](https://findutils.com/developers/json-minifier/) - [JQ Playground](https://findutils.com/developers/jq-playground/) - [CSV Viewer](https://findutils.com/convert/csv-viewer/) - [JSON Visualizer](https://findutils.com/developers/json-visualizer/) - [ICS to CSV](https://findutils.com/convert/ics-to-csv/) - [Bookmarks HTML to CSV](https://findutils.com/convert/bookmarks-html-to-csv/) - [NDJSON to CSV](https://findutils.com/convert/ndjson-to-csv/) - [CSV to NDJSON](https://findutils.com/convert/csv-to-ndjson/) - [TSV to CSV](https://findutils.com/convert/tsv-to-csv/)