Skip to content

Data and security

CSV and JSON converter that keeps Urdu intact

Paste or open a CSV file to get JSON, or paste JSON to get CSV. The converter detects the separator, reads quoted fields correctly, can turn numbers and true/false into real types, and flattens nested JSON into columns. Download CSV with a UTF-8 BOM so Excel shows Urdu text properly. Nothing is uploaded.

  • Runs in your browser
  • Nothing uploaded
  • Free, no sign-up
  • No ads

How to convert CSV to JSON and back

  1. Choose the direction. CSV to JSON if you have a spreadsheet export, JSON to CSV if you have API data to open in Excel.
  2. Paste or open. Paste the text or press Open a file. The conversion runs as soon as there is input.
  3. Adjust the options. Leave the separator on automatic unless it guesses wrong. Turn off type conversion if you want everything as text, for example to keep leading zeros.
  4. Copy or download. For CSV, keep the UTF-8 BOM option on if you will open the file in Excel and it contains Urdu.

How CSV really works

CSV looks simple, but it has rules that break naive converters. A field that contains the separator, a quote or a line break must be wrapped in double quotes, and a quote inside a quoted field is doubled ("say ""hi"""). A single cell can therefore span several lines. This converter follows RFC 4180: it reads quoted fields, escaped quotes and embedded line breaks correctly, and it writes them back the same way.

Comma, semicolon or tab?

The "comma" in CSV is a convention. In many regions, including Excel installations that use a comma as the decimal mark, files are saved with semicolons. Tab-separated files (TSV) come from copying cells out of a spreadsheet. The automatic mode looks at the first lines, outside any quotes, and picks the separator that appears most. If your data has few columns, set it yourself.

Urdu in Excel: the BOM problem

If you open a UTF-8 CSV that contains Urdu directly in Excel for Windows, the letters often show up as nonsense such as "اردو". Excel assumes an old regional encoding unless the file starts with a byte order mark (BOM), three invisible bytes that mark the file as UTF-8. When you download CSV from this tool with "Add UTF-8 BOM" ticked, Excel reads it correctly. Google Sheets and most programming tools read UTF-8 either way, and the BOM is harmless to them, apart from appearing as an invisible character before the first header in some programs; untick the option for those.

What type conversion does

With conversion on, plain numbers become JSON numbers (30), true and false become booleans, and everything else stays text. Numbers with leading zeros (0300), long digit strings of more than nine digits (phone numbers, CNICs, account numbers) and values with symbols are kept as text so no digits are lost. Turn the option off to keep every value as text.

Nested JSON to CSV

CSV is flat, JSON is not. Nested objects are flattened into columns with dotted names: {"user": {"city": "Lahore"}} becomes a column user.city. Arrays inside a record are written as a JSON string in one cell, so no data is dropped. A top-level object is treated as one row; an array of objects becomes one row per object, and the columns are the union of all keys.

Privacy

Customer lists, salary sheets and bank exports are exactly the files you should not paste into a random website. The conversion runs in your browser and nothing is sent anywhere.

Limits

  • Very large files (tens of megabytes) are slow on a phone.
  • All rows in a CSV are read; there is no streaming. Split huge files first.
  • Dates stay text: CSV has no date type, and guessing formats is a source of silent errors.
  • Merged cells, formulas and formatting in a spreadsheet are not part of CSV.

Frequently asked questions

How do I convert CSV to JSON?

Choose CSV to JSON, paste the CSV or open the file, and copy or download the JSON. With "First row is the header" on, each row becomes an object with the header names as keys.

Why does Urdu look broken when I open my CSV in Excel?

Excel needs a UTF-8 byte order mark to recognise the encoding. Download the CSV with "Add UTF-8 BOM" ticked, or import it in Excel via Data, From Text/CSV, and choose UTF-8.

Why did my phone number lose its leading zero?

Spreadsheets and some converters treat it as a number. This converter keeps values with leading zeros as text. If you later open the file in Excel, import the column as Text.

Can it handle commas and line breaks inside a cell?

Yes. Fields wrapped in double quotes may contain separators, line breaks and doubled quotes, as RFC 4180 specifies.

Does it work with nested JSON?

Nested objects are flattened into dotted column names. Arrays in a record are kept as JSON text in a single cell.

Is my file uploaded?

No. Conversion happens in your browser tab.

Sources and how we checked

Written and maintained by the DanixSoft team in Lahore. Last reviewed 2026-11-22. Spotted a mistake? Write to hello@danixsoft.com.