Yes. In Excel for Microsoft 365 on Windows, import the CSV to a staging worksheet with Data > From Text/CSV, check the columns, and copy its data rows into the first blank row of your existing Excel table. The table will usually expand to include the new rows; check the table boundary and formulas afterward.
What importing into an existing table means
A CSV file contains rows and columns of plain text values, separated by a delimiter such as a comma. It does not preserve Excel features such as table formatting, filters, formulas, or column types. An Excel table, by contrast, is a structured range with a header row and behaviors such as automatic expansion and filter buttons. Importing a CSV into an existing table therefore means bringing in the CSV’s values and adding them to the table—not merging two files while preserving CSV formatting.
The safest general approach is to import the CSV separately first, inspect it, and then append its records to the table. This gives you a chance to catch a shifted column, an incorrectly interpreted date, or an unexpected header before it affects your working data. It also avoids replacing the table or its existing records by mistake.
Recommended method: import to a staging worksheet
- Open the workbook that contains the existing table. If the incoming file is important, save a copy of the workbook before changing its data.
- On the ribbon, select Data > From Text/CSV. Browse to the CSV file and select Import.
- Review the preview. Confirm that the delimiter splits the values into the intended columns and that the first row is treated as headers if it contains column names.
- Select Load to bring the data into Excel. Excel generally loads the imported data to a new worksheet. Keep that worksheet as a temporary staging area while you check the results.
- Compare the CSV’s column order and meaning with the existing table. Select and copy only the incoming data rows, not the header row.
- Return to the table and paste into the first blank row immediately below its last data row. If the table has a different column order, arrange the staged columns to match before pasting.
- Confirm that the table includes the added records. Check the final row, filters, calculated columns, and any totals or summaries that depend on the table.
For a small, straightforward file, you can also open the CSV in Excel, copy its data rows, and paste them into the table. The import route is more useful when you need to check delimiters, encoding, or data types before adding the rows.
Prepare the table and CSV before pasting
Check the table’s headers before importing. They should describe the same fields as the CSV, such as Order ID, Date, Customer, and Amount. The CSV does not have to use identical header wording if you are copying values by position, but the column order must match the destination. If the CSV lists Amount before Customer while the table has Customer before Amount, pasting without rearranging the columns can put valid-looking values under the wrong headings.
Also check whether the CSV includes a header row. When it does, copy the records beneath that row rather than copying the headers into the table. A second header line becomes an ordinary data record and can interfere with sorting, filtering, and formulas. If the CSV has no headers, compare its documented field order with the table before proceeding.
- Confirm that the number of incoming fields matches the table’s input columns.
- Look for blank rows, totals, notes, or report titles in the CSV that are not actual records.
- Check whether the table contains formula columns that should be calculated by Excel rather than supplied by the CSV.
- Keep a backup when the table is used for reporting, reconciliation, or another important process.
Paste the records so the table expands
Click the first cell below the table in the column where the incoming records should begin, then paste the copied data. If the pasted range touches the table’s bottom edge and its columns line up, Excel normally extends the table to include the new rows. You can verify this by selecting a pasted cell and checking whether the Table Design tab appears, or by seeing whether the table’s formatting and filter behavior cover the new records.
If Excel does not extend the table, select the table and use Table Design > Resize Table to include the additional rows. The tab appears when a cell in the table is selected. You can also add a row by clicking the last cell in the last table row and pressing Tab, then paste or enter the new values into the added row. Avoid pasting over the header or existing records unless replacing them is intentional.
When pasting a whole-width block, take care with calculated columns. If a table column contains formulas, copying every CSV field across that column can replace the formulas with imported values or blanks. Paste only into the columns that should receive source data. Excel often fills a calculated-column formula into new table rows automatically, but inspect the first and last added rows to confirm that behavior.
Preserve dates, IDs, and other data types
CSV values are text in the file, even when they look like numbers or dates. Excel may interpret them during import according to the preview’s type detection and your regional settings. A date written as 04/05/2026, for example, can mean April 5 or May 4 depending on the date convention being used. Confirm the intended interpretation before appending the records.
Identifiers are another common source of trouble. A postal code such as 00421, an account number, or a product code may need to remain text. If Excel treats it as a number, leading zeros can disappear. Long numeric-looking IDs can also be displayed in scientific notation or lose precision if treated as numeric values. During import, inspect the affected column and, when appropriate, set it to Text in the import or transformation workflow before copying it into the table.
For values that should be numbers, check that decimal and thousands separators are interpreted correctly. A CSV generated in one regional format may use a decimal comma, while another system expects a decimal point. If the imported values land in one column instead of several, revisit the delimiter selection; if they land in separate but incorrect columns, check the file’s actual separator rather than assuming it uses commas.
When Power Query is a better choice
For recurring imports, Power Query can make the preparation process repeatable. In Excel for Microsoft 365 on Windows, use Data > From Text/CSV and choose Transform Data to open the Power Query Editor. There you can remove unwanted rows, promote a header row, reorder columns, and set data types before loading the result. When the same kind of CSV arrives regularly, a saved query can reduce repetitive cleanup.
Power Query is especially useful when several files need the same transformations or when the incoming file has inconsistent extra rows. However, loading a query result is not automatically the same as appending it to an unrelated existing Excel table. A query loaded to a worksheet has its own output range, and refreshing that output does not necessarily add records to a separate manually maintained table. For an uncomplicated one-time addition, staging the import and pasting the records is often clearer.
If you need a refreshable process that combines existing records and new CSV records, design the query to combine the sources and load the combined result to an appropriate destination. Make sure there is one clear owner of that output: manually editing a query’s loaded results is not a reliable way to add permanent records, because a refresh can replace the output with the query result.
Common problems and how to fix them
- The CSV appears in one column: Import it with Data > From Text/CSV and select the delimiter that matches the file. A semicolon-delimited file will not split correctly if Excel is told to use commas.
- Values are under the wrong headers: Compare the CSV’s field order with the table’s column order. Rearrange the staging columns or copy them into the matching destination columns.
- Leading zeros disappear: Import identifier columns as text before pasting. Changing a number format afterward may display zeros, but it does not always restore the original identifier if digits were already lost.
- Dates change day and month: Check the import interpretation and regional date convention. If the source is ambiguous, confirm the source system’s format instead of guessing.
- The table does not include the pasted rows: Use Table Design > Resize Table, or paste directly beneath the table with matching columns and check that the range expands.
- Formulas are replaced or missing: Do not paste CSV fields over calculated columns. Add only the input fields and inspect whether Excel filled formulas into the new rows.
- Some records appear twice: A CSV import does not automatically identify duplicates. Decide which fields define a duplicate—such as a unique transaction ID—and check the combined data before relying on totals.
Windows, Mac, and Excel for the web
The steps above use Excel for Microsoft 365 on Windows. Excel for Mac also provides text and CSV import features, though the exact ribbon layout and dialog wording can differ by release. Look on the Data tab for the text/CSV import option, inspect the preview, and use a staging worksheet before copying the records into the table. Keyboard shortcuts and some import dialogs can vary between Mac and Windows, so the ribbon route is the clearest cross-platform instruction.
Excel for the web can open and edit workbooks containing tables, but import options and file-handling steps may differ from the desktop app. If the browser version does not offer the import controls you need, open the workbook in the Excel desktop app, perform the import there, and save it back to its storage location. In either version, check that the table itself—not merely nearby worksheet cells—contains the appended rows.
Frequently Asked Questions
Can I import a CSV directly into an existing Excel table?
For a straightforward one-time import, the dependable method is to import or open the CSV separately, then copy its data rows into the table. The CSV import command does not simply merge the file into any existing table while preserving that table’s structure.
Will Excel automatically expand my table when I paste new rows?
It normally expands when you paste a matching block directly below the table. Check the table boundary afterward. If the new rows are outside it, use Table Design > Resize Table to include them.
Should I copy the CSV header row?
No, not when the destination table already has its headers. Copy the records beneath the CSV header. Pasting the header into the table adds it as a data row rather than replacing the table’s field names.
How do I stop Excel removing zeros from CSV values?
Import the relevant column as text before copying it into the table. This matters for codes and IDs that look numeric but are not used in calculations. If Excel has already discarded digits, reimport from the original CSV.
Can I keep the import connected so new CSV files refresh automatically?
Yes, Power Query can save import and transformation steps for recurring work. But a query’s loaded output is not automatically a safe append mechanism for a separately maintained table. Plan how the query combines old and new records before relying on refreshes.
Related
- Insert Rows in Excel Multiple Times: A Step-by-Step Guide
- Unable to Unhide Rows in Excel? Try These Fixes
- How to Insert a Row in Excel Between Existing Data
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Table: How to Switch Rows and Columns EasilyTo switch an Excel table’s rows and columns, transpose its cell range: in Excel for Microsoft 365 on…
- Excel Data Validation Dynamic List: Setup and TipsTo make an Excel data-validation list update when its options change, put the options in an Excel Table,…
- Google Sheets IFS: How to Handle Blank CellsIn Google Sheets, handle a blank in IFS by testing for it before your other conditions; for example,…
- Excel Remove Duplicates: Does It Keep the First Row?Yes. In Microsoft Excel for Microsoft 365, Remove Duplicates keeps the first matching row in the current top-to-bottom…
- Excel Shortcut to Go to the Top of a Sheet ExplainedIn Excel for Microsoft 365 on Windows, press Ctrl+Home to go to the top-left of the worksheet, normally…
- Excel Quick Print Shortcut Key: What Actually WorksExcel for Microsoft 365 on Windows has no built-in keyboard shortcut that sends a worksheet straight to the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.