Open CSV in Excel correctly
Skip the Text Import Wizard: get an Excel file whose columns, text and numbers are already right.
Formats & limits
Formats & limits
- Accepted formats
- CSV
- Result
- Excel (XLSX)
| On a computer | On a phone or tablet | |
|---|---|---|
| Max file size | 20 MB | 10 MB |
Limits on your device depend on its memory. Larger files may still work; the tool warns you first.
How it works
- 01 Select the CSV file that opens badly in Excel.
- 02 Leave the settings on automatic, or force a separator or encoding under More options.
- 03 Press Convert and download the Excel file.
- 04 Open it in Excel by double-clicking, with no import dialogs.
About this tool
Double-clicking a CSV hands the decisions to Excel, and Excel guesses using your computer’s regional settings. That is how order numbers lose their leading zeros, card and account numbers turn into 4.08E+19, codes like 1-2 become dates and a file from a colleague abroad lands in one column. Power Query or the Text Import Wizard can fix it, but only step by step. Hushdesk makes those choices from the data instead: it detects the encoding and separator, keeps anything that is not clearly a number as text, and writes a genuine Excel workbook. Open it and start working: filters, sums and pivot tables behave as expected.
-
No surprise dates
Values like 1-2, 3/4 or 12.05 are never reinterpreted as calendar dates; they stay exactly as written.
-
No scientific notation
Digit strings longer than fifteen characters stay text, so bank accounts, IMEI and barcode numbers are not rounded.
-
Independent of regional settings
The result is the same on an American, German or Russian Windows, because columns are stored in the workbook, not guessed at opening.
Questions and answers
Why does Excel change my numbers when opening a CSV?
Excel converts every value it can: it drops leading zeros, rounds numbers longer than 15 digits and turns things like 1-2 into dates. The converted workbook stores such values as text, so they stay as they were in the file.
Is this better than Data → From Text/CSV in Excel?
It gives the same careful result without a dialog: the encoding, separator and text columns are chosen automatically. Power Query remains useful when you need a repeatable, refreshable import.
Will Excel on a Mac or Excel Online open the result?
Yes. The output is a standard XLSX workbook, which Excel for Windows and Mac, Excel on the web, LibreOffice Calc and Google Sheets open directly.
Can I get a CSV back after editing?
Yes. Save your changes, then use the XLSX to CSV converter to export the sheet with the separator and encoding the receiving system expects.