Excel Import CSV Into a New Tab: Steps, Tips, and Fixes

To import a CSV file into a new tab in Excel for Microsoft 365 on Windows, select Data > Get Data > From File > From Text/CSV, choose the file, then select Load or open its menu and choose Load To…. In the import options, select Table and New worksheet, then confirm. Excel places the imported data on a separate worksheet in the current workbook.

What “import into a new tab” means

A CSV, or comma-separated values file, stores rows of text separated by delimiters, usually commas. Unlike an Excel workbook, a CSV does not contain worksheets, formulas, formatting, or workbook features. Importing it into a new tab means bringing its rows into an .xlsx or .xlsm workbook on a worksheet separate from the sheets already there.

The distinction matters because a CSV opened directly may appear as a spreadsheet, but the file itself still has no tabs. Excel can display and edit its contents, but saving changes as CSV keeps the file in CSV format and does not preserve other workbook sheets. Importing the CSV into an existing workbook is the better choice when you want to keep the source data alongside formulas, charts, or other worksheets.

For example, a workbook might have a Summary tab and a Monthly Data tab. Importing a file called April.csv as a new worksheet lets you keep both existing tabs and add the April rows separately. You can then rename the resulting worksheet to April or another useful label.

Import a CSV as a new worksheet

Open the Excel workbook that should receive the data. If you want to start a new workbook, create one first.
On the ribbon, select Data > Get Data > From File > From Text/CSV.
Browse to the CSV file, select it, and choose Import. Excel displays a preview of the file.
Check the preview, particularly the column divisions and the displayed character encoding. If it looks right, choose Load to accept Excel’s default load behavior.
To specify the destination, use the arrow beside Load and select Load To…. In the Import Data options, select Table and New worksheet, then select OK.

Excel adds a worksheet containing the imported table. The worksheet may have a default name; double-click its tab to give it a clearer name. If you use Load without opening Load To…, Excel will generally load the query result onto a new worksheet, but choosing the destination explicitly is the surest way to meet the new-tab requirement.

Check the preview and import settings

The preview is an opportunity to catch problems before data lands in the workbook. CSV files can use different delimiters and text encodings, and Excel may not always infer the intended settings from the file. If a file uses semicolons between fields, for instance, a comma-based preview may show each row as one long column. Set the delimiter in the preview to match the file rather than splitting the text later by hand.

Also look at the data type shown for columns. Excel may interpret values such as dates, numbers with leading zeros, or long identification codes as dates or numbers. Codes like 00421 can lose their first zeros if treated as numeric values. If preserving the exact characters matters, use Transform Data to inspect or change the column type before loading. A text type is often appropriate for identifiers, postal codes, and account-like codes, even when they contain only digits.

For files containing accented letters or other non-English characters, check that the preview displays them correctly. The file’s encoding affects how those characters appear. If names appear as garbled symbols, change the file origin or encoding option in the import preview if available, then confirm the preview before loading.

Choose between Load and Transform Data

Load is convenient when the preview already shows the fields and values correctly. Excel imports the data as a table, which makes it straightforward to filter, sort, and use structured references. This is suitable for a simple one-time import or a source file that is already clean.

Transform Data opens the Power Query Editor. Use it when you need to fix the source before it enters the worksheet—for example, to remove blank rows, promote the first row to headers, change data types, split a combined column, or filter out unwanted records. After making changes, choose Close & Load to load the result. If you need to pick the destination, use the Close & Load menu and choose Close & Load To…, then select a table and a new worksheet.

Power Query records the import and transformation steps as a query. If the CSV is replaced or updated later at the same source location, you can refresh the query instead of repeating each cleanup step. This is useful for recurring reports, but it also means the query’s source path and transformation settings matter. If a file is moved or renamed, Excel may be unable to refresh until the source is updated.

Importing by opening or copying a CSV

A second approach is to open the CSV in Excel, then copy its worksheet into the destination workbook. This can be useful when you already opened the file or want a quick, manual transfer. With both workbooks open, right-click the CSV sheet tab, choose Move or Copy…, select the destination workbook, check Create a copy if you want to retain the source sheet, and confirm. The copied sheet becomes a new tab in the destination workbook.

