How to Append Excel Data Without Duplicating Headers
Question details
The user needs to combine data from multiple Excel workbooks without importing the source table headers as regular data rows in the final dataset.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Appending data from one large workbook to another containing matching headers using the Get Data feature.
- Observed behavior
- Using standard import methods imports the source file's header as an unwanted data row within the combined table.
Ensure both source workbooks are saved and closed, and verify that the column headers in all tables match exactly in spelling and case to prevent misaligned columns.
Use Power Query to Append Tables
Power Query is the most reliable method for this task, as it automatically matches headers and combines rows while keeping only a single header row for the entire dataset.
By appending queries rather than manually pasting data, Power Query matches columns strictly by header name rather than their position. This avoids misaligned data and strips out redundant header rows.
Open your source workbooks and convert the data ranges into Excel Tables by pressing Ctrl + T.
In your main workbook, go to the Data tab, click Get Data > From File > From Workbook, and import your tables to create a connection.
Open the Power Query Editor. Go to the Home tab and select Append Queries (or Append Queries as New). Select the tables you want to combine.
Verify that the appended table contains only one header row. Click Close & Load to export the merged dataset back into your Excel worksheet.

Remove the Header Row Option Manually
Use this temporary workaround if you are manually importing an existing table and want to quickly remove the extra header row from the imported data.
Combine Workbooks Seamlessly in WPS Spreadsheet
WPS Spreadsheet provides powerful and intuitive data management tools. With built-in consolidation and intelligent table merging features, you can combine large datasets effortlessly without generating duplicate header rows.
- 1. Open WPS Spreadsheet: Launch WPS Office and open your primary workbook.
- 2. Access Data Consolidation: Navigate to the Data tab and click on the Consolidate tool.
- 3. Select Source Ranges: Click Add to select the data ranges from your target workbooks that you wish to combine.
- 4. Use Top Row Labels: Check the box for 'Top row' under 'Use labels in' to ensure headers are matched and merged perfectly without duplication.

Frequently Asked Questions
Why are my headers still duplicating after appending in Power Query?
This happens when header names are not an exact match. Power Query is case-sensitive, so 'Sales' and 'sales' are treated as two different columns. Ensure there are no trailing spaces or spelling differences in your source headers before appending.
Can I append more than two Excel tables at the same time?
Yes. When you click Append Queries on the Home tab of the Power Query Editor, you can select the 'Three or more tables' option. This allows you to add multiple tables from 'Available tables' to 'Tables to append' in one operation.
What happens if I append tables with columns in a different order?
Power Query appends data by matching the column header names, not their physical position in the worksheet. As long as the header names match exactly, the data will align perfectly under the correct column regardless of its original order.




