Import CSV Into Excel as Rows, Not Columns the Right Way

Formulas & functions · Updated November 21, 2026

To import a CSV into Excel with each record on its own row, open Excel and choose Data > From Text/CSV, select the file, check that the preview shows one record per row, and choose Load. In a CSV, line breaks separate rows and delimiters such as commas separate columns, so if everything appears in one column, change the delimiter rather than transposing the data.

How CSV rows and columns work

CSV means comma-separated values, a plain-text format for tabular data. Typically, each line in the file represents one record, while commas separate that record’s fields. For example, a file containing Name,City,Score on its first line and Ana,Denver,92 on its next line should import as two rows and three columns: the header row, followed by Ana’s record.

This distinction explains a common misunderstanding. If Excel puts the whole line into one cell or one column, it has not necessarily turned rows into columns; it may simply have failed to recognize the delimiter. If each record is already a separate row but its fields run vertically, that is a different layout problem and may call for transposing the data.

Import a CSV with Excel’s data import tool

In Microsoft Excel for Microsoft 365 on Windows, use the import tool when you want to check how the file will be interpreted before it enters the worksheet:

  1. Open a blank workbook or the workbook where you want the imported data.
  2. Select Data > From Text/CSV.
  3. Browse to the CSV file, select it, and choose Import.
  4. In the preview window, check that each line of the file appears as a separate row. Choose the correct option from the Delimiter menu if the columns are not split as expected.
  5. Choose Load to place the data in a worksheet. If you want to inspect or adjust the query first, choose Transform Data instead.

For an ordinary CSV, the preview’s default delimiter is often comma. When the file uses another separator, such as a semicolon or tab, select that separator instead. The preview lets you catch problems before loading; it is especially useful for files from systems with different regional settings or export conventions.

Excel creates a connected query when you import through this route. You can refresh the query if the source file changes, provided the file remains available at the same location. If you only need a one-time copy, you can work with the loaded worksheet normally; if you need to edit the import steps later, use the workbook’s query tools.

Choose the delimiter that matches the file

Do not assume every file ending in .csv uses commas. A program may use semicolons, tabs, or another separator, depending on its settings. If the preview shows a whole record in one column, inspect the file’s first few lines in a plain-text editor. The character between fields is the delimiter you need to select. Do not choose a delimiter just because its name is familiar: using the wrong one can split values that belong together.

Some fields can contain commas as part of their value. A correctly formatted CSV places those fields in quotation marks, for example "Denver, Colorado". A capable CSV import recognizes the quotation marks and keeps that location together in one cell, rather than splitting it at the internal comma. If a file was generated incorrectly or uses unusual quoting, the preview may still look wrong; check the source file or ask the system that created it for a properly formatted export.

There is also an important difference between a delimiter and a line break. The delimiter separates fields across columns; a line break usually starts the next record and therefore the next row. A quoted field can sometimes contain an intentional line break, so a multi-line cell does not always mean the file has an extra record. The import preview can help reveal how Excel is interpreting the file.

Fix a CSV that opens in one column

If you opened the CSV and all the text is already in column A, you can split it in place with Excel’s Text to Columns feature. Select the affected column, then choose Data > Text to Columns. Select Delimited, choose Next, select the separator used in the file, and review the preview. Choose Finish when the preview shows the intended columns.

This is a practical repair for a small, straightforward file, but it splits text already in the worksheet rather than importing the original file with a preview. Make sure the destination cells are empty: splitting values can overwrite adjacent data. If the CSV contains quoted commas, complex text, or fields that must retain leading zeros, reimporting through Data > From Text/CSV is generally a safer choice because you can inspect and set import behavior before loading.

If Excel has placed each field in its own column but the records are not on separate rows, inspect the source file’s line breaks. A normal comma-separated file uses a line break between records. If all records were exported onto one line, or the line breaks are missing, changing the delimiter will not recreate the original record boundaries reliably. Correcting the export at its source is often the best fix.

Keep IDs, dates, and other values intact

CSV files store text, not Excel’s full range of cell formatting and data types. When importing, Excel may interpret values automatically. That can be convenient for ordinary numbers, but it can alter identifiers or codes. For instance, a value such as 00127 may be treated as the number 127, dropping its leading zeros. A long account number may also be displayed in scientific notation or lose precision if treated as a number.

