Import CSV to Excel: Steps, Settings, and Common Fixes

How-to basics · Updated November 18, 2026

To import a CSV file into Excel for Microsoft 365 on Windows, open a blank workbook and choose Data > Get Data > From File > From Text/CSV. Select the file, check the delimiter and data preview, then choose Load to place the data in a worksheet or Transform Data to review and adjust it first. This import route is usually safer than opening a CSV directly because it lets you inspect how Excel interprets the file.

What a CSV file contains

CSV means comma-separated values. It is a plain-text format for storing rows and columns: each line usually represents a row, while a delimiter separates the values in that row. Despite the name, a CSV is not necessarily separated by commas. Depending on the program and regional settings that created it, the separator might be a semicolon, tab, or another character.

A CSV also does not preserve the features of an Excel workbook. It cannot store multiple worksheets, cell formatting, formulas as working formulas, charts, or Excel tables in the same way an .xlsx file can. It mainly carries text and values. When Excel imports a CSV, it has to decide how to interpret those values—for example, whether 03/04/2026 is a date or text, or whether 00127 is a number whose leading zeros can be discarded.

That interpretation is why the import preview matters. A file can be perfectly valid as text yet appear wrong in Excel if the delimiter, character encoding, or column data type is not detected as intended.

Import a CSV with the Data tab

Use this method when you want to inspect the file before loading it, choose how columns are interpreted, or make the import repeatable. These steps apply to Excel for Microsoft 365 on Windows:

  1. Open the workbook that should receive the data. To keep the source untouched, use a new workbook or a separate worksheet.
  2. Choose Data > Get Data > From File > From Text/CSV. In some ribbon layouts, From Text/CSV appears directly on the Data tab.
  3. Browse to the CSV file, select it, and choose Import.
  4. Review the preview. Check whether the rows and columns are separated correctly, and whether accented or non-English characters display properly.
  5. Choose a delimiter if Excel has not detected the right one. Check the data type detection and file origin settings if values look incorrect.
  6. Select Load to import the preview as a table, or select Transform Data to open Power Query and make changes before loading.

If you choose Load, Excel typically creates a table on a worksheet. To choose a destination or other load options, use the arrow beside Load and select Load To, where available. You can then specify whether to load the result as a table, place it in a worksheet, or add it to the Data Model. For a routine list or report, a worksheet table is generally the most straightforward destination.

Choose the delimiter, encoding, and data types

The preview is the place to catch common interpretation problems before they reach the worksheet. A delimiter divides fields within a row; a line break usually marks a new row. In the import preview, select the delimiter that matches the file. If every row appears in one column, the delimiter is a likely cause. For example, a file exported in a region that uses commas as decimal marks may use semicolons between fields instead.

Encoding, sometimes presented as File Origin, determines how Excel reads characters from the text file. If names such as José or letters with accents appear as symbols or question marks, try a different encoding in the import window. UTF-8 is common for modern CSV files, but the correct choice depends on how the source application saved the file. Use the preview to verify the result rather than assuming one setting fits every file.

Excel may also detect data types automatically. That can be convenient for ordinary amounts and dates, but risky for codes, postal codes, product IDs, and other values where every character matters. In Power Query, select a column and set its data type from the type control on the column header or the Transform tab. Choose Text for identifiers that must retain leading zeros or must not be converted into dates. Choose a date or number type only when you want Excel to treat the values as dates or numbers.

Open a CSV directly or import it?

There are two common approaches, and each suits a different situation. Double-clicking a CSV or choosing File > Open is quick when you only need to inspect a simple file. Excel may open it in a worksheet and infer columns and values automatically. However, you get less opportunity to check the interpretation before the data appears. Direct opening is therefore less suitable when the file contains leading zeros, unusual date formats, or a delimiter Excel might misread.

Importing through Data > Get Data > From File > From Text/CSV adds a preview and gives access to Power Query. This takes a few more clicks but makes it easier to select the delimiter, adjust types, remove unwanted rows, and repeat the same preparation later. A practical rule is to open a CSV directly for a quick look at a simple file; use the import route for data you will analyze, share, or update regularly.

Neither method turns the original CSV into a full Excel workbook automatically. After importing, choose File > Save As and save the working copy as an Excel Workbook (.xlsx) if you need to preserve tables, formatting, formulas, or multiple sheets. Keep the original CSV if you need an unchanged source copy.

Clean and prepare data in Power Query

Selecting Transform Data opens Power Query Editor, where you can make changes before loading. Each change is recorded as an applied step, such as selecting columns, changing a type, or removing blank rows. This is useful because the same steps can be applied again when you refresh the query with a replacement or updated source file.

