Excel Online CSV Import: Steps, Settings, and Fixes

How-to basics · Updated November 21, 2026

Yes. In Excel for the web, you can import a CSV file with Data > Get Data > Text/CSV, review how Excel separates and interprets the columns, then load the data into a worksheet. You can also upload or open a CSV file directly, but importing it into an existing workbook gives you more control over delimiters and data types.

Importing a CSV into an existing workbook

Use the import route when you want to add CSV data to a workbook that already contains sheets, calculations, or other material. The exact buttons can vary as Microsoft updates Excel and depending on your work or school account, but the typical process in Excel for the web is:

  1. Open the workbook in Excel for the web.
  2. Select Data > Get Data > Text/CSV. If the command offers a file picker, browse to the CSV on your device or choose the available cloud location.
  3. In the preview, check the delimiter, encoding, and the way columns are being recognized. Look for values that appear combined or split into the wrong columns.
  4. If the import flow offers Transform Data, use it to adjust column types or remove unwanted rows before loading.
  5. Choose Load, or the equivalent load command, to place the imported results in the workbook.

After loading, check the first and last few rows, the headings, and a few representative values. A preview can look right at the top while later rows contain a different pattern, such as an extra delimiter in a description. If Data > Get Data or Text/CSV is missing, your Excel web version, account, or organization settings may not expose that import route. You can try opening the CSV directly or use the desktop app instead.

Opening a CSV is different from importing one

If you only need to inspect or edit a CSV, you can upload it to OneDrive or SharePoint and open it in Excel for the web, or use the file-opening options available in your Microsoft 365 account. Excel displays the comma-separated fields as worksheet columns when it recognizes the file structure. This is convenient for a quick look, but it offers less control over how the file is interpreted than an explicit import preview.

A CSV is plain text: it does not store multiple worksheets, cell formatting, charts, Excel formulas as formulas, or workbook features such as tables. Opening a CSV in Excel does not turn the source file into a full Excel workbook automatically in every workflow. If you add formatting, extra sheets, or formulas and want to keep those workbook features, save a copy in Excel workbook format, usually .xlsx, using the available File > Save As option. Keep the original CSV if you need an unchanged copy of the source data.

For example, a CSV might contain a single header row and thousands of transaction records. Opening it is enough to sort or inspect those records. Importing is preferable when you are combining the records with an existing workbook or need to specify that an account number is text rather than a number.

Check delimiters, encoding, and regional settings

CSV stands for comma-separated values, but files do not always use a comma. Some systems export semicolon-separated files, especially where a comma is used as the decimal mark. If a preview puts an entire row into one column, the delimiter is a likely cause. If it splits a field such as a street address or description in the wrong place, check whether the selected delimiter matches the file. A properly quoted field can contain a comma without starting a new column; for instance, a CSV can place a value such as a city and state inside quotes.

Encoding affects how text appears. If names or symbols show as replacement characters or odd sequences, the file may use a character encoding Excel did not detect as expected. When the import interface provides an encoding choice, try the one specified by the system that created the file; UTF-8 is common for modern exports. Do not assume that changing the delimiter will fix garbled characters, because those are separate issues.

Dates and decimal values can also depend on regional conventions. A value such as 04/05/2026 could mean April 5 or May 4, while 1,25 may be a decimal value in one locale and a delimiter-related problem in another. Confirm the source system’s format before accepting Excel’s interpretation. When accuracy matters, import ambiguous date or number columns as text first, then convert them deliberately after checking the intended format.

Preserve leading zeros, long IDs, and dates

Excel may interpret fields that look numeric as numbers or dates. That can change how identifiers display or, in some cases, the value itself. A postal code such as 00501 can become 501 if treated as a number; a long tracking number may be displayed in scientific notation; and a code such as 3-4 may be mistaken for a date. These values are identifiers, not quantities, so arithmetic number formats are usually not appropriate for them.

Where the import flow allows column types to be set, choose Text for postal codes, product codes, customer IDs, and other fields that must remain exactly as supplied. For genuinely numeric amounts, use a number type and verify decimal separators. For dates, select a date type only after confirming whether the source uses month-first or day-first order. If you opened the CSV directly and Excel has already changed a value, undoing the display format may not restore the original digits; return to the source and import it again with the correct type.

A useful example is a product export with columns for SKU, quantity, and unit price. SKU values such as 000742 should stay text, quantity should be numeric for totals, and unit price should be numeric for calculations. Applying one type to every column is a common reason imported data later fails to match, sort, or calculate correctly.

