Excel CSV Import Options: Which Method to Use

How-to basics · Updated November 18, 2026

In Excel for Microsoft 365 on Windows, the most controlled way to import a CSV is Data > Get Data > From File > From Text/CSV: choose the file, check its encoding and delimiter in the preview, then select Load or Transform Data. For a quick look, you can open a CSV directly; use the import workflow when column types, dates, leading zeros, or repeatable updates matter.

What a CSV file contains

A CSV, or comma-separated values file, is a plain-text format for storing rows and columns. It does not preserve Excel formatting, formulas, worksheets, charts, or reliable column-type information. A value such as 00127 is just text in the file; when Excel reads it, Excel may interpret it as the number 127 and discard the leading zeros. Dates and large numbers can also be interpreted differently from what the file author intended.

Despite the name, a CSV does not always use commas. The delimiter may be a tab, semicolon, or another character, depending on how the file was produced and the computer’s regional settings. Fields that contain the delimiter can be enclosed in quotation marks, so a comma inside a quoted address field does not necessarily mark a new column. The import preview helps Excel distinguish these cases.

Import with From Text/CSV

For a one-time import where you want to inspect the file before it enters the worksheet, use this Windows workflow:

  1. Open the workbook that should receive the data, or start a blank workbook.
  2. Select Data > Get Data > From File > From Text/CSV, then choose the CSV and select Import.
  3. In the preview, check File Origin or encoding, Delimiter, and the column layout. Change a setting if the preview does not match the source.
  4. Select Transform Data to review or adjust columns in Power Query, or select Load to bring the previewed data into Excel.

Use Load To, when available, if you need to choose where the results go or how they are loaded. Depending on the workflow, you can load the result as a table, create a connection, or choose another supported destination. A table is a practical choice for ordinary analysis because it has headers and can be filtered and sorted. Before loading into an existing sheet, check the destination so the imported rows do not overwrite useful content.

The preview is more than a cosmetic check. If a single field appears split across several columns, the delimiter is likely wrong. If accented characters appear as symbols, the encoding may be wrong. Correct those choices before loading rather than trying to repair a badly interpreted worksheet afterward.

Open a CSV directly for a quick look

You can also use File > Open to select a CSV, or open it from File Explorer. Excel will display the contents as a worksheet and make automatic interpretation choices. This route is convenient when the file is simple and you only need to inspect or edit it. It is less suitable when the source includes identifiers, dates in an unfamiliar format, or other values that must remain exact.

When Excel opens a CSV directly, the result depends on how Excel recognizes the delimiter, encoding, and values. A column of postal codes may become numbers; a string resembling a date may become a date serial displayed in a date format; long digit strings may lose precision if treated as numbers. If accuracy matters, use the import preview or Power Query and explicitly set the relevant columns to Text before loading.

Choose the delimiter and encoding

The delimiter determines where Excel starts a new column. In the From Text/CSV preview, inspect the headings and several rows, not just the first line. If the file uses semicolons but the preview expects commas, Excel may show each row as one long field or divide it incorrectly. Select the delimiter that matches the actual file. For a tab-delimited text file, choose Tab; for other formats, use the relevant delimiter option if offered.

Encoding controls how characters are represented. UTF-8 is common for modern exports, but older programs may produce other encodings. If names or symbols containing accents, non-Latin characters, or special punctuation are corrupted, change the file origin or encoding selection and check the preview again. Do not guess based on one character: compare several known values, especially where the source includes different languages.

Regional settings can explain why two people see different results from the same file. One system may use commas for decimal marks and semicolons between fields; another may use periods and commas. The CSV itself may also have been exported with a chosen delimiter. The file’s actual structure and a correct preview are more useful than assuming every CSV uses a comma.

Protect identifiers, dates, and large numbers

Automatic type detection is a frequent source of import errors. Excel tries to make columns useful by recognizing numbers, dates, and other types, but a value that looks numeric is not always a quantity. Product codes, account numbers, postal codes, and phone numbers are usually identifiers. They should generally remain text, even when they contain only digits.

  • Leading zeros: Import a code such as 00481 as Text if the zeros are part of the identifier. If Excel has already converted it to 481, changing the cell format to Text afterward will not restore the missing zeros; reimport from the source with the column treated as text.
  • Dates: Check ambiguous values such as 03/04/2026. Depending on the source convention and regional settings, that could mean March 4 or April 3. Use Power Query’s locale-aware type conversion when the source uses a known date convention.
  • Long numeric strings: Do not let identifiers with many digits become numbers. Excel numeric precision is limited to 15 significant digits, so digits beyond that may not remain exact.
  • Mixed columns: A column containing numbers, labels, and blanks may be classified unexpectedly. Set it to Text when preserving the original representations is more important than doing arithmetic on it.