In the import preview, check the data type options and the appearance of important columns before loading. If a value is an identifier rather than a number for calculation, preserving it as text is often appropriate. In Power Query, choose Transform Data to review column types and change a column’s type before loading. The available controls and labels can vary with the file and Excel build, so confirm the preview and the loaded result.

Dates deserve the same care. A value like 03/04/2026 can mean March 4 or April 3, depending on the date convention used by the source. Check the source system’s format and Excel’s interpretation rather than assuming. CSV does not preserve the original workbook’s date display format, formulas, colors, or multiple sheets; it contains text values in a delimited structure.

When transposing is actually the right fix

Transpose is for changing orientation, not for choosing how a CSV separates fields. Suppose the file has the names Ana, Ben, and Chen in cells A1, A2, and A3, but you need them across a row. Copy the cells, select an empty destination, then use Home > Paste > Transpose. In Excel for Microsoft 365 on Windows, you can also use the Paste Special dialog and select Transpose. The exact menu presentation can vary with the ribbon layout.

Use transpose only when the data is genuinely arranged in the opposite orientation from the one you need. For example, if a report has dates down the first column and each measure in a separate row, transposing will swap rows and columns throughout the selected range. It may make a table harder to use if the first row should be headers and each later row should be one record. For a conventional CSV export, import the file and correct its delimiter instead.

Opening a CSV directly versus importing it

Double-clicking a CSV or opening it from Excel can be quick, and Excel often recognizes common comma-delimited files automatically. The drawback is that you may have less control over interpretation before the data appears. If the system’s delimiter or regional settings differ from Excel’s expectations, the result might land in one column or values may be converted unexpectedly.

Use Data > From Text/CSV when you need to inspect the delimiter, verify the row structure, or protect sensitive columns from automatic conversion. Use direct opening for a simple file when the layout and values are already correct, but review the result before relying on it. If the file will be reused or updated, importing through the data tools can also provide a refreshable connection.

On Excel for Mac, import options and ribbon labels can differ by release; look for the text or CSV import option on the Data tab and confirm the delimiter in its preview when available. Excel for the web may not provide the same full set of import and Power Query controls as the Windows desktop app. When exact delimiter or type control is needed, use the desktop version where those options are available.

Save the imported data in the right format

After a successful import, consider saving your working file as an Excel workbook (.xlsx) using File > Save As. A CSV file cannot preserve workbook features such as multiple worksheets, formulas as formulas, cell formatting, or an Excel data connection in the way an .xlsx workbook can. Saving as .xlsx gives you a place to keep the imported table and any later analysis without trying to store workbook features in the CSV.

Keep the original CSV if you may need to import it again or verify the source data. If you save changes back to CSV, Excel may warn that some workbook features are incompatible with the format. CSV is useful for exchanging plain tabular data, but it is not a substitute for a formatted Excel workbook.

Frequently Asked Questions

How do I import a CSV into Excel without everything going into one column?
Choose Data > From Text/CSV, select the file, and set the Delimiter menu to the character that separates its fields, such as comma, semicolon, or tab. Check the preview before selecting Load.

How do I put each CSV record on a new row?
A properly structured CSV uses a line break between records, so Excel normally puts each record on a separate row automatically. If records appear across columns, check whether the file’s line breaks are missing or whether you are describing a transpose problem rather than a delimiter problem.

Why does Excel split my data at the wrong places?
The selected delimiter may not match the file, or a field may contain an unescaped delimiter. Check the source in a text editor and confirm the delimiter and quotation marks in Excel’s import preview. Avoid splitting a file with Text to Columns if quoted delimiters need special handling.

Can I import a CSV and keep leading zeros?
Yes, but check the column before loading. If values such as product codes are identifiers, import or set the column as text rather than letting Excel treat them as numbers. Verify the result because automatic type detection can vary with the file and import route.

Should I use Text to Columns or From Text/CSV?
Use From Text/CSV to bring in a file with a preview and import controls. Use Text to Columns when the data is already in a worksheet and a simple delimiter split is all you need. For complex quoting or important data types, importing the original file is usually the more controllable option.

Related

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

More in Formulas & functions

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

Spotted an error in this guide? Let us know.