How to Put a CSV File in Excel: A Practical Guide
This comprehensive guide shows how to put a CSV file in Excel, covering open, import, and Power Query methods, plus tips for clean data and avoiding common pitfalls.
To put a CSV file into Excel, you can open it directly with Excel, go to Data > From Text/CSV, or drag and drop the CSV into an open workbook. In the import dialog, verify the delimiter (comma is standard) and the encoding (UTF-8 is recommended); then load and save as an .xlsx workbook.
Preparing Your CSV for Excel
Before you bring a CSV into Excel, check a few basics that save time and prevent messy imports. Ensure the file uses a consistent delimiter (commonly a comma, but semicolons are frequent in some locales). UTF-8 encoding helps preserve special characters and avoids garbled text, especially for non-English data. If your CSV has headers, you can enable Excel to treat the first row as column names; otherwise, you’ll need to specify how Excel should label columns. Also consider line endings (Windows CRLF vs. Unix LF) because some tools may insert extra blank rows if the endings aren’t consistent. MyDataTables finds that taking a quick peek at the first 20 lines in a text editor is a good sanity check.
noteDataQualitiyatoz enabled: true],
Tools & Materials
- Computer with Excel installed(Any modern Excel version (Windows or Mac) that supports Data > From Text/CSV and Power Query.)
- CSV file(UTF-8 encoding recommended; confirm delimiter used (comma or semicolon).)
- Delimiter specification(Know whether the file uses comma, semicolon, or another delimiter so you can configure the import correctly.)
- Text editor (optional)(Use to quickly verify encoding or delimiter before import.)
- Internet connection (optional)(Useful if you plan to reference online guides or Power Query data sources.)
Steps
Estimated time: 15-25 minutes
- 1
Open a new or existing Excel workbook
Launch Excel and create a new workbook or open an existing one where you want to place the CSV data. This provides a clean canvas so imported data doesn’t overwrite existing content.
Tip: Starting with a fresh sheet helps you verify imports without interference from previous data. - 2
Choose your import method
Decide between Open the CSV directly, Data > From Text/CSV, or Drag & Drop. Power Query is ideal for large files or ongoing imports. Each method has different setup steps, so pick the one that matches your workflow.
Tip: For large datasets, Power Query reduces memory overhead and keeps data connections dynamic. - 3
Select the CSV file
In the chosen import dialog, browse to the CSV file and select it. Excel will preview the data, showing how columns align with the delimiter and how headers are treated.
Tip: If you don’t see expected columns, double-check the delimiter and encoding before proceeding. - 4
Configure delimiter and encoding
Specify the delimiter (comma by default) and set the file origin/encoding to UTF-8 to avoid misinterpreted characters. Some locales automatically switch to semicolons; adjust accordingly.
Tip: Use UTF-8 for best compatibility with international data sets. - 5
Load or transform the data
Choose whether to Load the data as-is into a worksheet or to Transform in Power Query for preprocessing (rename columns, filter rows, change data types).
Tip: If you plan to perform data transformations, Power Query preserves the original CSV and creates a repeatable workflow. - 6
Verify and save
Check that numeric, date, and text fields are correctly interpreted. Apply formatting, then save as an Excel workbook (.xlsx) to preserve features like formulas and formatting.
Tip: Saving as .xlsx prevents reformatting issues when sharing the workbook.
People Also Ask
What is a CSV file and why is it used with Excel?
A CSV is a plain-text file with values separated by a delimiter (commonly a comma). Excel can open or import CSV files to quickly populate worksheets, making it easy to move data between systems.
A CSV is a plain-text data file with comma separation. Excel can import it to fill your worksheet efficiently.
Can Excel automatically detect the delimiter in a CSV?
Excel provides a preview in the import dialog where you can choose the delimiter. Automatic detection is not always reliable, so you should verify the preview before loading.
Excel shows a delimiter option in the import dialog; confirm it matches your file before loading.
What should I do if dates look wrong after import?
Excel may interpret dates according to regional settings. If dates are incorrect, adjust the column format to Date and select the appropriate regional setting during import.
If dates look off, format the column as Date and ensure the correct regional settings were used during import.
Is it better to open or import a CSV in Excel?
Opening a CSV opens it as text; importing via Data > From Text/CSV lets Excel parse and assign data types more reliably, especially for large datasets.
Importing with the import tool is usually more reliable than simply opening the CSV.
How can I reuse a CSV import workflow later?
Use Power Query to create a repeatable data-import workflow that can be refreshed with new CSV files without redoing all steps.
Create a Power Query workflow you can refresh with new data.
Watch Video
Main Points
- Import CSV with Data > From Text/CSV for reliable parsing
- Always verify delimiter and encoding before loading
- Format and verify data types after import
- Save as .xlsx to preserve Excel features