For example, a sales export might include an empty first row, an explanatory note above the column headings, and columns you do not need. In Power Query, you can remove top rows, use the correct row as headers, remove irrelevant columns, and set an order-date column to a date type. Check the preview after each change. A transformation that works for one export may not work as expected if a later export changes its headings or layout.

When the data is ready, choose Home > Close & Load to return it to Excel. The query and its steps are saved in the workbook. If the source file is updated, use Data > Refresh All to refresh workbook connections and queries. Refresh works only if Excel can still access the source; moving or renaming the CSV can break the saved file path, so you may need to edit the query’s source settings.

Fix columns that import incorrectly

If the result does not match the preview you expected, identify the specific symptom before changing settings. Several common issues have different causes:

  • All values appear in one column: Re-import the file and select the actual delimiter, such as semicolon or tab, instead of relying on automatic detection.
  • Leading zeros disappear: Import the affected column as text. If Excel has already converted 00127 to 127, changing its format to Text afterward does not restore the lost zero; re-import from the source.
  • Dates switch month and day: The source and your settings may use different date conventions. In Power Query, use the date conversion option that lets you specify a locale, and choose the locale matching the source data.
  • Accented characters look corrupted: Try a different File Origin or encoding setting and confirm the names in the preview before loading.
  • Numbers have unexpected decimals or separators: Check whether the source uses a comma or period as the decimal mark and whether the column was assigned the right regional interpretation and data type.
  • Some rows seem to be missing: Check the preview and source file for blank lines, quoted line breaks, or an inconsistent number of fields. A line break inside a properly quoted field can be part of one value, not a new record.

When a value is important, compare a few imported rows with the original file in a plain-text editor. This can reveal whether the problem was already in the CSV or arose from Excel’s interpretation. Avoid fixing a large import by manually editing hundreds of cells until you know whether a fresh import with a corrected setting would solve it more reliably.

Keep the import accurate and refreshable

For recurring reports, use Power Query rather than repeating manual cleanup. Import the first CSV, apply the necessary steps, and load the result. When the next file has the same structure, you can replace the source file or update the query’s source and then refresh. The process is most dependable when column headings and field order remain consistent from one export to the next.

Before relying on the refreshed data, check that the source file is the intended one and that the row count and key columns look plausible. If a supplier changes a heading from “Order ID” to “Order Number,” a query step that refers to the old heading may fail. Also be careful when appending files: matching column names and compatible types help prevent values from landing in unexpected columns.

CSV files are plain text, so they do not carry Excel’s workbook protections or formatting. Treat files from unknown sources cautiously, especially if they contain unexpected content or are intended to be opened by others. Do not assume that converting a CSV to .xlsx verifies that its contents are trustworthy. Keep a backup of important source data, and review the workbook before sharing it.

Excel on Mac and Excel for the web

The instructions above describe Excel for Microsoft 365 on Windows. Excel for Mac has Power Query features in Microsoft 365, but available connectors and interface details can vary by build. If your Mac version exposes the CSV connector, look under Data > Get Data (Power Query) for the text or CSV import option, then check the preview before loading. If the option is absent, update Excel or use a Windows version with the connector; you can also open the CSV directly for a simple file, while being especially careful about data types.

Excel for the web has a different set of import and query capabilities from the Windows desktop application. If the task requires detailed control over encoding, column types, or Power Query transformations, use the desktop app rather than assuming the web interface offers the same dialogs. Once a workbook has been prepared and saved in a supported format, it may be possible to view or edit it in a browser, but verify the result in the environment where you will maintain it.

Frequently Asked Questions

How do I import a CSV into Excel without losing leading zeros?
Use Data > Get Data > From File > From Text/CSV, choose Transform Data, and set identifier columns such as postal codes or product codes to Text before loading. If zeros have already disappeared in a direct-opened file, import the original CSV again; cell formatting cannot recover characters that were removed.

Why does my CSV open in one column in Excel?
Excel may have selected the wrong delimiter. Import it from the Data tab and choose the separator used by the file, often a semicolon or tab instead of a comma. The preview should show separate fields in separate columns before you load the data.

Can Excel import a CSV with semicolons?
Yes. In the Text/CSV import preview, select the delimiter that matches the file. A semicolon is a common separator in some regional settings, so the file extension can still be .csv even when commas are not separating its fields.

How do I save an imported CSV as an Excel file?
After loading the data, choose File > Save As and select Excel Workbook (.xlsx). This saves the data in a workbook format that can retain Excel tables, formatting, formulas, and additional sheets. The original CSV remains a separate plain-text file unless you overwrite it.

Can I refresh a CSV import after the file changes?
If you imported through Power Query, use Data > Refresh All after updating the source. The query must still point to an accessible file, and the new CSV should have a compatible structure. If the file moved or changed its headings, update the source or query steps before refreshing.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.