This route is not identical to importing through Power Query. Opening a CSV relies more heavily on Excel’s automatic interpretation, and the source file itself remains a CSV with no worksheet structure to preserve. A copied sheet in the destination workbook can retain worksheet-level formatting, but it does not create a refreshable query connection to the original CSV. Choose the Power Query route when repeatable imports or deliberate type handling matter; use copying for a simple one-off transfer.

Another quick option is to copy the visible CSV data and paste it into a new worksheet. This is easy, but it can bring along unwanted formatting or leave you with a static copy that is disconnected from the file. Before relying on pasted results, check that all rows and columns were included and that text values were not reinterpreted during opening or pasting.

Common problems and practical fixes

Everything appears in one column: The delimiter may not match the file. Reopen the import preview and choose the delimiter used by the CSV, such as comma, semicolon, or tab.
Leading zeros disappear: Excel likely converted an identifier to a number. Import or transform that column as text so values such as 00421 remain intact.
Dates look different: Excel may recognize date strings according to regional settings. Check the preview and set the column’s type deliberately in Power Query when the source format is ambiguous.
Special characters look wrong: Check the encoding or file origin in the import preview. Do not assume the CSV’s text is damaged until you have checked how Excel is reading it.
The new tab is in the wrong workbook: Confirm that the intended destination workbook was active before starting the import. For a query, use Load To… to choose the destination and placement.
The file has more data than expected: Check the source for blank lines, extra delimiters, or quoted fields containing commas. A comma inside a properly quoted field is part of that field, not necessarily a column break.

CSV files also have limits compared with workbooks. They do not store multiple tabs, cell formatting, formulas as formulas, or Excel tables. If you save an imported workbook as CSV, Excel may warn that some workbook features are not compatible. Keep the workbook in .xlsx format when you need multiple sheets or Excel-specific features, and retain the original CSV if you need an unchanged copy of the source.

Excel for Mac and Excel for the web

On Excel for Mac, import options and ribbon layouts can differ from Windows, and Power Query capabilities depend on the Excel version and available features. If your version offers a text/CSV import through the Data tab, use the preview and destination controls available there. If you do not see the same Load To… choices, opening the CSV and copying its sheet into the target workbook is a practical manual alternative. Avoid assuming a Windows menu path or shortcut will be identical on Mac.

Excel for the web can open and edit workbooks, but its data-import and Power Query options do not always match desktop Excel. For a reliable import with control over delimiters, data types, and the destination worksheet, use Excel for Microsoft 365 on Windows or a desktop version with the required import features. You can then save the workbook to OneDrive or SharePoint and continue working with it in a browser.

Save the result in the right format

After importing, save the destination as an Excel workbook, usually .xlsx, if you want to keep the new tab together with existing worksheets. Use File > Save As or File > Save a Copy, depending on the workbook’s location and Excel’s available options, and select the Excel workbook format when choosing a file type.

If you choose CSV as the output format, Excel saves only the active worksheet’s data in a text-based CSV file; it cannot preserve the other tabs as part of that file. A warning about unsupported features is a reminder of this format limitation, not evidence that the import failed. Keep an .xlsx copy for the multi-sheet workbook, and export a particular sheet as CSV only when another application specifically needs a CSV file.

Frequently Asked Questions

How do I import a CSV into a new sheet without replacing existing tabs?
Start from the workbook you want to keep, choose Data > Get Data > From File > From Text/CSV, then use Load To… and select New worksheet. This adds a tab rather than replacing the workbook.

Does Excel automatically put an imported CSV on a new tab?
In many cases, choosing Load creates a new worksheet by default. To avoid relying on the default, use Load To… and explicitly select New worksheet.

Can I import a CSV into an existing worksheet instead?
Yes. In the Import Data options, choose Existing worksheet and specify the destination cell. Check that the selected area will not overwrite data you want to keep.

Why did Excel put my CSV data in one column?
The delimiter Excel selected may not match the file’s separator. Open the import preview and choose the correct delimiter. Also check whether the file uses quoted fields or a regional separator such as a semicolon.

Will the new worksheet update when the CSV changes?
If you imported through Power Query, the worksheet is linked to a query that can often be refreshed. A copied or pasted sheet is just a manual copy and will not update from the source file automatically.

Can a CSV file itself contain multiple tabs?
No. CSV is a plain-text format for tabular data and does not store multiple worksheets. To keep several tabs, save the destination as an Excel workbook such as .xlsx.

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.