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

How-to basics · Updated November 21, 2026

To import a CSV file into Microsoft Excel for Microsoft 365 on Windows, select Data > From Text/CSV, choose the file, check the delimiter and preview, then select Load. If you need to protect leading zeros, dates, or other sensitive values, choose Transform Data first and set the relevant columns to the correct data type before loading.

What a CSV import does

A CSV, or comma-separated values file, is plain text organized into rows and fields. It commonly uses commas between fields and line breaks between records, although some files use semicolons, tabs, or another delimiter. A CSV does not store Excel formatting, formulas, multiple worksheets, or charts. It holds the data and the characters used to separate and represent it.

When Excel imports a CSV, it interprets that text and places the resulting fields into worksheet cells. That interpretation matters: a value such as 00127 might be read as the number 127, and a string such as 03/04/2026 might be interpreted as a date according to regional settings. A careful import gives you more control than simply opening the file and accepting Excel’s automatic guesses.

Importing is useful when you receive data from an accounting system, website, database, or other application. It is also a good choice when you want to inspect the file’s structure before Excel changes how its values appear.

Import a CSV with the Data tab

  1. Open a blank workbook or the workbook where you want the imported data.
  2. Select Data > From Text/CSV. In the file picker, locate and select the CSV, then choose Import.
  3. Review the preview. Check that columns are separated correctly and that characters such as accented letters display as expected. If needed, change the file origin or delimiter in the preview.
  4. Select Load to place the data in a worksheet. Choose Transform Data instead if you need to change column types, remove rows, or make other adjustments before loading.

Excel usually creates a table from the imported data. You can then sort, filter, format, or use the data in formulas and charts. If you select Transform Data, Excel opens the Power Query Editor. After making changes, select Close & Load to return the result to the workbook. The wording or arrangement of controls can vary slightly with Excel updates, but the Data tab route is the standard import path in Microsoft 365 for Windows.

Choose between a quick open and a controlled import

For a small, simple file that contains ordinary text and numbers, opening a CSV directly may be enough. You can use File > Open and browse to the file, or open it from File Explorer. Excel will display the data in a worksheet, but it may automatically interpret values as numbers, dates, or other types. That convenience can cause problems when the file contains identifiers, postal codes, or codes with leading zeros.

Use Data > From Text/CSV when the source has important formatting details, unusual separators, non-English characters, or values that must remain text. It also makes it easier to repeat the import process later. If the preview is wrong, you can correct the settings before loading rather than trying to repair a worksheet after automatic conversion.

Another option is Excel’s legacy Text Import Wizard. In current Windows versions, it may need to be enabled first: go to File > Options > Data, find Show legacy data import wizards, and enable From Text (Legacy). Then use Data > Get Data > Legacy Wizards > From Text (Legacy). This wizard offers step-by-step controls for delimited or fixed-width text. It can help with older workflows, but the modern Text/CSV import and Power Query are generally the better starting point for new imports.

Check the delimiter and column layout

The delimiter is the character that marks the boundary between fields. A comma is common, but a file produced in a region that uses a comma for decimal values may use semicolons between fields. Tab-delimited files are another common format. In Excel’s import preview, select the appropriate option from the delimiter control and check that each field appears in its own column.

A CSV can contain commas inside a field when that field is enclosed in quotation marks. For example, a row might contain 42,"Portland, Oregon",Active. The comma inside the quoted city name is part of the field, not a separator. Proper CSV readers recognize this convention, so do not split the file by manually replacing every comma. If a preview puts values in unexpected columns, check the delimiter and whether the source file follows standard quoting rules.

Some exports use a fixed-width layout, where fields occupy set character positions rather than being separated by a repeated character. In that case, a delimited import may not produce the intended columns. The legacy Text Import Wizard has a fixed-width option; alternatively, check whether the system that created the export can produce a standard delimited CSV.

Protect dates, long numbers, and leading zeros

Automatic type detection is convenient for many datasets, but it can change the meaning or appearance of particular values. Product IDs, account codes, phone numbers, postal codes, and tracking numbers are usually identifiers, not quantities. If Excel reads 000845 as a number, it may show 845. Applying a custom number format later can make zeros appear again, but the underlying value may no longer match the original text. Importing the column as text is safer when the exact characters matter.

To preserve a column as text, choose Transform Data in the import preview. In Power Query Editor, select the column, then use Transform > Data Type > Text (or the data type control on the ribbon). Review other columns as well: set genuine dates to a date type and quantities to an appropriate numeric type. Then select Home > Close & Load. The column’s type should be chosen before the values are loaded into the worksheet.

