How to Import CSV to Excel: Steps and Common Fixes

How-to basics · Updated November 21, 2026

To import a CSV into Excel for Microsoft 365 on Windows, choose Data > Get Data > From File > From Text/CSV, select the file, check the preview, and choose Load. If you need to control how Excel reads dates, numbers, or identifiers, choose Transform Data first and review the columns before loading.

What a CSV file contains

CSV stands for comma-separated values. It is a plain-text format for storing rows and columns of data, not a full Excel workbook. A CSV can contain text, numbers, and dates represented as text, but it does not retain worksheet formatting, multiple sheets, charts, or Excel formulas as workbook features. Each row normally represents a record, and a delimiter separates the fields within that row.

Despite the name, not every CSV uses a comma. A file may use a semicolon or tab, for example, depending on the program or regional settings that created it. Fields containing a delimiter can be enclosed in quotation marks. Knowing this helps explain why opening a CSV by double-clicking it can sometimes put all the data in one column or split it in unexpected places.

Import a CSV with the Data tab

The import command gives you a preview and more control than simply opening the file. In Excel for Microsoft 365 on Windows:

  1. Open the workbook that should receive the data, or start a new blank workbook.
  2. Select Data > Get Data > From File > From Text/CSV.
  3. Browse to the CSV file, select it, and choose Import.
  4. In the preview, check that the columns are separated correctly. Change the delimiter or file origin if the text appears garbled or incorrectly divided.
  5. Choose Load to add the data to a worksheet, or choose Transform Data to review and adjust it in Power Query first.

When the data is loaded, Excel places it in a worksheet, usually as a formatted table. Check the column headers, first and last rows, and a few records in the middle. A preview can look plausible while a specific column still has an incorrect type or a field has been split in the wrong place.

Load the CSV into an existing worksheet

You do not have to create a separate workbook for the import. In the import preview, use the Load dropdown and choose Load To to open the import options. Select Table, then choose Existing worksheet and specify a destination cell, such as =$A$1, if that is where the imported table should begin. The destination area needs enough room; loading into cells that already contain information can cause a conflict or overwrite data.

If you already loaded the CSV into a new worksheet, you can copy the resulting table and paste it elsewhere, but loading directly to a chosen location is usually cleaner. For a repeatable process, keep the query in the workbook and use its load destination rather than manually copying a fresh result each time. On Mac, the available Get Data options and their placement can vary by Excel release; use the Data tab’s text/CSV import option if present, and check the destination choices in the load dialog.

Choose between importing and opening

For a quick look at a small, straightforward file, opening a CSV directly in Excel may be convenient. In Windows, you can use File > Open, or open the file from File Explorer. Excel treats it as a workbook and displays the CSV contents in a sheet. The drawback is that Excel may apply automatic interpretation without giving you the same opportunity to review every column first.

Use Data > Get Data > From File > From Text/CSV when the file has identifiers with leading zeros, ambiguous dates, unusual delimiters, non-English characters, or a regular update schedule. The import preview and Power Query provide a safer way to confirm how the source is being interpreted. Excel for the web can open or work with CSV files, but its import and transformation controls are not identical to the desktop version. For detailed data preparation, use Excel desktop.

Check the delimiter and text encoding

If every line appears in a single column, the selected delimiter probably does not match the file. In the preview, try the delimiter that the source uses, commonly comma, semicolon, or tab. A CSV exported in a region that uses commas for decimal values may use semicolons between fields. Quoted text can also contain commas without those commas marking column boundaries; a proper CSV import recognizes the quotation marks and keeps the field together.

If accented letters or other characters appear as question marks or strange symbols, the file may be using a different text encoding than Excel expects. Check the File Origin or encoding choice in the import preview and select the encoding appropriate for the source. UTF-8 is common for current exports, but do not assume it is always the right setting. If you can ask the system that produced the file to export it again, request a consistent encoding and delimiter.

Protect dates, numbers, and identifiers

