How to Convert CSV to Excel Properly
· admin
A CSV file looks simple because it is simple: plain text with values separated by delimiters. The trouble begins when Excel has to guess what those values mean.
Open a CSV the wrong way and phone numbers lose leading zeros, dates change format and everything can land in one enormous column.
Don’t just double-click it
For data you care about, import the CSV rather than simply opening it. In Excel, use the Data tab and the option to get data from a text or CSV file.
Excel will show a preview so you can check the delimiter, encoding and columns before loading the data.
Choose the correct delimiter
Comma-separated is common, but files can use semicolons, tabs or other delimiters. If all the data appears in one column, the delimiter is one of the first things to check.
Protect IDs, postcodes and leading zeros
Not every string of digits is really a number. Product codes, account references and phone numbers may need to remain text. If Excel converts them to numbers, leading zeros can disappear.
Set important identifier columns to text during import where necessary.
Watch dates carefully
A value such as 03/04/2026 can mean different things under different regional conventions. Check date columns before trusting them, particularly when the file came from another system or country.
Save as an Excel workbook
Once the data has imported correctly, save the working file as an Excel workbook if you need formulas, formatting, multiple sheets or other Excel features. CSV itself does not preserve those features.
What if the CSV is messy?
Large exports can contain inconsistent columns, duplicate records, broken quotation marks or several data types mixed together. At that point the job becomes data cleaning rather than simple conversion.
Our guide to common Excel problems covers several of the usual symptoms.
Can’t be faffed?
If you have CSV files that need converting, combining, cleaning or restructuring, Faff It Off. Send us what you’ve got and tell us what you need at the end.