Loadingโฆ
Loadingโฆ
Convert a JSON array to CSV for Excel or Google Sheets, or CSV back to JSON. Nested objects become dotted columns and back, and numbers stay exact.
Also covers: JSON to CSV ยท CSV to JSON ยท JSON to Excel
The result appears here as you type.
JSON โ CSV turns an array of objects into rows with one column per key. CSV โ JSON turns rows into an array of objects, using the first row as the keys.
Paste JSON or CSV, drop a .json or .csv file, or click Sample. The delimiter (comma, semicolon, tab, or pipe) is detected automatically when reading CSV.
Nested objects become columns like address.city, and arrays become tags.0, tags.1. Going back, those dotted columns are rebuilt into nested objects. Swap flips the direction and moves the result into the input.
With Flatten (the default), {"address": {"city": "London"}} becomes a column named address.city, and ["a", "b"] becomes tags.0 and tags.1. Choose Keep as JSON text to put the whole nested value into one cell instead. Converting back with Nest dotted columns rebuilds the original structure.
Only values that convert without loss become numbers: 42 and 3.5 do, but 007, 1.50, and IDs longer than 15 digits stay strings. Otherwise a ZIP code would lose its leading zero and a large ID would be silently rounded.
Cells starting with =, +, -, or @ can run as formulas when the CSV is opened in Excel or Google Sheets, which attackers use for CSV injection. The option prefixes them with a single quote so they're shown as text.
Excel uses your system's list separator, which is a semicolon in many European locales. Pick Semicolon as the delimiter, or use Data โ From Text/CSV in Excel to choose the delimiter yourself.
No. Everything runs in your browser tab, and nothing you paste or open is uploaded or stored.
Data
Format, validate, and minify JSON in your browser. Paste it, upload a file, or load it from a URL. Errors show the exact line and column.
C# / .NET
Paste JSON and get C# model classes or records, ready for System.Text.Json or Newtonsoft.Json. Nested objects, arrays, nullable types, dates, and GUIDs are inferred for you.
TypeScript
Paste JSON and get TypeScript interfaces or type aliases, with nested objects named for you, optional and nullable fields detected from every array item, and union types.
SQL
Turn a JSON array into a CREATE TABLE with inferred column types and batched INSERT statements for PostgreSQL, MySQL, SQL Server, or SQLite.
SQL
Format and beautify SQL queries for SQL Server (T-SQL), PostgreSQL, MySQL, Oracle, and more. Set the indentation, keyword case, and layout, and get the exact line of any syntax error.
Data
Format, validate, and minify XML (config files, .csproj, SOAP, RSS) in your browser. Entities, CDATA, and mixed content are kept exactly as written, and errors show the line and column.