To import a CSV file into Excel for Microsoft 365 on Windows, choose Data > From Text/CSV, select the file, check the preview and delimiter, then choose Load or Transform Data. If you specifically need the older Text Import Wizard, enable it under Excel Options and open it through the legacy import commands.
What Excel’s CSV import wizard does
A CSV, or comma-separated values file, stores rows of data as text, with separators between fields. Despite its name, a CSV may use a comma, semicolon, tab or another character as the separator. It does not carry the workbook features that an Excel file can hold, such as multiple worksheets, cell formatting, formulas and charts.
Excel’s import tools help turn that plain text into columns and let you inspect how Excel will interpret the values. This matters because importing is not always just a matter of splitting each line at commas. A field such as a postal code may need to remain text, while a date or decimal value may depend on regional settings. The import preview gives you a chance to catch those issues before relying on the data.
In current Microsoft 365 Excel for Windows, the standard route is the From Text/CSV command, which uses the Power Query import experience. The older Text Import Wizard is a separate, optional tool. People often use the phrase “CSV import wizard” for either one, so it helps to know which interface you are looking for.
Import a CSV with From Text/CSV
Use this process when you want a preview and control over the import rather than simply opening the file. The command is available on the Data tab in Excel for Microsoft 365 on Windows.
- Open a blank workbook or the workbook where you want the data, then select Data > From Text/CSV.
- Browse to the CSV file, select it and choose Import.
- Check the preview. Confirm that the columns are separated correctly and that the first row is treated as headers if it contains field names.
- Check the file origin or encoding and delimiter options if characters look wrong or the data appears in one column.
- Choose Load to bring the data into a worksheet, or Transform Data to adjust it in Power Query first.
Loading is suitable when the preview already looks right. Transform Data is useful when you need to set column types, remove unwanted rows, rename columns or make other changes before the data reaches the sheet. In Power Query Editor, select a column and use the data type control to choose a type such as Text, Date or Whole Number. If dates or numbers are being interpreted according to the wrong regional convention, use the data type option that specifies a locale, where available, and select the locale that matches the source data.
For example, a file might contain a code such as 00427. If Excel interprets that column as a number, the leading zeros can disappear. Set the column to Text before loading when those zeros are part of the code. Similarly, a date such as 03/04/2025 is ambiguous: it can mean March 4 or April 3 depending on the source’s date convention. Verify the intended interpretation rather than guessing from the displayed value.
Turn on the older Text Import Wizard
The legacy Text Import Wizard can be useful when you want its familiar step-by-step controls, especially for choosing fixed-width columns or specifying a format for each field during import. It is not normally shown as the default route in current Excel for Windows, so enable its command first.
- Select File > Options > Data.
- Under the legacy data import wizard settings, select From Text (Legacy), then choose OK.
- Return to the worksheet and select Data > Get Data > Legacy Wizards > From Text (Legacy).
- Choose the text or CSV file and follow the wizard’s steps to set the file origin, layout, delimiters and column formats.
The wizard’s first step asks whether the data is delimited or fixed width. Choose delimited when a character separates fields. Choose fixed width when fields line up in consistent character positions rather than being separated by a delimiter. The next step lets you select separators such as commas, tabs or semicolons and see how they divide the preview. The final step lets you select a column and assign a format, including Text, which is important for identifiers with leading zeros.
If you do not see the legacy command, check that it was enabled in Excel Options and that you are using the Windows desktop application. The legacy wizard is not the same as the standard From Text/CSV interface, and its availability and menu placement can differ between Excel versions.
Choose the right method for your file
For most CSV files, start with Data > From Text/CSV. It provides a preview and, through Power Query, a repeatable way to shape data. Choose the legacy wizard when you specifically need its delimited-versus-fixed-width workflow or its per-column import controls. If you only need to inspect a file quickly, opening it directly may be convenient, but it gives you less opportunity to prevent automatic type conversion before Excel displays the data.
- Use From Text/CSV for routine imports, previewing the file, changing data types or preparing a refreshable import.
- Use the legacy wizard when you need its classic fixed-width option or prefer its step-by-step column-format controls.
- Open the CSV directly for a quick look when the file is simple and automatic interpretation is acceptable.
- Use Power Query transformations when you will repeat the same cleanup on updated files or need more than a one-time import.
Excel for Mac has its own import and Power Query features, but the available commands and wording depend on the release. If your Mac version offers a text or CSV source under Data > Get Data (Power Query), use that route and inspect the preview. Do not assume that the Windows legacy-wizard steps appear identically on Mac. Excel for the web also does not provide the Windows desktop legacy wizard; use the import options available in the web app or open the file in desktop Excel when you need the desktop import controls.
Check delimiters, encoding and regional settings
A file that opens with everything in one worksheet column usually has a delimiter mismatch. For example, the source may use semicolons while Excel expects commas, or the file may be tab-delimited despite having a .csv extension. In the import preview, try the delimiter that matches the source. Do not split on a character that also appears inside values unless the file’s text qualifier is being handled correctly.
CSV formats commonly use double quotes around fields that contain a separator. A row such as 17,"North, West",Active has three fields, not four: the comma inside the quoted location is part of the value. A properly configured importer recognizes quoted text and keeps that field together. If you use a custom delimiter or a nonstandard export, check the preview carefully for shifted columns.
Encoding affects whether accented letters and other non-English characters display correctly. If names appear as unexpected symbols, choose the appropriate file origin or encoding in the import settings, where available. UTF-8 is common, but the correct choice depends on how the file was created. A file that looks correct in a plain-text editor may still need its encoding specified during import.
Regional settings can also affect decimal and date interpretation. Some sources use a comma for decimals and a period for thousands; others use a period for decimals. A value such as 1,25 could be interpreted differently from 1.25. When a column contains dates or numbers from a known locale, use Power Query’s locale-aware type conversion or set the relevant column format in the legacy wizard. Compare a few imported values with the source before using them in calculations.
Prevent common data problems
Automatic conversion is a frequent source of trouble. Excel may interpret strings as dates, numbers or scientific notation when you intended to preserve the original characters. Product codes, account references, postal codes and long identifiers are often better imported as text. Once a value has been converted and its original form is lost, changing the displayed cell format afterward may not restore it.
Before loading a file, check for these common cases:
- Leading zeros disappear: set the column to Text during import.
- Dates switch month and day: confirm the source convention and use a matching locale.
- Columns do not line up: check the delimiter and text qualifier in the preview.
- Special characters look corrupted: check the selected encoding or file origin.
- Large identifiers change appearance: import them as Text rather than relying on numeric formatting.
- Numbers show unexpected decimals or separators: verify the source locale and decimal convention.
Also inspect blank rows, extra spaces and inconsistent headers. A CSV can contain an empty field between two separators, which is different from a missing column. If you clean the data in Power Query, confirm the preview after each transformation and check that the resulting row and column counts are plausible.
What happens after the import
When you load a CSV through Power Query, Excel can keep the import steps as a query in the workbook. If you later receive an updated source file, you may be able to refresh the query rather than repeat each cleanup step. Refresh behavior depends on the source path and how the query was configured; moving or renaming the file can require you to update the source location.
If you simply open a CSV and then save it as a CSV again, remember that CSV is a plain-text format, not a full workbook format. It cannot preserve multiple sheets, formulas as working formulas, formatting, charts or Power Query steps. To keep workbook features and saved query steps, save the workbook in an Excel format such as .xlsx. Retain the original CSV separately when you need an unchanged copy of the source data.
A useful routine is to keep the source file untouched, import it into a workbook, verify several representative rows, and then save the workbook as .xlsx. For recurring reports, give the query and worksheet clear names so you can tell the imported data apart from source files or manually edited results.
Frequently Asked Questions
Where is the CSV import wizard in Excel?
In Excel for Microsoft 365 on Windows, select Data > From Text/CSV for the standard import preview. To use the older Text Import Wizard, enable From Text (Legacy) in File > Options > Data, then open it from Data > Get Data > Legacy Wizards.
Why does my CSV open in one column?
The delimiter Excel selected may not match the file. Use From Text/CSV and choose the actual separator, such as a semicolon or tab, in the preview. Also check that quoted fields containing separators stay together.
How do I stop Excel removing leading zeros from a CSV?
Import the relevant column as Text before loading it. In Power Query, select the column and set its type to Text; in the legacy wizard, select the column in the final step and choose Text. Formatting a number as text after zeros have already been discarded may not recover them.
Can I open a CSV without Excel changing dates or numbers?
Use the import preview and explicitly set sensitive columns to Text, or set dates and numbers using the source’s locale. Opening a CSV directly can trigger automatic interpretation, so it is less suitable when preserving the exact original strings matters.
Does importing a CSV change the original file?
Importing normally reads the source into Excel; it does not require editing the CSV. Keep a separate original copy, and save the workbook as .xlsx if you want to preserve query steps, formatting or multiple worksheets.
Can I refresh an imported CSV?
If you imported it through Power Query and the workbook retains the query, use Excel’s refresh controls to run the saved steps again. The source file must remain accessible at the location recorded by the query, or the source path may need updating.
Related
- Automate Text to Columns in Excel: Methods and Limits
- AutoCAD Excel Data Links: Insert and Update Tables
- Excel Autofill and Flash Fill: How Each Feature Works
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Timesheet Template in Word: Create and Use OneA timesheet template in Word is a document with a table for recording work dates, start and end…
- Adding a Checkbox to Excel: Setup, Linking, and TipsTo add a checkbox in Microsoft 365 Excel for Windows, select the cell or range where you want…
- Group Rows in Excel Based on Criteria Step by StepTo group rows in Excel by a category or rule, first sort the data so matching rows are…
- Excel Data Validation: Create Lists, Rules, and AlertsIn Excel for Microsoft 365 on Windows, select the cells, then choose Data > Data Validation to control…
- Excel AVERAGE: What It Ignores and IncludesIn Excel, AVERAGE ignores empty cells, text, and logical values such as TRUE or FALSE when they are…
- Scatter Plot Excel: Change Colors by Point or SeriesTo change a scatter plot’s color in Excel for Microsoft 365 on Windows, select the chart, click a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.