In Power Query, select a column and use the data type control to set its type. For locale-sensitive conversion, use the column’s context menu and choose Change Type > Using Locale, then select the appropriate type and locale. If you want to avoid type inference, inspect the query steps and remove or adjust an automatically added Changed Type step before loading. Available labels and options can vary slightly with Excel updates.

Use Power Query for repeatable imports

Power Query is useful when a CSV will be refreshed or when it needs cleaning before it reaches the worksheet. Selecting Transform Data opens the Power Query Editor. There you can rename or remove columns, filter rows, split a field, change data types, and reorder columns. The original file remains separate; the query records the transformation steps.

After the query is loaded, use Data > Refresh All to update it from its source when the file location and format remain compatible. This can save time for recurring reports, but refresh is not a guarantee that every new file will fit the old query. If the source changes its column names, delimiter, folder location, or layout, the query may need adjustment. Keep a stable source path and check refreshed results when the provider changes its export.

Power Query also helps keep the raw data and analysis separate. You can load a cleaned result to a worksheet or, where offered, create a connection rather than filling a sheet. For large or repeated files, that separation makes it easier to document the transformation and rerun it consistently than to repeat manual edits after every import.

Use the legacy Text Import Wizard when needed

The older Text Import Wizard offers a step-by-step way to define a delimited or fixed-width file and specify column formats. It can be useful when you need its particular controls, such as marking selected columns as text during import. In current Microsoft 365 for Windows, the wizard may need to be enabled first: go to File > Options > Data, select From Text (Legacy) under Show legacy data import wizards, and confirm. Then use Data > Get Data > Legacy Wizards > From Text (Legacy).

In the wizard, choose whether the file is delimited or fixed width, set the delimiter or column breaks, and review the data preview. In the final step, select a column and set its format, such as Text, where preservation is important. The wizard is a different interface from the newer Power Query import and is not necessary for most files. Prefer the current From Text/CSV route unless you specifically need the legacy workflow.

Common import problems and fixes

  • Everything lands in one column: Reopen the import preview and select the delimiter actually used by the file. Also check whether the file is tab-separated or uses semicolons.
  • Text is garbled: Change the encoding or File Origin setting, commonly to UTF-8 for a modern UTF-8 export, and confirm the preview before loading.
  • Dates are reversed or changed: Verify the source’s date convention and use an appropriate locale-aware conversion. If the values must remain untouched, import them as text.
  • Zeros disappear: Set the affected column to Text before loading and reimport from the original CSV.
  • Values appear in the wrong columns: Check for quoted fields and the selected delimiter. A well-formed CSV can contain delimiters inside quotation marks without those characters separating fields.
  • Excel displays a number in scientific notation: Treat long identifiers as text. A display-format change cannot recover digits that Excel has already rounded.

If a file looks wrong after loading, return to the source rather than assuming worksheet formatting will fix it. Formatting can change how an existing value appears, but it cannot reliably restore information already discarded during interpretation. Keep an unchanged copy of the CSV and repeat the import with safer type settings.

Excel for Mac and Excel for the web

The main guidance above is for Microsoft 365 on Windows. Excel for Mac also has text and CSV import capabilities, including Power Query in supported Microsoft 365 versions, but menus and available connectors can differ by update and platform. Look under the Data tab for the text/CSV or Get Data import option available in your build, and use the preview to verify the delimiter and types. If a named Windows menu is absent, check Excel’s current help for that Mac release rather than assuming the same path exists.

Excel for the web can open and work with CSV data, but its import and transformation controls are not identical to the Windows desktop Power Query workflow. For a file that needs careful encoding, type, or locale handling, use desktop Excel when possible, then save the workbook in an Excel format if you need to preserve types and workbook features. Saving a worksheet back as CSV retains plain-text data, not the full workbook structure.

Frequently Asked Questions

What is the safest way to import a CSV into Excel?
Use Data > Get Data > From File > From Text/CSV, inspect the preview, and set important identifier or date columns to the right types before loading. This gives you more control than opening the file directly.

How do I stop Excel from removing leading zeros?
Import the column as Text before loading, using the preview and Power Query or the legacy wizard. If the zeros have already vanished, reimport from the original CSV; changing the cell format afterward does not bring them back.

Why does my CSV open in one column?
The delimiter Excel selected may not match the file. In the import preview, choose the actual delimiter, such as comma, semicolon, or tab, and confirm that the columns separate correctly.

Can Excel import a semicolon-separated CSV?
Yes. Use the From Text/CSV preview and select semicolon as the delimiter when it is not detected correctly. This is common when regional number and list-separator conventions differ.

Can I refresh an imported CSV after it changes?
Yes, if you import it through a Power Query connection and the source remains accessible at the expected location. Use Data > Refresh All, then check the result if the file’s columns or structure have changed.

Does importing a CSV preserve formulas or formatting?
No. CSV stores plain-text field values, not Excel formulas, cell formatting, multiple worksheets, or charts. To retain those workbook features, save and share an Excel workbook format such as .xlsx instead.

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.