freesabaiJSON to CSV converter
Paste a JSON list of objects (like an API returns) and get CSV that opens in Excel or Google Sheets. Nested objects become a.b columns, and Thai text stays intact when the BOM option is on. It runs in your browser and your JSON is not sent anywhere.
This tool needs JavaScript. If you still see this after a few seconds, JavaScript is switched off in your browser or the page did not load completely: turn JavaScript on or reload the page.
How to use it
- Paste JSON in the left box, or open a .json file (a list of objects such as
[{"id":1},{"id":2}], or{"data":[...]}). - Choose the separator (comma, semicolon, tab) and the other options. The CSV appears on the right.
- Press "Download" and open the file in Excel or Google Sheets.
Frequently asked questions
Thai text looks garbled when I open the CSV in Excel
Excel on Windows reads a CSV in the computer's legacy encoding unless the file starts with a BOM (a mark that says it is UTF-8). Keep "Add a BOM when downloading" ticked (it is by default) and the downloaded file opens with Thai intact.
What happens to nested objects and lists inside lists?
Nested objects become columns such as address.zip. Lists (arrays) are written as JSON text in one cell, because a table has no room for several values in a cell. Untick the option to keep each nested object in one cell as JSON text.
What is the "formula guard"?
If a value starts with =, +, - or @, Excel may run it as a formula when the file is opened, a weakness called CSV injection. If the data comes from other people, tick this option: it puts a ' before such values (negative numbers are left alone).
Good to know
- If the JSON is an object with a single list inside it (like
{"data":[...]}), that list is used as the table for you. - The columns are every key found, in the order first met. A row without that key has an empty cell.
- Numbers are written exactly as in the JSON (
13.70does not become13.7). - null becomes an empty cell, and true and false are written as the words.
Your data stays on your device
Everything runs in your browser. What you type, paste or open is not sent to freesabai's servers or anyone else's, and is not kept in the browser: close the page and it is gone. The site only counts how many times this page was opened and how many times someone copied or saved a result (never what was pasted or the result, and you can switch the counting off in the footer; see the privacy policy).
Report a problem or suggest an idea
Found a bug, or want this tool to do more? Tell us on the feedback page. No sign-up.
Other developer tools
JSON and data
- JSON formatter and validatorFormat, minify and validate JSON, find the error, fold it into levels
- JSON to YAML converterTurn JSON into YAML, key order kept, nothing leaves your device
- YAML to JSON converterTurn YAML into JSON, and find the line where the YAML is wrong
- JSON to CSV converterTurn a JSON list into CSV for Excel, Thai text included
- CSV to JSON converterTurn CSV into JSON, any separator, quoted fields handled
- CSV viewerOpen a CSV file as a table, sort a column, search, no spreadsheet needed
- Text and JSON diff checkerSee what changed between two texts, side by side or unified, with word highlights
Encoding, hashes and tokens
- Base64 encode and decodeBase64 for text (Thai and UTF-8), URL-safe, and files to and from Base64
- Hash generator: MD5, SHA-256, HMACHash text or files with MD5, SHA-1, SHA-256, SHA-512 and HMAC, and verify a checksum
- JWT decoderRead the header and payload of a JWT, with times you can read (decode only, no signature check)
- URL encode and decodePercent-encode or decode a link, Thai in URLs included, and take a URL apart
- HTML entities encode and decodeTurn special characters into & < > " and back
Generators
Time, numbers and colour
- Unix timestamp converterConvert a timestamp (seconds or milliseconds) to a date and back, with time zones
- Cron expression explainerRead a cron expression in plain words and see its next 5 runs
- Number base converterConvert between binary, octal, decimal and hex, and do bitwise AND, OR, XOR and shifts
- Colour converter: HEX, RGB, HSLConvert a colour between HEX, RGB and HSL, or pick one by eye
- Colour contrast checker (WCAG)Check the contrast between text and background colours for WCAG AA and AAA
Text and code
- Regex testerTry a regular expression, see matches and groups, protected from regexes that never finish
- Markdown previewType Markdown and see it rendered at once, safely, with embedded scripts never run
- Character, word and line counterCount characters, words (Thai too), lines, sentences, paragraphs and reading time