Excel CSV Import: Open and Fix Files in Microsoft 365

Errors & fixes · Updated November 21, 2026

To import a CSV file into Excel for Microsoft 365 on Windows, select Data > Get Data > From File > From Text/CSV, choose the file, check its delimiter and column types in the preview, then select Load. For a one-time, uncomplicated file, you can also open the CSV directly; the import route gives you more control when Excel might misread the data.

What a CSV file contains

CSV stands for comma-separated values. It is a plain-text format for rows and columns, not a full Excel workbook. A row in a CSV generally represents a record, and a delimiter separates fields. Although commas are common, files may use tabs, semicolons, or another character, depending on the software or regional settings that created them. Text fields can be enclosed in quotation marks so a comma inside a field is not mistaken for a column break.

A CSV does not retain Excel features such as multiple worksheets, cell formatting, charts, or formulas as working formulas. It is useful for exchanging simple tables between databases, websites, and spreadsheet programs, but it should not be treated as a complete workbook format. If you need to preserve Excel features after importing, save the result as an Excel workbook.

When to import instead of opening the file

Opening a CSV directly is quick, but Excel has to make decisions about how to split and interpret its contents. A file with ordinary comma-separated numbers and dates may open correctly, while a file with leading-zero codes, unusual date formats, or a semicolon delimiter may not. Double-clicking a CSV in File Explorer can also open it using Windows file associations and regional defaults, rather than giving you a chance to review import settings.

Use the Data import command when the source is important, will be used repeatedly, or contains values that must remain exact. It is especially useful for product codes, postal codes, account identifiers, or dates in a format that differs from your computer’s regional settings. For a small file that you have checked and do not need to reimport, opening it directly may be adequate.

Import a CSV with the Data tab

  1. Open a blank workbook, or the workbook where you want the imported data. Select Data > Get Data > From File > From Text/CSV.
  2. Browse to the CSV, select it, and choose Import. Excel displays a preview of the file before loading it.
  3. Check that the columns are divided correctly. If they are not, choose the correct delimiter in the preview instead of accepting the detected one.
  4. Check the file origin or encoding if accented or non-Latin characters look incorrect. UTF-8 is common, but the right selection depends on how the file was saved.
  5. Choose Load to place the data in Excel. Choose Transform Data if you need to inspect or adjust columns in Power Query before loading.

After loading, check several rows against the source, including the first and last rows. Confirm that headers appear in the right columns and that long values have not been shortened or reformatted. For a large file, also check the row count so you can catch an incomplete or unexpected import.

Choose the delimiter and file origin

The delimiter determines where one field ends and the next begins. Excel often detects it, but detection is not guaranteed to match the source. For example, a semicolon-delimited file imported as comma-delimited may show each row in a single column. A comma-delimited file interpreted as semicolon-delimited can produce a similar problem. Select the delimiter that matches the file’s structure and verify the preview shows the expected number of fields.

Encoding, sometimes labelled file origin, controls how text characters are decoded. If names such as “Málaga” or “François” appear with stray symbols, the file may be read with the wrong encoding. Try the encoding specified by the system that produced the CSV, or UTF-8 if that is the source’s format. Do not assume that changing the delimiter will fix garbled characters: delimiter and encoding are separate settings.

Quoted fields can contain delimiter characters. For example, a CSV row might contain a company name such as “Smith, Jones Ltd.” inside quotation marks. A correctly parsed import keeps that comma in one field. If the preview splits the name into two columns, check the delimiter and text-qualifier settings rather than manually repairing every row.

Protect dates, codes, and other data types

Excel may automatically interpret text as numbers, dates, or other types. That can be helpful for calculations but risky for identifiers. A code such as 004812 may become 4812 if imported as a number, and a value such as 3-4 might be interpreted as a date under some regional settings. Once leading zeros are removed, changing the cell’s number format to Text does not restore them.

If you use Transform Data, review the detected data types in Power Query before loading. Set columns that must remain unchanged—such as postal codes, SKU values, or long reference numbers—to Text. For dates, ensure that the year, month, and day are interpreted in the intended order. Power Query offers a locale-based type choice for cases where the source’s date convention differs from your Windows settings.

It is useful to distinguish a number that represents an amount from a number that is only an identifier. Sales totals usually need a numeric type for sorting and calculation; a customer ID should generally be text even if it contains only digits. Decide based on what the field means, not just what its characters look like.