Common import problems and practical fixes

  • Everything appears in one column: Reopen the import preview and select the delimiter used by the source file, often a comma or semicolon. If you are opening rather than importing, use the explicit Text/CSV import route if it is available.
  • Columns shift partway down the sheet: Look for unquoted delimiters inside a field, inconsistent rows, or line breaks embedded in a value. Correcting the export at its source is often more reliable than trying to repair a badly structured file after import.
  • Leading zeros disappear: Import the affected column as Text. Changing the cell display format afterward may add zeros visually but does not necessarily recover digits already discarded during conversion.
  • Dates are reversed or unexpected: Check the source’s date convention and the import locale or type settings. Import ambiguous values as text if you cannot confirm the order.
  • Accented characters look wrong: Check the encoding option in the import flow, if offered, and confirm the encoding used by the exporting application.
  • The import command is unavailable: Check that you are editing the file in Excel for the web rather than a preview-only view. If the command is still absent, use the desktop Excel app or ask your Microsoft 365 administrator whether the feature is available for your account.

When troubleshooting, preserve the original CSV and test on a copy of the workbook. If a change to a worksheet causes trouble, Ctrl+Z undoes many recent edits in Excel for the web on Windows; Command+Z is the usual equivalent on Mac. Undo is not a substitute for keeping the source file, particularly after saving or closing the workbook.

Refreshes, repeat imports, and workbook sharing

If the CSV is a one-time export, importing it once is usually sufficient. If the source file is replaced regularly, find out whether your import created a query that can be refreshed in your Excel web environment. Power Query and refresh capabilities in Excel for the web depend on the data source and the features enabled for the account. A local file import should not be assumed to update automatically when a new CSV with the same name appears on your computer. For a recurring process, test what Refresh does and confirm that it points to the intended source.

When a workbook is stored in OneDrive or SharePoint, people with access may be able to see both the imported data and any additional worksheets you keep in it. Check sharing permissions before sending a link, especially if the CSV contains customer, employee, or business information. If you share only a CSV copy, remember it carries one flat table of values, not the workbook’s extra sheets or formatting.

When to use Excel desktop instead

Excel for the web is useful for straightforward imports and collaborative work, but desktop Excel for Microsoft 365 on Windows may offer a more complete set of Power Query and file-import controls. In the desktop app, a common route is Data > Get Data > From File > From Text/CSV. The preview lets you inspect the file and, where available, transform it before loading. Excel for Mac has its own interface and feature availability can differ by release; do not assume every Windows command or dialog appears in the same place on Mac.

Consider desktop Excel when the web version does not expose the import options you need, when you must repeatedly combine or clean files, or when the file’s encoding and column types require more deliberate handling. If you work in a browser because you do not have desktop Excel, a text editor can help confirm whether the file actually contains commas, semicolons, or unusual characters, but avoid editing the only copy of the source. For a large or complicated dataset, a database or a dedicated data-cleaning tool may be more suitable than a worksheet.

CSV safety and trustworthy data

A CSV file is not inherently safe just because it is plain text. Files from unknown sources can contain misleading content, and spreadsheet applications may interpret some entries beginning with characters such as an equals sign as formulas, depending on how the file is opened or imported. Treat unexpected formula-like cells as untrusted. If you only need to read the data, inspect the source and use an import option that treats the relevant columns as text where possible. Do not rely on the file extension alone to establish that its contents are harmless.

Also verify the file’s origin and avoid uploading confidential data to a personal cloud account when your organization requires approved storage. CSV does not support VBA macros, but that does not eliminate risks from deceptive links, formula-like content, or accidental disclosure. For business data, follow your organization’s policies for storage, sharing, and retention.

Frequently Asked Questions

Can I import a CSV into an existing Excel Online workbook?
Yes. If available in your account, use Data > Get Data > Text/CSV, review the preview, and load the results. If that command is not available, open the CSV separately or use desktop Excel, then copy or import the data into the workbook.

Can Excel Online open a CSV directly?
Yes. You can upload or locate the file in OneDrive or SharePoint and open it in Excel for the web. Direct opening is convenient, while an explicit import gives you more opportunity to check delimiters and data types before loading.

Why does my CSV open in one column?
Excel may have detected the wrong delimiter, or the file may use a semicolon or another separator instead of a comma. Use the Text/CSV import preview, select the separator used by the source, and check whether the rows follow a consistent structure.

How do I stop Excel from removing zeros at the start?
Set the relevant column to Text during import if the interface allows it. This is important for codes and identifiers such as 00128, which should not be treated as quantities. If Excel already removed the zeros, reimport the unchanged source file as text.

Will an imported CSV keep formulas and formatting?
No. CSV is a plain-text format for tabular values and does not preserve workbook formatting, multiple sheets, or Excel formulas as working formulas. Save the result as an .xlsx workbook if you need to keep Excel features beyond the flat CSV data.

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.