To import a CSV into Excel without leaving it as a formatted table, open the CSV directly with File > Open; Excel places the parsed data in ordinary worksheet cells. If you already imported it with Data > From Text/CSV, copy the results and use Home > Paste > Values in a new location, or convert the table to a range. The best method depends on whether you need a quick, static copy or want to refresh the data later.
Why a CSV import may become a table
A CSV (comma-separated values) file is plain text: it stores rows and fields separated by a delimiter, but it does not store Excel table styling, formulas, multiple worksheets, or most workbook features. Excel can display those imported fields in cells, but the method used to bring them in determines what Excel adds around the data.
In Microsoft 365 for Windows, Data > From Text/CSV uses Power Query. When you choose to load the results to a worksheet, Excel normally creates an Excel table. A table is still made up of worksheet cells, but it has a name, filter buttons, automatic formatting, and special behavior for formulas and added rows. That is useful for analysis, but it may not be what you want when another process expects a plain range.
Opening a CSV file directly is different: Excel parses the text into worksheet cells without creating a formatted table. The distinction matters because a CSV itself cannot tell Excel to create or avoid a table. It is Excel’s import route—not a setting inside the CSV—that controls the result.
Open the CSV as a plain worksheet range
For a one-time import, opening the file directly is usually the simplest option. In Excel for Microsoft 365 on Windows:
- Choose File > Open > Browse.
- Locate the CSV file. If it is not visible, change the file-type filter to include text or CSV files.
- Open it and check that the columns and characters appear correctly.
- To keep an editable Excel workbook, choose File > Save As and save a copy as an Excel Workbook (
.xlsx).
The CSV opens as a workbook-like view of the file, with the values in ordinary cells rather than an Excel table. Saving as .xlsx preserves the worksheet layout and lets you add formatting, formulas, or other sheets. Saving again as CSV instead keeps the file in text format and does not preserve most Excel-only features.
Opening the file directly is convenient, but it gives you less control over interpretation than the import preview. Excel may use your regional list separator and date settings, so a file made on another system may not split or display as expected. If columns, encoding, or data types need careful control, use the import route below and then create a plain-range copy.
Use Power Query, then make a static range
Power Query is a better choice when you need to inspect or clean the file before loading it. Choose Data > From Text/CSV, select the file, and review the preview. Check the delimiter and data types before loading. Use Transform Data if you need to adjust columns or types; choose Load when the preview is ready. The worksheet output is normally an Excel table.
If you need a plain range and do not need that output to refresh, create a static copy:
- Select the imported table’s data and copy it. Include the header row if you need the column names.
- Click the destination cell, either elsewhere in the workbook or in a new worksheet.
- Choose Home > Paste > Values. This pastes the displayed values rather than making another linked copy of the table.
- Check the result, then remove the original query table if you no longer need it.
You can also select a table and choose Table Design > Tools > Convert to Range, then confirm. This removes the table behavior while leaving its cell contents in place. However, a Power Query result is designed to load to a table. If you convert that output and need reliable future refreshes, do not assume the plain range will remain a supported query destination; keep the query table or test the refresh workflow on a copy first. A pasted-values copy is the clearer choice for a separate, non-refreshing range.
Choose the method that fits the job
There is no single best import path for every CSV. Consider what the finished worksheet must do:
- One-time data, no transformation: open the CSV directly, then save as
.xlsxif you need a workbook. - One-time data that needs cleanup: use Data > From Text/CSV, make the changes, then paste values into a separate range.
- Repeated imports from a changing file: use Power Query and keep its table output if refresh is important. A table makes the loaded result and its headers easier to manage.
- A plain range required by a downstream task: use a static copy or, on Windows where available, the legacy Text Import Wizard to import into a worksheet destination.
For example, if a colleague sends a weekly sales CSV and you only need this week’s figures for a report, direct opening is simple. If you receive the same export every week and must remove unwanted columns, standardize dates, and refresh the result, Power Query is more suitable. If the report template accepts only a plain cell range, copy the cleaned output as values into the template rather than treating the query table as a permanent plain-range connection.
Use the legacy Text Import Wizard when available
Some Windows installations of Excel for Microsoft 365 still provide the legacy Text Import Wizard. It offers a step-by-step way to specify whether a file is delimited or fixed-width, choose delimiters, and set column formats before placing the result in a worksheet. The wizard can be useful when you want more control over a one-time import into a chosen cell location without Power Query’s table output.
If the command is not visible, open File > Options > Data and look for the setting to show legacy data import wizards. After enabling the text wizard, look under Data > Get Data > Legacy Wizards > From Text (Legacy). Availability and wording can differ by Excel build. In the wizard, review the preview and column formats, then specify the worksheet destination when prompted. Confirm the result is split into the intended columns before saving.
This is a Windows desktop option, not a general instruction for Excel for the web. On Mac, available import tools and ribbon wording can differ; if you do not see the legacy wizard, open the CSV directly or use Power Query where supported, then make a values-only copy. Avoid relying on a menu path that is absent from your version.
Prevent common CSV import problems
A plain range does not guarantee that every value has been interpreted correctly. Review the data before using it, especially when the CSV comes from another region or contains identifiers.
- Columns stay together: the file may use a semicolon, tab, or another delimiter rather than a comma. In the Power Query preview, select the correct delimiter. If opening directly, the regional settings on the computer may affect how Excel splits the file.
- Leading zeros disappear: values such as product code
00427may be interpreted as numbers and shown as427. Import that column as text when the code must retain its zeros. Formatting the cells as text after zeros have been removed does not restore them; reimport the original text. - Dates change meaning:
04/05/2026can mean different dates in different date conventions. Check the source’s convention and choose an appropriate date type or keep the field as text until you confirm it. - Accented or unusual characters look wrong: the file’s text encoding may not match Excel’s assumption. Use the import preview and select the appropriate file origin or encoding when the option is available.
- Long numbers are altered: identifiers or very long numeric strings may be treated as numbers. Import them as text if every digit must remain exactly as supplied.
These issues come from interpreting the text, not from whether the destination is a table. Inspect sensitive columns before saving a final workbook. Once a value has been converted or truncated, changing the cell’s appearance may not recover the original text; returning to the source CSV and importing with the right type is safer.
What changes when you convert a table to a range
Converting a table to a range leaves the existing cell values in place, but it removes table-specific features such as the table name, filter buttons, automatic expansion, and structured references. Any table style may remain as ordinary cell formatting, so the cells can still look banded even though they are no longer a table. If you want to remove that appearance too, select the cells and use the applicable formatting commands separately.
Other workbook features can behave differently after conversion. Formulas that refer to a table by its structured column names may no longer work as intended if the table is removed. Filters and automatic formula fill-down are also table behaviors, not guarantees of an ordinary range. Before converting an existing table, consider whether formulas, charts, or other workbook elements depend on it. For a simple imported CSV with no such dependencies, a values-only copy is often the least disruptive way to produce plain cells.
Frequently Asked Questions
How do I stop Excel from importing a CSV as a table?
Open the CSV directly with File > Open for a plain worksheet result. If you need Power Query’s preview and cleanup tools, load the data, then paste its values into a separate range.
Can I turn an Excel table into a normal range?
Yes. Select a cell in the table and choose Table Design > Tools > Convert to Range, then confirm. The cell contents remain, but table features such as automatic expansion and structured references are removed.
Will converting a Power Query table to a range keep refresh working?
Do not count on the converted cells as a reliable plain-range query destination. Power Query normally loads worksheet results as a table. Keep that table for refreshes, or paste values into a separate range for a static copy.
Why does Excel put all my CSV data in one column?
The delimiter may not match what Excel expects. Check whether the file uses commas, semicolons, tabs, or another separator, and choose the correct one in the import preview. Regional settings can affect direct opening.
Can Excel keep leading zeros from a CSV?
Yes, if the relevant column is imported as text before Excel converts it to a number. Reimport from the original CSV if zeros have already disappeared; changing the cell format afterward cannot restore lost characters.
Save the result in the right format
Use .xlsx when you want to keep an Excel workbook with a plain range, formulas, formatting, or multiple worksheets. A CSV file is a text export of a single sheet’s data; it does not preserve table objects, workbook formulas as formulas, multiple tabs, or most formatting. If you save a workbook back to CSV, Excel may warn that some features are not compatible. Keep an .xlsx copy as your working file when those features matter, and export a CSV only when a receiving system specifically requires it.
Related
- Excel Goal Seek With Multiple Inputs: Use Solver
- Excel Goal Seek Precision: Accuracy and Limits
- Excel Goal Seek Tolerance: Set Precision and Check Results
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Insert Page Break Shortcut Key and How It WorksIn Excel for Microsoft 365 on Windows, press Alt+P, B, I to insert a page break: press the…
- How to Protect an Excel Sheet Without Locking EverythingTo protect an Excel sheet in Microsoft 365 for Windows, unlock any cells people should be able to…
- Excel Continually Not Responding? Causes and FixesIf Excel continually says “Not Responding,” first give it a few minutes if it may be calculating, saving,…
- Using IFs in Google Sheets: IF, IFS, and Examples ExplainedTo use an IF in Google Sheets, enter a condition followed by the value to return when it…
- Google Sheets Filter Shortcut: Keys and Quick TipsIn Google Sheets in a web browser, press Ctrl+Shift+L on Windows or ChromeOS, or ⌘+Shift+L on a Mac,…
- Google Docs Monthly Budget Template: Free Ways to StartYes, you can make a monthly budget for free with Google’s tools, but a budget with totals and…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.