Opening a CSV file with a double click feels natural, but it is behind a lot of damaged data. Excel tries to “guess” the data type of each column and, in doing so, strips leading zeros from codes, turns long numbers into scientific notation, converts codes into dates and breaks accented characters. Once you save, the damage is usually permanent. In this article you will see why it happens and how to convert a CSV to Excel safely.
The most common problems
Leading zeros disappear
A zip code like “02134” becomes “2134”. A product code “000452” turns into “452”. If you later import that file into another system, the records no longer match.
Long numbers in scientific notation
Numbers longer than 15 digits, such as some loyalty card numbers, EAN barcodes or order IDs, are displayed as 1.23457E+15. Worse still, Excel only stores 15 significant digits, so the last digits are lost and replaced with zeros.
Codes turned into dates
A code like “3-12” or “MAR1” can be automatically converted into a date. This is so common that some scientists actually renamed genes to stop Excel from turning them into dates.
Dates with the wrong order
If the CSV contains 03/04/2026, is it March 4 or April 3? Excel interprets it according to the computer’s regional settings, which causes silent errors.
Broken special characters
If the CSV is UTF-8 and Excel opens it with another encoding, you will see “é” instead of “é”.
Method 1: import from Excel with the wizard
Instead of double-clicking the CSV, use Data > Get Data > From Text/CSV. This wizard lets you:
- Choose the file encoding (select 65001: Unicode (UTF-8)).
- Set the correct delimiter: comma, semicolon or tab.
- Define the type of each column. Mark code, phone and zip code columns as Text.
It is the safest method inside Excel, although it takes several clicks and you have to repeat it every time.
Method 2: convert online
If you convert files often or do not have Excel, an online tool is faster. The CSV to Excel converter on our Excel tools page reads the CSV, detects the delimiter and encoding, and produces an XLSX or XLS file ready to open:
- Upload your CSV file.
- Choose the output format (XLSX is recommended).
- Download the Excel file.
Because the file is generated directly, it avoids the automatic interpretation Excel applies when opening a CSV, so your data stays exactly as it was.
How to check that the conversion is correct
After converting, review these points:
- Row count: it should match the number of lines in the CSV minus the header row.
- Code columns: check that leading zeros are kept.
- Dates: verify a few dates where the day is greater than 12, such as 09/25, to confirm the day/month order is right.
- Special characters: look for words with accents.
- Long numbers: make sure they do not appear in scientific notation.
Good practices when you receive CSV files
- Never save over the original CSV after opening it in Excel. Save a copy as XLSX.
- Ask the sender for the delimiter and encoding if the file comes from an external system.
- Document the type of each column if you receive the same CSV regularly.
- Delete blank rows at the end, which some systems add when exporting.
XLS or XLSX?
Unless you have a specific reason, always choose XLSX. It supports more than a million rows, takes up less space and works with every modern version of Excel, LibreOffice and Google Sheets. XLS only makes sense if the file must be opened in Excel 2003 or an old system that does not support XLSX.
When you need to go the other way
If after working in Excel you need to produce a CSV again to import into another system, use our Excel to CSV converter. It lets you choose the delimiter and encoding so the file is compatible with the target system.
Frequently asked questions
Can I get leading zeros back after saving?
If the code always had the same length, you can rebuild it with a formula like =TEXT(A2,"000000"). If the length varied, there is no reliable way to know how many zeros were missing, so it is best to go back to the original CSV.
Why does Excel turn my codes into dates?
Because it tries to guess the data type and recognizes patterns like “1-5” or “3/12” as dates. To prevent it, import the file marking that column as Text or convert it with a tool that does not apply that automatic interpretation.
What happens to numbers longer than 15 digits?
Excel only keeps 15 significant digits in numeric cells. Longer numbers, such as some IDs or barcodes, should always be treated as text so no digits are lost.
Is it better to open the CSV in Google Sheets?
Google Sheets also interprets data on import, although it lets you turn off automatic conversion of text to numbers and dates. Whatever program you use, the key is to control the type of each column during the import.
Conclusion
A CSV opened with a double click can lose zeros, digits, dates and accents without you noticing. To avoid it, import the file with Excel’s wizard and mark text columns, or convert it with a tool that creates the Excel file directly. Your data will arrive intact and you will save hours of corrections. You will find this and other free converters on our Excel tools page.
Try our free tools
Compare, convert, merge and clean your spreadsheets right in your browser, with nothing to install.
