To import a CSV file into rows in Excel for Microsoft 365 on Windows, select Data > From Text/CSV, choose the file, check the delimiter and preview, then select Load. Excel places each CSV record on a worksheet row and separates fields into columns; the preview lets you correct parsing before the data is loaded.
What a CSV file puts into Excel
CSV means comma-separated values, although a CSV file can use another separator, such as a semicolon or tab. It is plain text arranged in records: each line usually represents one record, and separators divide that record into fields. For example, a sales file might have a header line followed by one line per sale. When Excel parses it correctly, the header becomes the first worksheet row and each sale becomes another row, with the date, customer, and amount in separate columns.
A CSV does not store Excel formatting, formulas, multiple worksheets, or the workbook’s column widths. It stores text values and separators. Excel’s job during import is to interpret those separators and decide how each field should be represented in cells. This distinction matters: if the rows and columns look wrong, the source file may still be intact; Excel may simply have guessed the wrong delimiter or data types.
Import a CSV with the Text/CSV command
Using the import command is usually the most dependable option because you can inspect the parsing choices before loading the data. In Excel for Microsoft 365 on Windows:
- Open a blank workbook or the workbook where you want the data.
- Select Data > From Text/CSV in the Get & Transform Data area of the ribbon.
- Browse to the CSV file and select Import.
- In the preview, check that fields appear in the intended columns. Change the File Origin or Delimiter if necessary.
- Select Load to put the data on a worksheet. Select Transform Data instead if you need to adjust columns or data types before loading.
Excel normally creates a new worksheet for the imported query. If the preview is correct, Load is all most people need. For a file with a heading row, Excel generally treats the first line as column names when it creates the query table. Review the worksheet afterward, especially if the file contains unusual dates, long numbers, or codes with leading zeros.
On Mac, Excel for Microsoft 365 also offers text and CSV import through the Data tab, though the exact ribbon labels and availability can vary by update. Opening a CSV directly is another option. Excel for the web can open or upload CSV files, but its import and transformation controls are not identical to the desktop app; use desktop Excel when you need precise control over encoding, delimiters, or Power Query steps.
Choose the right delimiter and preview
The delimiter is the character Excel uses to split a line into columns. Commas are common, but regional settings and the software that created the file can lead to semicolons, tabs, or other separators. If the preview puts an entire record in one column, or breaks a value into too many columns, do not load it yet. Choose the delimiter that matches the file and inspect several rows.
Quoted fields are another reason a preview matters. A CSV can place quotation marks around a field that itself contains a comma, such as a customer address or a note reading “Call after 3, if possible.” A proper CSV parser recognizes that comma as part of the field rather than as a column break. If you split the file manually at every comma, you can damage those records. Use Excel’s import preview or Power Query rather than copying and splitting text without checking the quoting.
When the file uses an unfamiliar character set, accented letters or symbols may display incorrectly. In the import dialog, try a different File Origin or encoding option and check names and other non-English text in the preview. A wrong encoding can make the data look corrupted even though the original CSV remains unchanged.
Protect dates, long numbers, and leading zeros
Excel may automatically interpret CSV fields as dates, numbers, or other data types. That is helpful for ordinary values, but it can alter identifiers that should stay as text. For example, a product code written as 004271 may appear as 4271 if Excel treats it as a number. A long account or tracking number can also lose precision when interpreted as a numeric value.
If preserving the exact characters matters, select Transform Data and set the relevant column’s data type to Text before loading. In Power Query, select the column and use the data type control to choose Text. For dates, check the preview and the regional interpretation: a value such as 04/05/2026 can mean April 5 or May 4 depending on the date convention. If the source uses a consistent format, choose the matching locale or otherwise ensure Excel has interpreted it as intended.
- Keep postal codes, product IDs, and tracking numbers as text when leading zeros or every digit must be retained.
- Check date columns against known examples before sorting or calculating with them.
- For amounts, confirm that decimal and thousands separators match the file’s conventions.
Load the data into an existing worksheet
If you want the imported rows in a specific place, use the query’s load destination rather than assuming the default new worksheet is the only choice. After selecting Transform Data, use Home > Close & Load > Close & Load To… and choose the appropriate destination options, such as a table on an existing worksheet. The available choices can depend on how the query was created and the Excel build.
Leave enough empty space at the destination. Loading a table over existing values can create conflicts, and an imported table needs room to expand if you later refresh it with more records. If you only need a one-time copy, you can load the CSV to a new sheet and then copy the resulting cells to another location. Keep the original CSV as a separate file if you may need to re-import the unmodified source.
Open a CSV directly or use Power Query?
Double-clicking a CSV, or using File > Open, is quick for a simple file. Excel opens it as a worksheet, but it may choose separators and data types based on system or regional settings. You might not get the same opportunity to inspect and adjust import settings before the values appear. If everything is parsed correctly and the values are ordinary text or numbers, direct opening may be sufficient.
Use Data > From Text/CSV when the file has unusual delimiters, encoding issues, sensitive identifiers, or data that needs repeatable cleanup. Power Query records the import and transformation steps as a query. If the CSV is updated at the same path, you can refresh the query to retrieve the latest contents, rather than repeating every cleanup step manually. A refresh reads the source again; it does not automatically preserve hand-edited changes made inside the query output table.
If you routinely receive several similarly structured CSV files, Power Query can also combine files from a folder. In Excel for Windows, the relevant starting point is Data > Get Data > From File > From Folder. This is useful for monthly exports with the same columns, but inspect the sample file and combined result: files with different headers or layouts may not combine as intended.
Common import problems and practical fixes
- Everything is in one column: Reopen the import and select the delimiter actually used in the file. Do not assume it is a comma.
- Values are split at the wrong places: Check whether the file contains quoted fields with embedded commas. Use the CSV parser and inspect the preview rather than applying a basic text split.
- Zeros disappear from codes: Import the affected column as Text before loading. Formatting the cell as text after zeros have already been removed will not restore them.
- Dates are reversed or unexpected: Check the source convention and the locale or data type used during import. Confirm with a date you can verify.
- Characters look garbled: Try a matching File Origin or encoding in the import dialog, then review the preview again.
- The file seems incomplete: Check filters, the source file, and the number of records. A worksheet supports at most 1,048,576 rows, including any header row, so a larger file cannot fit entirely on one sheet.
A CSV can contain values that begin with characters spreadsheets may interpret as formulas, including an equals sign. Treat files from untrusted sources cautiously, and inspect unexpected formula-like content rather than assuming every field is harmless text. A CSV itself does not contain VBA macros, but opening it in a spreadsheet can still cause its contents to be interpreted according to spreadsheet rules.
Save the result in the right format
After importing, save the workbook as an Excel workbook (.xlsx) if you need to keep multiple sheets, formatting, formulas, or a Power Query connection. If you save as CSV, Excel warns that only the active worksheet is saved and workbook features such as formatting and additional sheets are not retained in the CSV. The CSV is useful for exchanging plain tabular data, while the .xlsx format is better for ongoing analysis and preserving Excel-specific features.
Before distributing a CSV, check which sheet is active and whether the data has the intended headers and values. Also remember that CSV export does not preserve display formatting: a date shown in a customized format in Excel may be written as a plain text representation. If another system expects a particular delimiter, date format, or encoding, confirm those requirements with the system that will receive the file.
Frequently Asked Questions
How do I make a CSV file open in separate Excel columns?
Use Data > From Text/CSV, select the file, and choose the correct delimiter in the preview. If it is already open in one column, importing the original file with the right delimiter is often safer than trying to repair the parsed sheet.
Does each CSV line become a row in Excel?
Usually, yes. Each record is placed on a worksheet row, and its fields are separated into columns. Quoted line breaks and unusual formatting can complicate the result, so check the preview for files that do not follow a standard layout.
How can I import a CSV without losing leading zeros?
Choose Transform Data during import, set the identifier column to Text, and then load it. Excel may remove leading zeros if it interprets a code as a number.
Can I add a CSV to an existing Excel sheet?
Yes. Use the query’s Close & Load To options to select a worksheet destination, or load to a new sheet and copy the results. Make sure the destination has enough clear space for the imported table.
Will Excel update the rows when the CSV changes?
Not if you simply opened the CSV as a worksheet. If you imported it as a Power Query connection, refresh the query to read the updated source; keep the file in the expected location and review the refreshed output.
Related
- Four-Quadrant Scatter Plot in Excel: How to Make One
- Flash Fill Settings in Excel: How to Enable or Disable
- Flash Fill in Excel: How to Fill Data by Pattern Correctly
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Freeze One Column in Excel While You ScrollTo keep Excel’s first column visible while you scroll sideways, choose View > Freeze Panes > Freeze First…
- How to Find Duplicates in Excel Quickly and AccuratelyTo find duplicate values in Excel, select the cells you want to check, then choose Home > Conditional…
- Validate Data in Google Sheets: Rules and Drop-DownsTo validate data in Google Sheets, select the cells, choose Data > Data validation, then add a rule…
- How to Hide Rows in Excel: Keyboard Shortcuts GuideIn Excel for Microsoft 365 on Windows, select a cell in the row or rows you want to…
- Google Sheets IF String Contains: Formulas and ExamplesTo make Google Sheets return one value when a cell contains text and another when it does not,…
- How to Insert a Line in Word: Borders and Shapes GuideTo insert a line in a Word document, type three hyphens (—) on a blank line and press…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.