How to use the CSV to Excel tool
- Add CSV filesDrop one or more CSV, TSV or TXT files, or paste CSV data.
- Check the settingsThe separator is detected automatically. Choose how decimals are written and whether the first row is a header.
- PreviewSee the first rows and columns exactly as they will appear in Excel.
- DownloadDownload one XLSX file. With several CSVs, get one sheet per file or one Excel file per CSV.
Features
- Real numbersValues such as 1,234.56 become numbers you can sum and sort, while IDs, phone numbers and values with leading zeros stay as text.
- Separator detectionCommas, semicolons, tabs and pipes are detected from the file, or choose one yourself.
- Any encodingUTF-8, UTF-16 and Windows-1252 files are read correctly, so accents and other scripts stay intact.
- Multi-line cellsQuoted values with commas, quotes and line breaks are read exactly as in the CSV standard.
- Tidy workbookBold header row and column widths that fit the content.
Why open CSV as a real Excel file?
Double-clicking a CSV in Excel often goes wrong: long numbers turn into scientific notation, leading zeros vanish from PIN codes and phone numbers, accented letters look garbled, and on many European systems everything lands in one column. Converting to XLSX first avoids all of that.
- Bank and payment exports you want to filter and total
- Reports downloaded from Google Analytics, Shopify, Amazon or a CRM
- Contact lists and survey results to share with colleagues
- Data from developers or databases that needs to look presentable
Numbers and text
| Value in the CSV | In Excel |
|---|---|
1,234.50 | Number 1234.5 |
1.234,50 (with “comma decimals”) | Number 1234.5 |
007, +91 98… | Text, leading zero and plus kept |
| Long IDs (16+ digits) | Text, so no digits are lost |
Common CSV problems this solves
- Everything is in column A. This happens when you double-click a CSV whose separator differs from the one your Excel expects, for example a semicolon file on a computer set up for commas. The converter detects the separator and puts each value in its own column.
- Garbled letters such as é or ह. The file is saved in UTF-8 but was opened with an older encoding. Converting it to XLSX stores the text correctly, so names in Hindi, Arabic or with accents display as they should.
- Long numbers turn into 1.23E+15. Excel shows big numbers in scientific form and rounds anything beyond 15 digits. Order IDs, Aadhaar-length numbers and barcodes are safer as text.
- Leading zeros disappear. A PIN code like 012345 or a phone number starting with 0 loses its zero when it is read as a number. Keep such columns as text.
CSV or XLSX: when to use which
Use CSV to move data between systems: bank exports, online store orders, contact lists and database imports. Use XLSX when people will read or work on the file, because it can hold formulas, formatting, filters and several sheets, and it opens correctly with a double-click on any computer.
Related tools
Need the reverse? Use Excel to CSV. For data from an API, try JSON to Excel.