Excel Power Query Append Queries: Combine Tables Easily

How-to basics · Updated November 21, 2026

In Excel for Microsoft 365 on Windows, Power Query append queries combine tables by stacking their rows into one query result. In the Power Query Editor, choose Home > Append Queries to add rows to the selected query, or Home > Append Queries > Append Queries as New to create a separate result.

What an append query does

Appending is a way to bring records from two or more tables into a single list. For example, if January, February, and March sales are stored in separate tables with the same fields, append them to make one sales query containing all three months. Each input contributes rows; the result generally has one row for each input record.

Power Query aligns fields by column name, not by their left-to-right position. If one table has columns named Date, Product, and Amount while another has those same columns in a different order, values still go into the matching named fields. If a source lacks a field found in another source, the appended result has that field and shows null for rows coming from the source without it. Null means no value is present; it is not the same as a zero or an empty string.

An append does not automatically remove duplicate records, sort the result, or check whether two rows represent the same transaction. It combines the rows; you decide whether to filter, sort, group, or remove duplicates in later steps.

Append versus merge

Append and merge are different operations, although both combine queries. Append adds rows, like stacking worksheets vertically. Merge joins tables using one or more matching fields, like matching an order list to a customer list using Customer ID. If the goal is to add more months of the same kind of data, append is usually the relevant choice. If the goal is to bring a customer name onto each order using a shared ID, use a merge instead.

A useful test is to ask whether the source tables describe the same kind of record. Monthly sales exports usually do, so they can be appended. A sales table and a product lookup table usually describe different things, so joining them by a product key is more appropriate than stacking them. Appending unlike tables is possible, but it can produce a confusing result full of unrelated columns and nulls.

Prepare the source tables

Before building the query, make each source easy to identify and consistent enough to combine. In Excel, convert each source range into a table using Insert > Table, and confirm that the table has headers. Give each table a distinct, meaningful name in Table Design > Table Name, such as Sales_Jan and Sales_Feb. Table sources are preferable to fixed ranges because they can expand when new rows are added.

Check these details before appending:

  • Use the same header spelling for fields that represent the same information. Amount and Sales Amount will be treated as separate fields.
  • Keep one record per row and one field per column. Avoid merged cells, repeated header rows inside the data, and totals mixed into the records.
  • Check data types, especially dates, IDs, and numeric amounts. An ID such as 00124 may need to remain text so its leading zeros are not lost.
  • Remove or account for blank rows and source-specific notes that should not become records.
  • Decide how to handle a field that exists in only some months, such as a newly introduced Region column.

Append queries step by step

  1. For each Excel table, select a cell and choose Data > From Table/Range. In Power Query, review the data and use Home > Close & Load > Close & Load To… if you need to control whether the query is loaded to a worksheet or kept as a connection. Repeat for each source table.
  2. Open the Power Query Editor if it is not already open. In the Queries pane, select the query that should receive the additional rows. Choose Home > Append Queries to change that query into an appended result, or choose Home > Append Queries > Append Queries as New to preserve the original queries and make a new combined query.
  3. In the Append dialog, choose Two tables for two inputs. For three or more, choose Three or more tables, then select each query in Available tables and use Add to include it in the list. Confirm the order and click OK.
  4. Review the result. Check the column names, row count, nulls, and data types. Apply any needed cleanup steps in the editor, such as removing repeated header rows or setting the correct type for Date.
  5. Choose Home > Close & Load, or use Close & Load To… to set the output destination. To update the result later, use Data > Refresh All in Excel.

For a two-table append, the dialog asks you to choose the first and second table. For three or more tables, adding queries to the selected list makes the intended inputs explicit. The names in the dialog are query names, which may differ from the original worksheet names or Excel table names.

Append as new or append to an existing query?

Append Queries as New is often the safer starting point: it leaves each source query intact and creates a distinct combined query. That makes it easier to troubleshoot a single month or reuse a source query for another task. Append Queries, without as New, alters the currently selected query so its output includes the appended rows. Choose that option when the selected query itself is meant to become the final combined dataset.

