Json to Csv Converter
Convert JSON data to CSV format and vice versa with field mapping and delimiter options. Enter values for instant results with step-by-step formulas.
Formula
CSV = Headers + Rows (delimited values) | JSON = Array of Objects
JSON to CSV conversion extracts all unique keys from the JSON objects to create column headers, then maps each object values into delimited rows. CSV to JSON conversion uses the first row as object keys and maps each subsequent row into a JSON object with appropriate type detection.
Worked Examples
Example 1: Converting User Data from JSON to CSV
Problem: Convert a JSON array of 3 user objects with name, age, and city fields into a comma-delimited CSV file with headers.
Solution: Input JSON: [{name: Alice, age: 30, city: New York}, {name: Bob, age: 25, city: San Francisco}, {name: Charlie, age: 35, city: Chicago}]\nExtracted headers: name, age, city\nRow 1: Alice, 30, New York\nRow 2: Bob, 25, San Francisco (contains comma in city name - needs quoting)\nRow 3: Charlie, 35, Chicago\nCSV Output with quoted strings for values containing special chars
Result: 3 rows x 3 columns = 9 cells | Headers included | Quoted string values
Example 2: CSV to JSON with Numeric Parsing
Problem: Convert a CSV file with product data (id, name, price, quantity) into properly typed JSON.
Solution: Input CSV:\nid,name,price,quantity\n1,Widget,9.99,100\n2,Gadget,24.50,50\n3,Doohickey,4.99,200\n\nParse headers from first row\nDetect numeric values for id, price, quantity\nPreserve name as string\nOutput: [{id: 1, name: Widget, price: 9.99, quantity: 100}, ...]
Result: 3 objects with 4 fields each | Numbers auto-detected | Valid JSON output
Frequently Asked Questions
What is JSON and when should it be used over CSV?
JSON (JavaScript Object Notation) is a lightweight data interchange format that uses human-readable text to store and transmit data objects consisting of key-value pairs and arrays. JSON is preferred over CSV when your data has nested structures (objects within objects), mixed data types that need to be preserved, variable schemas where different records have different fields, or when the data will be consumed by web APIs and JavaScript applications. JSON preserves data types (strings, numbers, booleans, null, arrays, objects) while CSV treats everything as text. JSON also handles special characters and multi-line values more naturally than CSV. However, JSON files are typically 30-50% larger than equivalent CSV files due to the key names being repeated for every record.
What is CSV format and what are its limitations?
CSV (Comma-Separated Values) is a simple tabular data format where each line represents a row and values within each row are separated by a delimiter (typically a comma). CSV is universally supported by spreadsheet applications like Excel, Google Sheets, and database import tools. Its limitations include no built-in support for nested or hierarchical data, no standard way to represent data types (everything is text), inconsistent handling of special characters across different implementations, and no metadata support. CSV files can also have ambiguity issues with values containing commas, quotes, or newlines, which require special escaping rules. Despite these limitations, CSV remains the most portable and widely used format for flat tabular data exchange.
How do you handle nested JSON objects when converting to CSV?
Nested JSON objects present a challenge when converting to CSV because CSV is inherently a flat, two-dimensional format. Common approaches include flattening the nested structure by concatenating key names with a separator (e.g., address.street, address.city becomes separate columns), serializing nested objects as JSON strings within CSV cells, expanding arrays into multiple rows (one per array element), or creating separate CSV files for related nested data (similar to database normalization). This converter serializes nested objects as JSON strings within CSV cells, preserving the complete data while maintaining a valid CSV structure. For complex nested data, it is often better to keep the JSON format or use a database rather than forcing the data into CSV format.
What delimiter should I use for CSV files?
The most common CSV delimiter is the comma, but several alternatives are used depending on the context and regional conventions. Tab-separated values (TSV, using the tab character) are preferred when data values frequently contain commas, such as address fields or financial numbers in European format. Semicolons are commonly used in European countries where commas serve as decimal separators (e.g., 1.234,56 instead of 1,234.56). Pipe characters are used when data might contain commas, tabs, and semicolons. When choosing a delimiter, consider what characters appear in your data, what software will consume the file, and regional conventions of your target audience. Most modern CSV parsers support configurable delimiters regardless of the file extension.
How do you handle special characters in CSV conversion?
Special characters in CSV require careful handling to prevent parsing errors. The standard approach defined in RFC 4180 specifies that fields containing the delimiter character, double quotes, or newlines must be enclosed in double quotes. Double quote characters within a quoted field are escaped by doubling them (a single quote becomes two consecutive quotes). For example, the value He said Hello becomes He said Hello with doubled quotes inside the outer quotes. Leading and trailing whitespace handling varies by implementation, with some parsers trimming spaces and others preserving them. Unicode characters are generally preserved in UTF-8 encoded CSV files but may cause issues with older parsers expecting ASCII. This converter handles all these cases automatically based on your quoting preferences.
What is RFC 4180 and why does it matter for CSV files?
RFC 4180 is the Internet Engineering Task Force standard that defines the common format and MIME type for CSV files. Published in 2005, it establishes rules that many CSV implementations follow: each record is on a separate line terminated by a line break (CRLF), the last record may or may not have a trailing line break, an optional header line may be present as the first line, each record should contain the same number of fields, and fields containing line breaks, double quotes, or commas should be enclosed in double quotes. While RFC 4180 is technically an informational document (not a mandatory standard), following its conventions ensures maximum compatibility across different software systems. Many real-world CSV files deviate from RFC 4180 in small ways, which is why robust parsers handle various edge cases.