Excel Online Import CSV: Steps and Common Fixes

How-to basics · Updated November 18, 2026

To import a CSV into Excel Online, upload the file to OneDrive and open it with Excel for the web. For more control over separators or data types, use the Text/CSV import option if it appears under the Data tab; otherwise, open the file in desktop Excel and use its import wizard.

Open a CSV in Excel for the web

Excel Online is now commonly called Excel for the web. The simplest way to open a CSV is to store it in OneDrive first. A CSV is a plain-text file that stores values in rows, with a separator such as a comma between fields. Opening it in Excel displays those values in a spreadsheet grid, but does not turn the original text file into a fully featured Excel workbook by itself.

  1. Go to OneDrive in your browser and sign in to the account where you want the file stored.
  2. Choose Upload, then Files, and select the CSV from your computer. The exact label or placement can differ slightly as Microsoft updates its interface.
  3. When the upload finishes, select the CSV in OneDrive to open it in Excel for the web.
  4. Check that the fields appear in separate columns and that values such as dates, product codes, and amounts look right before editing.

If you are already on the Excel for the web start page, use its upload or open option to choose a file, if available. Uploading through OneDrive is a useful default because the file is then stored in your account and can be reopened from there. If a CSV opens as a download or as text in the browser instead, return to OneDrive and select the uploaded file rather than opening a local browser preview.

Opening a CSV versus importing its data

People often use import and open to mean the same thing, but Excel can handle a CSV in more than one way. Opening the file directly is quick: Excel reads the text and displays it in cells. That is convenient when the file is simple and the columns are already separated correctly. It may also interpret values automatically, which can change how codes, dates, or numbers appear.

An import workflow gives you a chance to inspect or adjust how the text is parsed before it becomes worksheet data. In Excel for the web, check the Data tab for a Get Data or Text/CSV option. Availability and the available settings can depend on your account, organization, and the current web interface. If the option is present, follow its prompts to choose the file and review the preview. If it is not present, you can open the CSV directly or use desktop Excel, whose text import tools offer more control.

For a CSV downloaded from a reporting system, importing can be especially helpful when the file contains identifiers such as ZIP codes or customer numbers. A preview or query step can let you specify that a field is text rather than a number. If Excel has already removed leading zeros, changing the displayed cell format afterward may not restore them: the original value may already have been converted. Reopen or reimport the original CSV with the appropriate type instead.

Separators, regional settings, and column layout

CSV means comma-separated values, but not every file that ends in .csv uses a comma as its field separator. Some systems use semicolons, tabs, or another delimiter because commas are used as decimal marks in their regional format. A correctly formatted CSV can also contain commas inside a field, such as an address, as long as that field is enclosed in quotation marks. A parser that does not recognize the delimiter or quoting rules may put an entire row in one column or split a value in the wrong place.

If everything appears in column A, first check whether the file is genuinely comma-delimited. Open a copy in a plain-text editor and inspect a line: commas, semicolons, or tabs between values can reveal the separator. Do not edit and resave the only original in a text editor unless you understand how it handles encoding and quoting. If Excel for the web offers a delimiter choice in its import preview, select the separator shown by the file. If it does not, desktop Excel is often the practical alternative for a file that needs custom parsing.

Regional settings can also affect how Excel recognizes decimal and date values. For example, a value written as 1,25 may mean one and a quarter in one locale, while a different locale may treat the comma as a separator. If numbers or dates are interpreted unexpectedly, compare the original text with the displayed cells and check the regional conventions used by the system that created the export. Do not assume that changing a cell’s display format will correct a value that was parsed incorrectly.

Protect dates, codes, and other data types

CSV files do not store Excel cell formats or explicit type information. They contain text, and the application opening the file decides whether entries look like numbers, dates, or text. That automatic interpretation is convenient for ordinary tables, but it can be risky for data where the exact characters matter. An employee ID such as 000742 may become 742, and a value resembling a date may be converted to a date serial or displayed in a different regional format.

Before relying on an imported file, inspect columns that commonly need special handling:

  • Identifiers: account numbers, postal codes, barcodes, and codes with leading zeros should usually remain text.
  • Dates: check ambiguous values such as 03/04/2026 against the source system’s date convention.
  • Decimals and currency: confirm that decimal marks, thousands separators, and negative values have been read as intended.
  • Long numbers: very long digit strings may not be safe to treat as ordinary numeric values, especially when they are identifiers rather than quantities.

