CSV to Excel

What this tool does

It turns CSV data into a real Excel .xlsx workbook in your browser. You can choose a file or paste text, pick the delimiter and download the result. The workbook has one sheet called Sheet1 and opens in Excel, Google Sheets and LibreOffice. Your data is not uploaded.

How to use it

1. Choose a CSV file, or paste CSV into the box (a small sample is there to try).
2. Leave the delimiter on automatic, or choose comma, semicolon, tab or pipe.
3. Set the file name and click Convert and download.

How the cells are typed

This is the part that matters most, because it decides what Excel shows.

• Plain numbers become numeric cells so you can sum and sort them. A number is plain if it has no leading zero (other than a single 0 before a decimal point), no thousands separators and at most 15 digits, for example 12, 3.5 or -40.
• Everything else stays text. That includes 00123 and phone numbers with a leading zero, so the zeros survive; values such as 1,200, 12% or Rs. 500; and dates, which are written exactly as they appear in the CSV and are not converted to Excel dates.
• A cell that starts with = is stored as text, not as a formula, so nothing in the CSV is executed.
• Quoted fields, doubled quotes and line breaks inside quoted cells are read correctly. Empty cells stay empty.

Example

The line "Smith, Ann",12,"said ""hi""",00123 becomes four cells: the text Smith, Ann, the number 12, the text said "hi" and the text 00123.

Limits

• Values only: no formulas, formatting, column widths, colours or extra sheets.
• The file is read as UTF-8. A CSV saved in another encoding (such as an old Windows code page) can show garbled accents; re-save it as UTF-8 first.
• Delimiter detection looks at the first few lines. If your data has a mix of separators, choose the right one by hand.
• Very large files depend on your device's memory.

Clean your data first with the duplicate line remover. For JSON data, tidy it with the JSON formatter.