Papiral
PixelForge
Tabular
TabularHow to Open a CSV File in Excel
3 methods — double-click, Import Wizard, and Python
Opening a CSV in Excel sounds simple, but double-clicking often causes problems: dates auto-format incorrectly, leading zeros get stripped, and special characters show as garbage. Here's how to open CSV files in Excel correctly every time.
Method 1: Convert to XLSX first (recommended for shared files)
If you're going to share the file or need it to open cleanly without import steps, convert it to XLSX before opening.
- 1Upload your CSV to Tabular's CSV ↔ XLSX Converter.
- 2Download the .xlsx file.
- 3Double-click the .xlsx file — it opens in Excel with no formatting issues.
XLSX files open directly in Excel without any import dialogs, encoding questions, or auto-formatting surprises. This is the cleanest option when you control the file.
Method 2: Using the Excel Import Wizard (best for raw CSVs)
The Import Wizard gives you full control over encoding, delimiters, and column types — avoiding the auto-formatting bugs that plague double-click opens.
- 1Open Excel and go to Data > From Text/CSV (Excel 365) or Data > Get External Data > From Text (older versions).
- 2Browse to and select your CSV file.
- 3In the preview dialog, set the File Origin to UTF-8 if your file contains special characters.
- 4Confirm the delimiter (usually comma) and click Load.
To prevent Excel from converting columns like '001' or '2024-01' into numbers or dates, select those columns in the wizard and set the data type to 'Text' before loading.
Method 3: Using Python (for automation)
- 1Install openpyxl: pip install pandas openpyxl
- 2Run the script below to open the CSV and save it as an xlsx file.
python
import pandas as pd
df = pd.read_csv("input.csv", dtype=str) # dtype=str prevents auto type conversion
df.to_excel("output.xlsx", index=False)Using dtype=str when reading preserves leading zeros and prevents date auto-formatting — useful for product codes, ZIP codes, and ID columns.
Frequently asked questions
Why does Excel change my numbers when I open a CSV?
Excel auto-detects column types when you double-click a CSV. It converts values like '001' to 1, '1/2' to January 2nd, and long numbers to scientific notation. Use the Import Wizard and set affected columns to 'Text' type to prevent this.
Why do special characters show as garbled text in Excel?
Your CSV is saved in UTF-8 encoding but Excel defaults to Windows-1252. Use the Import Wizard (Data > From Text/CSV) and select UTF-8 as the file origin, or convert to XLSX using Tabular which handles encoding automatically.
Can Excel open CSV files with semicolon or tab delimiters?
Yes. Use the Import Wizard and set the delimiter manually — don't double-click, as Excel will assume comma by default. Alternatively, use Tabular's Convert Delimiter tool to convert your file to comma-separated before opening in Excel.
What is the row limit for opening a CSV in Excel?
Excel supports up to 1,048,576 rows. If your CSV has more rows, Excel will silently truncate it. For large files, use Python's pandas library or split the file first using Tabular's CSV File Splitter.
Ready to try the fastest method?
Convert CSV files to Excel (XLSX) or Excel files to CSV online. Fast, free, and no software required.
CSV ↔ XLSX — free