Data file converter
Pick what you have and what you want, drop in a file or paste the data, and convert. CSV, JSON and Excel all go to each other, so a spreadsheet becomes JSON and an API dump becomes something Excel opens.
It all runs in the page. The file is read, converted and saved on your own device, and no server here receives it.
The character between fields, for reading and writing CSV.
Choose a file, or paste the data below.
A table is flat. Nested objects or arrays inside JSON rows are written as their JSON text in one cell, not spread across columns. For turning JSON into CSV specifically, the JSON to CSV tool covers the same ground.
Questions
- Is what I paste sent anywhere?
- No. Every tool in this kit runs in the page itself. There is no server here that receives what you paste, and you can check it in your browser's network tab: using a tool produces no request carrying your input at all.
- Which conversions does it do?
- All six directions between CSV, JSON and Excel (XLSX). Everything goes through a table in memory, so the same tool reads whatever you have and writes whatever you want.
- Can I choose the delimiter?
- Yes, for CSV in and out: comma, semicolon, tab or pipe. Excel in some locales writes semicolons, so reading a file that came from there is a matter of picking the right one.
- My Excel file has several sheets. Which one?
- When a workbook has more than one sheet, a picker appears and you choose which sheet to convert. One sheet becomes one table.
- How does it handle nested JSON?
- A table is flat, so a nested object or array inside a JSON row is written as its JSON text in one cell rather than spread across columns. For turning JSON into CSV with dotted columns for one level of nesting, the JSON to CSV tool is the more specific choice.
- Are big files a problem?
- It works on what fits in your browser's memory, which is comfortably most everyday files. A very large export can be slow, because the whole table is held in memory to convert it, the same as any spreadsheet app opening it.
The other tools here
- JSON formatter, format, minify and validate
- Base64 encoder, encode and decode, text or file
- URL encoder, encode and decode, two rules
- UUID generator, version 4, one to a hundred
- Hash generator, sha-256, sha-1 and md5 at once
- JWT decoder, header, payload and expiry
- Regex tester, live matches, groups and flags
- Text diff, compare two blocks, by line or word
- Timestamp converter, unix time to a date, and back
- Cron explainer, a schedule, in plain english
- Colour converter, hex, rgb, hsl, and a contrast check
- Markdown preview, live preview, and copy the html
- JSON to CSV, an array of objects into a spreadsheet
- JSON and YAML, convert between json and yaml, either way
- JSON to TypeScript, a sample of json into typed interfaces
- SQL formatter, tidy up sql, or minify it, by dialect
- Password generator, strong random passwords, made on your device
- Number base converter, hex, binary, decimal and octal, live
- curl converter, a curl command to fetch, axios or python