Excel tries to recognize data types, which is helpful for ordinary dates and amounts but risky for values that only look numeric. Product codes, postal codes, account references, and barcodes may need to remain text. For example, an identifier such as 004271 can become 4271 if Excel treats it as a number. Long digit strings may also display in scientific notation or lose precision when interpreted numerically.

Choose Transform Data to inspect columns in Power Query before loading. Select a column and set its data type deliberately: use Text for identifiers that must preserve every character, and use an appropriate number or date type for values you intend to calculate or sort as dates. If Power Query has added a Changed Type step that converted a column incorrectly, edit or remove that step and set the intended type instead. Check date interpretation carefully: a value such as 04/05/2026 can mean April 5 or May 4 depending on the source’s date convention and locale.

Do not rely on changing a column’s format after an identifier has already lost leading zeros. Formatting the cell to display zeros may make it look right without restoring the original text value. It is safer to import the field as text from the start. For numeric amounts, verify decimal and thousands separators too; a value written as 1.234,50 may be interpreted differently from 1,234.50.

Use Power Query for repeat imports

Power Query is Excel’s built-in tool for connecting to, transforming, and loading data. When you import a CSV and choose Transform Data, you can remove unwanted columns, rename headers, filter rows, split a column, or correct data types before the results reach the sheet. Excel records these transformations as query steps, so you can apply the same preparation again when the source file changes.

For a recurring report, save the workbook with the query and replace or update the source file as appropriate. Then use Data > Refresh All to refresh workbook connections and queries. If the file has moved or been renamed, the query may need its source location updated before it can refresh. Refreshing retrieves the source data again; it does not mean that manually edited values in the loaded result will become part of the CSV.

Common import problems and fixes

  • All data appears in one column: Reopen the import preview and select the delimiter used by the file. Confirm whether fields are quoted correctly.
  • Leading zeros disappear: Import the relevant column as Text in Power Query, then load it again from the original CSV.
  • Dates are reversed or inconsistent: Check the source’s date convention and set the column’s type using the correct locale before loading.
  • Characters look corrupted: Try the appropriate text encoding in the preview, often UTF-8 for modern exports.
  • Numbers have unexpected decimals or separators: Confirm the file’s regional number format and use a matching locale or correct type in Power Query.
  • Some rows are missing: Check whether a filter was applied during transformation and whether the file exceeds Excel’s worksheet capacity.

An Excel worksheet supports up to 1,048,576 rows and 16,384 columns. A CSV that exceeds either limit cannot fit in a single sheet, even though the text file itself may contain more data. For a dataset too large for a worksheet, consider Power Query’s data model or a database tool rather than trying to force the whole file into visible cells.

Save the imported data in the right format

After importing, save the working file as an Excel workbook (.xlsx) if you want to keep the worksheet, formatting, multiple tabs, and query setup. Use File > Save As and select Excel Workbook. A CSV is useful for exchanging plain tabular data, but it cannot preserve the full workbook structure. When saving a workbook back to CSV, Excel saves only the active sheet in a plain-text format, so other sheets and workbook features are not carried into that file. Keep the original CSV unchanged if you may need to repeat the import or verify the source data.

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 the identifier column to Text before loading. This prevents Excel from treating values such as postal codes or product IDs as numbers.

Can I import a CSV into a specific cell?

Yes. In the import preview, open the Load dropdown, choose Load To, select Existing worksheet, and enter the destination cell. Make sure the selected area will not collide with data already in the sheet.

Why does my CSV open in one column?

Excel may have selected a delimiter that the file does not use. Import the file through the Data tab and choose the correct delimiter in the preview, such as a comma, semicolon, or tab.

Can I refresh an imported CSV after it changes?

Yes, if you imported it as a query and the source file remains available at the expected location. Use Data > Refresh All. If the file has moved, update the query’s source before refreshing.

Should I save the result as CSV or XLSX?

Choose XLSX to keep Excel features such as multiple worksheets, formatting, and queries. Choose CSV only when you need a plain-text data export, and remember that it contains just one sheet rather than the full workbook.

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.