Dates are another common source of surprises. A value such as 04/05/2026 can mean April 5 or May 4 depending on the source’s convention and the import locale. Check the source system’s date format rather than assuming the preview has guessed correctly. A date displayed differently after import may still be a valid date value, while a date interpreted with the wrong month and day is a data error. For ambiguous dates, use the appropriate locale when setting the column type in Power Query or ask the source system to export dates in an unambiguous format.

Very long digit strings deserve special care, too. Excel’s numeric precision is limited to 15 significant digits; long identifiers can lose digits if treated as numbers. Set such fields to text during import. This is not the same as formatting a cell to show more digits after Excel has already converted the value.

Handle encoding and regional settings

Encoding determines how text characters are represented in a file. If names or symbols appear as question marks, boxes, or garbled characters, the selected encoding may not match the file. In the Text/CSV preview, check the File Origin setting. For many modern exports, UTF-8 is appropriate; Excel’s list may identify it as 65001: Unicode (UTF-8). Select the option that matches the source file, then inspect names with accents or other non-ASCII characters in the preview before loading.

Regional settings also affect how Excel interprets decimal and date characters. For example, a source might write a decimal as 12,5 while another uses 12.5. A comma can therefore be either a field separator or part of a number, depending on the file’s conventions. Check both the delimiter and how the preview reads numeric values. If the source is generated by another application, its export settings or documentation can clarify the expected encoding, separator, and date style.

Refresh an import and keep the source connected

When a CSV is imported through Power Query, Excel can retain a connection to the source file and the transformation steps. If the source file is updated in the same location, use Data > Refresh All to refresh workbook data. You can also right-click the imported table and choose Refresh. A refresh applies the saved steps to the current source; it does not guarantee that a changed file layout will still fit those steps. If columns are renamed, removed, or rearranged, check the query and its output after refreshing.

Directly opening a CSV is different from setting up a refreshable import. It does not create the same Power Query transformation process in a separate workbook. If you regularly receive a replacement file, use the import route and keep the source in a predictable location. Avoid renaming or moving it unless you are prepared to update the query’s source path.

Common import problems and fixes

  • Everything appears in one column: Reopen the file with Data > From Text/CSV and select the delimiter the file actually uses, such as comma, semicolon, or tab.
  • Leading zeros disappear: Import the relevant field as text in Power Query rather than allowing Excel to detect it as a number.
  • Dates are reversed or unexpected: Verify the source’s date convention and use the correct locale or type before loading.
  • Accented characters look wrong: Check File Origin and select the encoding used by the file, commonly UTF-8 for newer exports.
  • Values shift into the wrong columns: Check quoted fields and embedded delimiters in the source. A delimiter inside a properly quoted field should not create a new column.
  • The worksheet seems incomplete: Check the source file and Excel’s worksheet limits. A worksheet can contain up to 1,048,576 rows and 16,384 columns; larger datasets need a different storage or analysis approach.

If the preview itself looks incorrect, changing cell formatting after loading may not fix the underlying issue. It is usually better to adjust the import settings or transformation and load the data again. Keep an untouched copy of the original CSV when the values are important, so you can compare the imported result with the source.

Save the result in the right format

A CSV remains a plain-text data file; it cannot preserve Excel-only features such as multiple sheets, cell formatting, charts, or formulas. After importing, use File > Save As and choose Excel Workbook (*.xlsx) if you want to keep workbook features and, where applicable, the query. If you save the workbook as CSV instead, Excel warns that only the active sheet’s data can be retained and some workbook features will be lost. Keep the original CSV separately if you need an unchanged copy of the source.

Frequently Asked Questions

Can I import a CSV into an existing Excel sheet?
Yes. Use Data > From Text/CSV, then choose where to load the result if Excel offers the load destination options. Check that the chosen destination does not overwrite existing data.

Why does Excel remove zeros from a CSV?
Excel may interpret a digit-only field as a number, and numbers do not retain leading zeros. Import that field as text before loading to preserve its original characters.

Can I import a CSV without opening it first?
Yes. In an open workbook, select Data > From Text/CSV, choose the file, and load it. This lets you review the preview before the data enters a worksheet.

Does importing a CSV keep formulas or formatting?
No. CSV stores text values and separators, not Excel formulas, formatting, charts, or multiple worksheets. Save the imported result as an XLSX workbook if you need Excel features.

How do I import a semicolon-separated CSV?
Choose Data > From Text/CSV and select semicolon as the delimiter in the preview. Confirm that the fields line up correctly before selecting Load.

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.