From spreadsheet to JSON and back
CSV is how spreadsheets and databases export tables; JSON is how web apps and APIs exchange data. This converter moves data between the two without uploading it anywhere, so customer lists and sales exports stay private.
How CSV becomes JSON
- With “First row is the header” on, each row becomes an object whose keys are the column names. Turn it off to get plain arrays.
- Quoted values may contain commas, quotes (written twice: "") and even line breaks.
- With “Read numbers and true/false” on, 42 becomes a number and true a boolean; otherwise every value stays text. Long numbers such as phone numbers and IDs with leading zeros always stay text.
How JSON becomes CSV
- An array of objects becomes a table with one column per key, in the order keys first appear.
- Nested objects become dotted columns, so {"stock": {"dhaka": 40}} gives a column named stock.dhaka.
- Arrays inside a value are joined with semicolons. The CSV download includes a byte-order mark so Excel opens Bangla and other scripts correctly.
How to use the converter
- Choose the direction and paste your data, or open a .csv or .json file.
- Check the delimiter — it is detected automatically, but semicolon files from European Excel can be forced.
- Copy or download the result.
Frequently asked questions
My CSV opens as one column in Excel. Why?
Excel in some regions expects semicolons. Choose Semicolon as the delimiter when converting from JSON, or use Excel’s Data → From Text/CSV import.
Is there a size limit?
No fixed limit; files of tens of megabytes convert in a few seconds in a modern browser.
Does it work with TSV files?
Yes. Tab-separated files are detected automatically, or choose Tab as the delimiter.