Neither choice copies the source data into a static snapshot. The combined query retains steps that refer to its input queries. When the sources change and the query is refreshed, Power Query runs those steps again. Keep the source queries if the appended query depends on them; deleting a query that another query references can break the dependent result.

Example: combining monthly sales

Suppose Sales_Jan has columns Date, OrderID, and Amount, while Sales_Feb has the same three fields and a different number of records. Append the two queries as a new query named Sales_All. The result contains records from both months, with one shared Date, OrderID, and Amount column set. It does not need the two tables to have the same number of rows.

Now suppose February also includes a Channel field because the export changed. The result can include Channel, with null for January records and the February value where available. If OrderID is stored as a number in January but as text in February, inspect the result and deliberately set a consistent type. Converting an identifier to a number can remove leading zeros; converting a date-like text value may also fail if the source uses an unexpected format.

For a reliable check, compare the appended row count with the total number of data rows in the source tables, excluding headers and any rows intentionally filtered out. Then filter the result by month or source to verify that records from every input appear. A row-count difference is a reason to inspect filters and cleanup steps, not proof by itself that append has dropped data.

Refresh behavior and loading results

An append query is a set of transformation instructions, not a live display that changes the instant a source cell is edited. After changing the source tables, refresh the query with Data > Refresh All. If only one query needs updating, right-click it in the Queries & Connections pane and choose Refresh. Refresh runs the source and transformation steps again, so new rows in a properly defined Excel table can flow into the appended result.

Choose a worksheet destination when people need to inspect or use the combined rows directly in the workbook. Choose a connection-only result when the appended query feeds another query or a data model and does not need its own visible worksheet table. Very large outputs can exceed worksheet capacity: an Excel worksheet supports at most 1,048,576 rows. For a result too large to load to a sheet, use an appropriate connection or data-model workflow rather than expecting the worksheet to hold every row.

On Mac, Power Query features and exact ribbon labels can vary by Excel build; use the Data tab’s Get Data or Power Query commands where available. Excel for the web also has Power Query capabilities, but authoring options vary. The steps above describe Microsoft 365 for Windows, which offers the most consistent interface for these instructions.

Common problems and practical fixes

  • Unexpected separate columns: Check headers for spelling, punctuation, or extra spaces. Power Query treats differently named headers as different fields, even if they look similar at a glance.
  • Null values appear: A source may not contain that column, or its field may be blank. Confirm the source schema before replacing nulls; filling them with zero or text can change the meaning of the data.
  • Dates or numbers turn into errors: Inspect the type-conversion step and the source format. A date such as 03/04/2026 can be interpreted differently under different regional settings, so verify the intended month and day before changing locale or type.
  • New rows do not appear: Confirm that the added rows are inside the source Excel table, then refresh. Also check whether a filter step removes them and whether the appended query still references the expected source query.
  • Records appear more than once: Append retains duplicates. If repeated records are accidental, identify a suitable key and remove duplicates deliberately; two rows that look alike may still represent separate valid transactions.
  • The result has fewer columns or values than expected: Check each input query and its applied steps. A source query may already have removed a column or filtered rows before the append happens.

Frequently Asked Questions

Does Power Query append tables by column position?
No. It matches columns by their names. A column with a different name is treated as a separate field, and rows from a source without another field receive null in that field.

Can I append more than two queries?
Yes. In the Append dialog, choose Three or more tables, then add the queries you want to combine. The resulting query can contain rows from all selected inputs.

Does append remove duplicates automatically?
No. Append keeps the rows it receives, including duplicates. If duplicates should be removed, add a deliberate cleanup step and choose fields that correctly identify duplicate records.

Will new worksheet rows appear in the appended result automatically?
Not immediately. Add the rows inside the relevant source Excel table, then refresh the query or use Data > Refresh All. A query updates when refreshed, not simply because a source cell changed.

Should I append or merge two tables?
Append when the tables contain the same kind of records and you want more rows. Merge when you want to match records across tables using a shared key and bring fields from one table into the other.

Can I append tables with different columns?
Yes. Power Query builds a combined set of columns from the inputs. Rows from a table that lacks one of those columns have null for that field, so review whether the resulting schema makes sense for your analysis.

Related

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.