To import a CSV into Excel for Microsoft 365 on Windows, select Data > From Text/CSV, choose the file, check the delimiter and preview, then select Load or Transform Data. This method gives you more control over how Excel interprets the file than simply opening it, which matters when the CSV contains dates, leading zeros, unusual characters, or values with commas.
What a CSV file contains
CSV stands for comma-separated values. It is a plain-text format for storing rows and columns: each line usually represents a row, and separators divide the fields. Despite the name, a CSV does not always use commas. Depending on how it was created or the computer’s regional settings, it may use semicolons or another delimiter.
A CSV stores data, not the full spreadsheet experience. It does not preserve Excel formulas, multiple worksheets, cell formatting, charts, or column widths. A CSV can contain text that looks like a date or number, but it does not reliably record how Excel should interpret that text. Excel makes those interpretation decisions when it opens or imports the file.
For example, a CSV might contain the value 00127. Excel may treat it as the number 127 and discard the leading zeros. A CSV value such as 03/04/2026 may also be interpreted as a date, with the meaning depending on regional date conventions. Import settings help reduce these surprises.
Import a CSV with the Data tab
For a controlled import in Excel for Microsoft 365 on Windows, use the built-in text and CSV connection:
- Open a blank workbook or the workbook where the imported data should go.
- Select Data > From Text/CSV.
- Browse to the CSV file, select it, and choose Import.
- Review the preview. Check the delimiter, file origin or encoding, and whether the columns appear in the expected places.
- Choose Load to put the data into Excel, or choose Transform Data to inspect and adjust it in Power Query first.
Excel normally loads the result as a table on a new worksheet. If you want to control where the data goes, use the options on the Load button, such as Load To, when available. Loading into a new worksheet is often the safest first choice because it avoids overwriting existing cells.
If the preview shows every row in one column, or splits values incorrectly, do not load it yet. Change the delimiter in the preview and confirm that the fields line up. The preview is a useful check, but it is not a substitute for reviewing the imported data, especially for files with many rows or mixed data types.
Choose between Load and Transform Data
Load is suitable when the preview is correct and you want a quick import. Excel creates a table containing the parsed rows and columns. You can then sort, filter, format, and analyze the data like other worksheet data.
Transform Data opens Power Query Editor. It lets you inspect and shape the data before it reaches the worksheet. Common tasks include removing unwanted columns, filtering rows, changing column types, splitting a column, or replacing values. When you select Close & Load, Excel sends the result to the workbook.
Power Query is especially useful when the same kind of CSV arrives regularly. You can keep a query and refresh it with updated source data, rather than repeating every cleanup step manually. A refresh can still require attention if the file moves, its name changes, or its columns change. Check the query’s source and preview after changes rather than assuming a refresh produced the intended result.
Check delimiters, encoding, and regional settings
The delimiter determines where Excel separates one field from the next. Commas are common, but a file exported in a region where commas mark decimal places may use semicolons between fields. If the preview is misaligned, try the delimiter that matches the file’s structure. Do not select a delimiter just because the file extension is CSV.
Encoding controls how text characters are represented in the file. A mismatch can turn accented letters or other non-English characters into garbled symbols. In the import preview, check the file origin or encoding option and choose the setting that displays the text correctly. UTF-8 is common for modern exports, but the right choice depends on the file.
Regional settings can also affect how dates and decimal numbers are interpreted. For example, 1,25 may represent a decimal value in one locale, while another uses a period. A date written as 04/05/2026 can be ambiguous without knowing the convention used by the source. If a value’s meaning matters, confirm the source format and use Power Query to set the relevant column type and locale where appropriate.
Protect identifiers, dates, and long numbers
Excel may automatically convert text into numbers, dates, or other types. This is convenient for ordinary totals and dates, but risky for identifiers that should remain exactly as written. Examples include postal codes, product codes, account references, and numbers with leading zeros.
- Leading zeros: Import an identifier column as text if values such as
00481must retain their zeros. - Long digit strings: Excel’s numeric precision is limited to 15 significant digits. Long account or tracking numbers should generally be treated as text to avoid altered digits.
- Dates: Confirm the source’s date order before allowing Excel to convert ambiguous strings into dates.
- Mixed columns: If a column contains both numbers and labels, automatic type detection may not match your needs. Review or change the type in Power Query.
In Power Query, select a column and use the data type control in the editor to choose a suitable type, such as Text, Whole Number, Decimal Number, or Date. For an identifier, Text is often safer even if every character happens to be a digit. Formatting a cell as Text after Excel has already removed zeros or changed a long number does not restore the original value; correct the conversion during import or reimport the source.
Opening a CSV directly versus importing it
Double-clicking a CSV or using File > Open is convenient for a quick look. Excel opens the file and separates its contents according to the applicable parsing and regional settings. This may be all you need for a simple file whose values are straightforward and whose formatting is not important.
The Data tab import is preferable when you need to inspect the delimiter, encoding, column types, or transformation steps before loading. It is also a better starting point for repeatable imports. Neither method changes the basic limitation of CSV: the file itself cannot preserve multiple worksheets or Excel-only features. If you need to keep a working copy with formulas, formatting, or queries, save the workbook as an Excel workbook, usually .xlsx, after importing.
When saving a workbook back to CSV, Excel saves the active worksheet rather than a complete multi-sheet workbook. It may also show a warning that some workbook features are not compatible with CSV. Keep an .xlsx copy if you need to preserve the rest of the workbook.
Common CSV import problems and fixes
- Everything appears in one column: Reimport through Data > From Text/CSV and select the delimiter that matches the file. A mismatch between comma and semicolon is a common cause.
- Columns are shifted: Check whether some fields contain delimiters inside quoted text. Properly quoted CSV fields can include commas without splitting into extra columns; malformed quoting in the source may still cause errors.
- Accented characters look wrong: Choose an appropriate encoding in the import preview, often UTF-8 for modern exports, and inspect the text before loading.
- Zeros disappeared or a code became a date: Import the affected column as Text in Power Query, then load the corrected result. If conversion already happened, start again from the original CSV.
- Numbers have unexpected decimal or date values: Verify the source’s regional conventions and set the column type and locale appropriately instead of relying on automatic detection.
- Rows or columns seem missing: Check for blank lines, unusual delimiters, line breaks inside quoted fields, or an export that did not include all source records. Compare the import with the original file or the system that created it.
For a large or important import, verify a few records near the beginning, middle, and end, and check the row count against the source. Also inspect columns that commonly hold identifiers, dates, or decimal values. A successful load only means Excel created a result; it does not guarantee that every value was interpreted correctly.
Refresh and reuse an imported CSV
If you import through Power Query, the query can provide a repeatable route from a source file to a cleaned worksheet table. To update the data, replace or update the source as appropriate, then use Data > Refresh All or refresh the relevant query. The precise source connection matters: a query may point to a particular file path, so moving or renaming the CSV can prevent refresh.
Before relying on a recurring import, confirm what happens when new rows are added and whether the file’s column names and order stay consistent. If the export changes its structure, a saved transformation may need adjustment. Keeping the original CSV unchanged and saving the processed result in an Excel workbook makes it easier to troubleshoot or repeat the import.
Excel on Mac and Excel for the web
The instructions above are for Excel for Microsoft 365 on Windows. Excel for Microsoft 365 on Mac also has Power Query import capabilities, but the available connectors and exact ribbon layout can depend on the Excel build. Look under the Data tab for the text or CSV import option; if it is not present, update Excel or use a supported Windows desktop version for that workflow.
Excel for the web can open and edit many workbooks stored online, but its import and Power Query features are not identical to the Windows desktop app. If the task requires careful control over encoding, type detection, or query setup, use the desktop app where the relevant import controls are available. After importing on desktop, save the workbook to OneDrive or SharePoint if you need to continue working on it in a browser.
Frequently Asked Questions
Can I import a CSV into an existing Excel sheet?
Yes. Use Data > From Text/CSV, then choose a load destination if the option is available. Loading to a new worksheet first is safer when you are unsure where the rows will fit, because loading into existing cells can overwrite data.
Why does Excel remove leading zeros from a CSV?
Excel often interprets digit-only fields as numbers, and numbers do not retain leading zeros. Import the column as Text before loading. Changing the cell format afterward cannot recover zeros that were already removed.
How do I open a CSV without changing its values?
Import it through the Data tab and set sensitive columns, such as identifiers, to Text in Power Query. No import can preserve an intended meaning that is not represented in the source, so confirm ambiguous dates and numbers with the system that generated the file.
Can Excel import a CSV with semicolons?
Yes. In the From Text/CSV preview, select semicolon as the delimiter when that is how the fields are separated. If the preview still looks wrong, check the source file for a different delimiter or inconsistent quoting.
Does importing a CSV preserve formulas and formatting?
No. CSV is a plain-text data format and does not preserve Excel formulas, cell formatting, charts, or multiple worksheets. After importing, save as an Excel workbook if you need to retain workbook features.
Related
- How to Lock Cells in Excel to Prevent Editing on a Sheet
- Lock Cells in Excel for the Web: A Step-by-Step Guide
- How to Lock Cells in Excel With a Password
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets Filter Shortcut: Apply a Filter FastIn Google Sheets in a web browser, press Ctrl+Shift+L on Windows, Linux, or ChromeOS to create a filter;…
- Excel Protect Sheet: Allow FilteringYes. In Excel for Microsoft 365 on Windows, turn on AutoFilter before protecting the worksheet, then allow Use…
- Excel Column to CSV: Save One Column CorrectlyTo save one Excel column as a CSV, copy the column or the exact range you need into…
- Create a Vertical Line in an Outlook Email SignatureTo create a vertical line in an Outlook signature, use a two-column table and show only the border…
- Delete a Page Break in Word Without Losing Your TextTo delete a manual page break in Microsoft Word, show formatting marks, locate the line labeled Page Break,…
- Excel Date Converter: Turn Text, Numbers, and TimestampsAn Excel date converter turns date-like text or numbers into usable Excel dates, or converts Excel dates into…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.