Fix common CSV import problems

  • Everything appears in one column: Reimport through the Data tab and select the delimiter used by the file. Check the preview before loading.
  • Text is garbled: Try the correct file origin or encoding, especially UTF-8 when that is how the source was exported.
  • Leading zeros disappear: Import the relevant column as Text. Formatting the cells after zeros are lost will not bring them back.
  • Dates switch day and month: Use the source’s date convention or select a locale-aware type in Power Query, then verify ambiguous dates such as 04/05/2026.
  • Numbers show unexpected decimal or thousands separators: Check the source’s regional format and the locale used for conversion. A period or comma can have different meanings in different locales.
  • Some rows have extra or missing fields: Inspect quotation marks and delimiters in the source. A delimiter inside a properly quoted field should not create a new column.

For a stubborn file, open a copy in a plain-text editor to inspect the actual separators and quotation marks. Do not edit the only source copy unless you understand the format: changing commas or quotes indiscriminately can damage fields that contain those characters intentionally.

Refresh a repeatable import

If you expect to import an updated version of the same file, using the Data tab can create a query that you can refresh rather than rebuilding the import by hand. In Excel, use Data > Queries & Connections to view queries and connections; a loaded query can be refreshed from the Data tab. The exact refresh behavior depends on how the query was created and where its source file is stored.

This is helpful for recurring reports, but it is not magic: Excel needs to be able to find the source again. Moving or renaming the CSV can break the connection, and replacing the source with a file that has different columns may require adjustments. Before relying on a recurring import, test it with a new copy of the source and confirm the refreshed table has the expected headers, types, and row count.

Save the result in the right format

When you save a CSV that you opened in Excel, Excel may prompt you that some workbook features cannot be saved in CSV format. That warning reflects the format’s limitations: CSV saves plain tabular text, not multiple sheets, formatting, charts, or Excel-specific features. Choose Excel Workbook (*.xlsx) when you want to keep the imported data in a normal workbook with its worksheets and formatting.

Keep a separate copy of the original CSV if you need an untouched source for auditing or later reimport. Saving changes back to CSV can change the appearance of dates or numbers according to how Excel writes the file, and it will not preserve workbook-only features. If another system requires a CSV, export a deliberate copy and confirm that the receiving system accepts its delimiter and encoding.

Security and untrusted CSV files

A CSV is text, but opening one in a spreadsheet can cause values to be interpreted as formulas when they begin with characters Excel recognizes as formula indicators, such as an equals sign. This matters particularly for files from unfamiliar sources: a maliciously prepared cell may not behave like harmless plain text. Treat an unexpected CSV with the same caution as other downloaded files.

For untrusted data, review the source and the import preview, and consider importing columns as text when they should not be evaluated as formulas. Avoid enabling or running macros from files you do not trust; a CSV itself does not contain VBA macros, but it can still contain content that spreadsheet software interprets. If the data is sensitive, also follow your organization’s rules for storing and sharing it.

Excel on Mac and Excel for the web

The steps above are for Microsoft 365 Excel on Windows. Excel for Mac also supports importing text and CSV data, though ribbon labels and dialog layouts can vary by release. Look on the Data tab for text/CSV import or text import options, and use the preview to select the delimiter and review the result. On Mac, the equivalent of the Windows Ctrl key is often Command for shortcuts, but the import workflow itself is menu-based.

Excel for the web can open files stored in OneDrive or SharePoint, but its import controls may not offer the same level of delimiter, encoding, and type management as desktop Excel. If precise control matters, open the workbook in the desktop app and use the Data import workflow. Regardless of platform, check identifiers and dates after loading rather than assuming the preview or automatic detection is correct.

Frequently Asked Questions

Can I just copy and paste CSV text into Excel?
Yes, but pasted text may stay in one column or be split according to Excel’s current settings. For dependable control over delimiters, encoding, and types, use Data > Get Data > From File > From Text/CSV.

Why does Excel put my whole CSV in one column?
The file’s delimiter may differ from the one Excel detected. Import it from the Data tab and select the actual delimiter shown in the source, such as a semicolon or tab, then check the preview.

How do I stop Excel removing zeros at the start of a value?
Import that column as Text before loading. If Excel has already converted 00127 to 127, applying the Text format afterward does not recover the original zeros; reimport from the unchanged CSV.

Will importing a CSV keep my formulas and formatting?
No. CSV is a plain-text table format and does not preserve workbook formatting, multiple sheets, charts, or working Excel formulas. After importing, save as .xlsx to retain Excel workbook features.

Can I refresh a CSV import after the source changes?
If you brought it in as a query and the source location remains available, you can refresh the query from the Data tab. Confirm that the updated file’s layout still matches the query’s expectations.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

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

Spotted an error in this guide? Let us know.