For important data, compare a few representative rows with the original export before sorting, filtering, or sharing the result. If precision or leading zeros matter, reimport the source while setting those columns to text in an import workflow that supports data-type selection. Keep an untouched copy of the CSV so you can start again if automatic conversion changes the source values.

What Excel for the web keeps—and what CSV cannot keep

A CSV contains one table of plain-text values. It does not preserve multiple worksheets, formulas as working formulas, cell colors, column widths, charts, filters, or other workbook features. If a CSV contains text that begins with an equals sign, it is still text in the source file, although spreadsheet software may interpret some entries when opening them. Treat unfamiliar CSV files cautiously rather than assuming every field is harmless data.

After opening a CSV, keep the distinction between the source format and a workbook format in mind. If you add formatting, multiple sheets, formulas, or other Excel features, save a working copy as an Excel workbook (.xlsx) when that option is available. Excel for the web stores supported workbook changes in OneDrive, but available save and download choices can vary with how the file was opened and the account in use. If you need a particular file format, check the options under File rather than assuming that a CSV can retain workbook features.

Preserve the original CSV if another person or system expects a plain-text export. Saving a spreadsheet as CSV generally keeps only the active sheet’s values and discards workbook features. It is therefore sensible to keep separate files: the untouched source CSV for data exchange and an .xlsx working copy for analysis or presentation.

Common problems and practical fixes

  • All data is in one column: the separator may not be a comma, or the direct-open parser may not have recognized it. Check the file’s actual separator and use an import preview or desktop Excel if you need to specify it.
  • Accented characters look wrong: the file may use an encoding Excel did not interpret as expected. Ask the system that created the export for UTF-8, or import it with an encoding choice in a tool that exposes one. Do not try to repair garbled text by changing fonts; encoding and fonts are different issues.
  • Leading zeros disappeared: Excel likely interpreted the field as numeric. Reopen the original and import that column as text where possible. Applying a text format after the zeros are gone cannot infer which zeros belonged there.
  • Dates changed format: the underlying date may be valid but displayed using a different regional convention, or the text may have been interpreted as the wrong date. Compare against the original and confirm the source’s date order.
  • Some rows appear shifted: inspect fields containing commas, quotation marks, or line breaks. CSV quoting rules determine whether those characters belong inside a field; a malformed export may need correction at its source.
  • The file will not open or upload: check that it is a valid CSV rather than a renamed file, that your OneDrive account has available storage, and that your connection is working. For unusually large files or complex parsing needs, desktop Excel may be more suitable.

When troubleshooting, work from a fresh copy of the original rather than repeatedly editing a damaged import. That makes it easier to tell whether a problem came from the source file, the parsing settings, or later spreadsheet edits.

When to use desktop Excel or another option

Excel for the web is convenient for viewing, making ordinary edits, and collaborating on a file stored in OneDrive. Desktop Excel is a better choice when the web version does not offer the import controls you need, the file requires custom delimiter or encoding choices, or you need to inspect more advanced text-import settings. On Windows, desktop Excel commonly provides a text or CSV import route from the Data tab; the exact commands can vary by version. Excel for Mac also has import capabilities, though labels and dialog layouts can differ.

A plain-text editor can help diagnose a CSV because it shows the characters and separators directly, but it is not a spreadsheet importer. Avoid using it to resave a file unless you know its encoding and line-ending behavior. If the CSV comes from a database, accounting service, or other application, exporting again with the correct delimiter, UTF-8 encoding, and column choices is often cleaner than trying to repair a broken export in Excel.

Frequently Asked Questions

Can Excel Online open a CSV file?
Yes. Upload the CSV to OneDrive and select it to open it in Excel for the web. Excel displays the file as rows and columns, subject to how it interprets the separator and values.

How do I import a CSV into Excel Online instead of opening it?
Look on the Data tab for a Get Data or Text/CSV import option. If it is available, use its prompts and preview to choose how to parse the file. If it is not available in your version or account, use direct opening or desktop Excel.

Why does my CSV open in one column?
Excel may not have recognized the delimiter. Check whether the file uses commas, semicolons, or tabs, then use an import option that lets you choose the correct separator if available.

How can I stop Excel from removing leading zeros?
Import the relevant column as text, if the import controls allow it. If the zeros have already disappeared, reopen the original CSV and import it again; formatting the converted number as text will not restore the missing characters.

Will formatting and multiple sheets stay in a CSV?
No. CSV stores plain-text values for a single table, not workbook formatting or multiple worksheets. Save a separate .xlsx copy if you need to retain Excel features.

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.