To import a CSV into Excel for the web, open a workbook and choose Data > Get Data > Text/CSV if that command is available in your account; select the file, check the delimiter and preview, then load the data. For a quick one-time opening, upload the CSV to OneDrive or SharePoint and open it in Excel for the web. Check the columns after import: a CSV stores plain text values, not Excel formatting or multiple worksheets, and Excel may interpret dates and numbers according to regional settings.
What importing a CSV means
CSV stands for comma-separated values. It is a plain-text format that represents a table as rows and fields, with a separator—often a comma—between fields. A CSV can be viewed in a text editor, but it does not contain the workbook features people associate with an Excel file, such as cell colors, formulas, charts, or multiple sheets. It may have a different delimiter, such as a semicolon, depending on how the file was created.
That distinction explains why opening and importing are not quite the same thing. Opening a CSV is convenient when you simply want to inspect or edit its contents. Importing it into an existing workbook gives you a way to choose how the text is interpreted and where the resulting table goes. If the file contains identifiers, international dates, or values with leading zeros, the import choices can prevent mistakes that are harder to spot after the data has been loaded.
Open a CSV from OneDrive or SharePoint
For a quick start, put the CSV in OneDrive or a SharePoint document library that you can access, then open the file in a browser. Depending on the location and interface, you can select the file from OneDrive or SharePoint and choose to open it in Excel. Excel for the web displays the contents as a worksheet so you can review, sort, and edit the rows.
Keep the original file in mind: a CSV cannot preserve workbook-only features. If you need to retain a working copy with formatting, formulas, multiple sheets, or data connections, save or copy the contents into an Excel workbook in .xlsx format. The exact save or download options can vary by account and where the file is stored, so check the File menu before replacing or renaming the source.
- Use this route to look at a CSV quickly or make straightforward edits.
- Use an .xlsx workbook when the result needs more than one sheet, formulas, formatting, or a reusable import process.
- Keep an unchanged copy of the source file if the CSV is important or difficult to recreate.
Import a CSV into an existing workbook
When the goal is to bring CSV data into a workbook rather than simply open the file, look for the import command on the Data tab. In supported Excel for the web accounts, choose Data > Get Data > Text/CSV, select the CSV, and review the preview or import options shown. Choose the correct separator and check whether the first row should be treated as column headings, if that option is offered. Then load the data into the workbook.
The available commands can differ by account, update, and workbook context. If you do not see Text/CSV, first confirm that you are using Excel for the web and that the workbook is editable rather than open in a restricted viewing mode. You can try opening the CSV directly from OneDrive, or use Excel for Microsoft 365 on Windows, where the desktop import route is Data > From Text/CSV. The desktop app has additional import controls that may not appear in every web environment.
Before loading a large file, scan the preview for obvious issues: headers split across columns, a whole row shown in one column, or dates displayed in an unexpected order. If the import experience offers a transform step, use it to choose data types or remove unwanted rows before loading. The precise options depend on the web feature currently available to your account.
Choose the right delimiter and text handling
A delimiter marks where one field ends and the next begins. Commas are common, but some CSV files use semicolons or tabs. If Excel places an entire record in one column, the most likely cause is that the selected delimiter does not match the file. If it splits a value in the wrong place, check whether the file uses another separator or whether its text fields are quoted.
CSV conventions allow a field containing a comma to be surrounded by quotation marks. For example, a row might contain a company name such as North, South & West as one field when it is enclosed correctly in quotes. A compatible CSV reader recognizes the comma inside the quoted field as part of the text, not as a column break. Do not remove quotation marks blindly in a text editor: they may be needed to keep the row structure intact.
- If every row appears in one column, check for a semicolon or tab delimiter instead of a comma.
- If fields shift into the wrong columns, inspect the source file for inconsistent separators or broken quotation marks.
- If a file comes from another country or system, confirm its delimiter and number conventions rather than assuming they match your computer’s region.
Protect dates, numbers, and leading zeros
Excel tries to recognize values when it reads text. That is helpful for ordinary dates and quantities, but it can alter values that are meant to remain identifiers. A product code such as 004271 may be interpreted as the number 4271, which drops its leading zeros. A long account or tracking number may be displayed in scientific notation or lose precision if handled as a number. Postal codes and ID fields are usually better treated as text, even when they contain only digits.
Dates are another common source of confusion. A value such as 03/04/2025 could mean March 4 or April 3, depending on the date convention used by the file and the settings applied during import. If the import interface lets you set a column’s data type, choose deliberately for ambiguous dates and identifiers. When the web import does not expose enough control, import the file in the desktop version or correct the source format before using it.
Do not judge a value only by how it looks in one cell. Select a few examples and check the formula bar or cell formatting, and compare them with the original source. For sensitive records, validate totals, row counts, and a sample of IDs after importing. Converting a damaged number back to text cannot restore digits that Excel has already discarded.
Save the result in the right format
A CSV has no place to store formulas as live Excel formulas, cell formatting, multiple tabs, or Power Query settings. If you edit a CSV in Excel and keep it as CSV, the saved file remains a plain-text table. In particular, formatting applied in the worksheet does not become part of the CSV, and only the data from one sheet can be represented in that format.
For a reusable workbook, keep the imported data in an .xlsx file. That format can retain sheets, formatting, formulas, and other workbook content. If the task is to send a clean data extract to another system, CSV may still be the right output, but check which sheet and delimiter the receiving system expects. An Excel workbook and a CSV are not interchangeable simply because both can show rows and columns.
When the CSV is opened from cloud storage, be clear about which file you are editing and what format will be saved. A copy in .xlsx is safer when you want to preserve a source CSV unchanged and continue working with Excel features. For a shared workbook, check that collaborators have permission to edit it and understand whether they are working in the CSV or the workbook copy.
Common import problems and fixes
Most problems come from a mismatch between how the file is structured and how Excel reads it, rather than from a broken workbook. Start with the preview and compare the first few records with the original file. These checks often reveal the cause before you spend time repairing every row.
- Everything is in one column: Try the delimiter used by the file, such as semicolon or tab. If you only opened the CSV, use the import route when you need to specify a separator.
- Leading zeros disappeared: The values were interpreted as numbers. Reimport the original file and treat the affected field as text if the available import controls allow it.
- Dates are reversed or unexpected: Check whether the source uses month/day/year or day/month/year, and confirm the regional interpretation used during import.
- Special characters look wrong: The file may use a text encoding Excel did not interpret as expected. If the web interface does not offer an encoding choice, try importing with Excel for Windows and select the appropriate file origin or encoding in its import controls.
- Rows or columns appear missing: Check the source file for blank lines, inconsistent delimiters, or fields containing unescaped quotation marks. Compare the imported row count with the source.
- The command is unavailable: The web feature may not be offered in that account or workbook state. Open the CSV from cloud storage or use the desktop app’s Data > From Text/CSV command.
When to use Excel for the web, desktop Excel, or another tool
Excel for the web is useful when you need to open a cloud-stored CSV, inspect data, make straightforward changes, or collaborate in a browser. Its import features can be enough for routine files, but the available transformation controls may be narrower than those in the desktop app. Desktop Excel for Microsoft 365 on Windows is a better choice when you need more control over encoding, column types, delimiters, or repeatable Power Query steps. On a Mac, menu names and import options can differ; check the Data tab in the installed version rather than assuming the Windows path is identical.
A text editor can help diagnose a small file by showing the actual separators and quotation marks, but it is not a substitute for a spreadsheet when you need to analyze rows. For automated or very large data pipelines, a database or a dedicated data-processing tool may be more appropriate. Choose based on what must happen to the data: a one-off viewing task needs less setup than a recurring process that must preserve IDs and interpret dates consistently.
Frequently Asked Questions
Can Excel for the web open a CSV file?
Yes. You can open a CSV stored in OneDrive or SharePoint in Excel for the web. It appears as a worksheet, but the CSV itself does not hold workbook features such as multiple sheets or formatting.
Where is the CSV import option in Excel for the web?
In supported accounts, open a workbook and look on the Data tab for Get Data > Text/CSV. If the command is not present, open the CSV from cloud storage or use desktop Excel for the import.
Why does my CSV open in one column?
Excel may be using a different separator from the one in the file. Check whether the file uses commas, semicolons, or tabs, then select the matching delimiter in the import options if available.
How do I stop Excel from removing zeros at the start of a code?
Import that column as text when the import controls allow it. If Excel has already removed zeros, reopen the original CSV and import again; changing the displayed number format may not restore the original code reliably.
Will a CSV keep my Excel formatting and formulas?
No. CSV stores plain-text tabular data, not cell formatting, live formulas, charts, or multiple worksheets. Save a separate .xlsx workbook if you need those features.
A practical final check
Before relying on imported data, compare the number of rows and columns with the source, verify several dates and identifiers, and check a few totals or known values. Confirm that text has not shifted into neighboring columns and that important leading zeros remain. Save a working version as an Excel workbook when you need workbook features, and retain the original CSV when you need an untouched record of the source. These simple checks make the difference between a file that merely looks right and data that is ready to use.
Related
- Excel Text to Columns and Rows: How to Split Data
- Excel Text to Columns: How to Make Results Vertical
- Excel Table Structured References: Rules, Examples & Tips
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Text Wrap Not Working in Word? Fix Image Text FlowIf text will not wrap around a picture in Word, select the picture and choose Picture Format >…
- Hyperlink Not Working in Word? Fixes to TryIf a hyperlink in Word is not working, first try Ctrl+clicking it on Windows; Word often requires that…
- Excel Keyboard Shortcuts Not Working? Fixes That HelpIf Excel keyboard shortcuts stop working, first click a worksheet cell, exit cell-edit or dialog mode, confirm you…
- Excel Spill Error: Why It Appears and How to Fix ItExcel’s #SPILL! error means a formula is trying to return results into multiple cells, but Excel cannot place…
- Outlook Signature Hyperlink Not Working? Fixes That HelpIf an Outlook signature hyperlink is not working, first check whether the message is being composed in HTML,…
- Excel VLOOKUP Spill Error: Causes and FixesA VLOOKUP spill error usually means Excel cannot place all the results a formula is trying to return…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.