Excel Power Query: Add Data to an Existing Table?

How-to basics · Updated November 21, 2026

Yes—use Power Query’s Append operation to combine rows from an existing table and another data source, then load the combined result as a query output table. A refresh does not permanently add rows to a manually maintained or already loaded output table; to keep new data, make the underlying source tables the inputs to the query.

What “add data to an existing table” can mean

The phrase can describe two different tasks. You might want to combine rows from two sources into one refreshed result, or you might want to insert new rows into a worksheet table and leave them there as ordinary, editable cells. Power Query is designed for the first task: it reads source data, applies steps, and returns a result. It is not a command that permanently inserts records into a table while leaving the original query output untouched.

This distinction matters when a worksheet already contains a table. If that table is a manually maintained input table, it can be one of the query’s sources. If it is the table created by a query load, treat it as the query’s output, not as a place to add extra rows by hand. A later refresh can replace the output with the query’s newly calculated result, so hand-added rows may disappear.

The recommended approach: append source tables

For a durable, repeatable result, keep the original records and incoming records in separate source tables, then append them in Power Query. For example, a workbook might have an Excel table named Sales2025 with older transactions and another named NewSales with this month’s transactions. An appended query can return both sets of rows in a single result table. When NewSales gains more records, refresh the query to include them.

The source tables can be in the same workbook or come from other files and supported data sources. If you already have queries for the sources, append those queries directly. If the data is in a worksheet range, converting it to an Excel table first makes the source easier to maintain as rows are added.

Step-by-step: append rows in Excel for Microsoft 365

  1. Make sure each source has column headers and that the records are in an Excel table or an existing Power Query query. To make a table, select the data and choose Insert > Table, or click within the range and use Data > From Table/Range to create a query from it.
  2. For a table not yet imported, click inside it and choose Data > From Table/Range. In the Power Query Editor, check that the headers and data types look right, then choose Home > Close & Load > Close & Load To if you need to control how the query is loaded. You can also create or import the second source as a separate query.
  3. In Power Query Editor, select Home > Append Queries > Append Queries as New. Choosing “as New” creates a separate combined query and leaves the source queries available for reuse.
  4. In the Append dialog, choose Two tables or Three or more tables, as appropriate, and select the source queries. For example, select Sales2025 and NewSales. Choose OK.
  5. Review the combined preview, including column names, data types, and any null values or errors. Give the new query a descriptive name, such as AllSales.
  6. Choose Home > Close & Load, or use Close & Load To to select a new worksheet or a suitable blank destination on an existing worksheet. The result is a query-loaded table.

To update the result after adding records to a source table, choose Data > Refresh All. If the added records are typed directly below an Excel table, Excel generally expands the table to include them; confirm that they are inside the table before refreshing. If the records are in another file or source, make sure that source itself contains the changes and that the query can still access it.

How Power Query matches columns

Append means stacking rows, not placing the second table’s values beside the first table’s values. Power Query aligns fields using column names rather than relying on the columns being in the same left-to-right order. Thus, a Date column in one source can align with a Date column in another even if the two columns appear in different positions.

Matching names are important. If one table calls a field CustomerID and another calls it Customer ID, Power Query treats those as different columns unless you rename one so the names match. The appended result then has both fields; rows from a source that lacks one of those fields show null in that column. Null means no value was supplied for that field; it is not the same as zero or an empty text value.

  • Same headers: Values from matching columns appear in the same result column.
  • Different column order: The result still aligns fields by name.
  • A column missing from one source: The result includes the column, with nulls for rows from the source that did not have it.
  • Repeated records: Append keeps them. It does not automatically identify or remove duplicates, sort the result, or check whether a transaction was already included.

Check data types as well as names. A date column should contain dates consistently, and an amount column should use a compatible number type. Power Query may create type-conversion steps when it imports data; inconsistent values can produce errors or unexpected results. Correct the source or adjust the relevant transformation before loading the final result.

What refresh does—and does not do

A query output table is the result of its steps. Refresh reruns those steps against the current sources and updates the output; it is not a history log that automatically preserves extra rows typed into the result area. For this reason, do not use a query-loaded table as a scratch area for permanent manual additions. Those edits are not a reliable part of the query’s input and can be overwritten or fall outside the refreshed result.

Instead, add records to a source table or source file, then refresh the appended query. If people need to enter new records in the workbook, provide a separate input table for them and include that table as a source in the append. Keep the query output in a separate location or worksheet so the input and output have clear roles.

Avoid making a query read its own output as an input to the same result. That creates a circular or unstable design: the query depends on a table that the query itself is responsible for refreshing. Store persistent input data independently, then build the output from those inputs.

Append versus merge

Append and Merge are both ways to combine data in Power Query, but they solve different problems. Append stacks records vertically when the sources have similar kinds of columns—for example, January sales rows under December sales rows. Merge joins columns horizontally by matching a key, such as adding a customer’s region to each sales row based on CustomerID.

Use Append when you are combining additional records of the same general type. Use Merge when each source contributes different fields about related records. For a merge, choose the matching columns and join kind carefully; an incorrect key or join choice can omit records or create repeated rows. If your goal is simply “put these next rows under those rows,” Append Queries is usually the appropriate operation.

Common problems and practical checks

  • The new rows do not appear: Check that they were added to the source table or file, not just typed beside the query output. Then choose Data > Refresh All.
  • Values appear in separate columns: Compare header spelling, spacing, and punctuation across sources. Rename equivalent fields consistently in Power Query.
  • Some result cells show null: Look for fields that exist in one source but not another. Add or rename source columns if those values should align.
  • Refresh produces errors: Inspect the query steps for type conversions and check for text in a numeric field, invalid dates, or changed source headers.
  • The output is in the wrong place: Use Close & Load To to choose an appropriate destination. Avoid choosing a range containing data you want to preserve.
  • Records appear twice: Append does not deduplicate. Decide what makes a record unique, then remove duplicates or filter in Power Query only if that matches the reporting rules.

It is also worth checking that each source has one header row and that the header row is recognized as headers rather than treated as a record. Keep column names stable over time; renaming a field in a source may break later steps that refer to its former name.

When you need rows physically added to a worksheet table

If you need to insert rows into a table and have them remain as editable worksheet data, add them to a manually maintained source table rather than to the query output. You can paste the new records into that input table, or enter them in the first row below it so the table expands, then refresh a separate query that reads it. This preserves the entered records because they are part of the source.

If the existing table is already a Power Query result and you need to retain its current records as permanent inputs, first create a separate, stable source containing those records and keep future additions there too. Then build the combined query from that source and the new data. Copying a query output into a separate values-only source can be one migration option, but it creates a snapshot: later changes to the original query will not automatically update that copy.

For a one-time, non-refreshable change, you can paste rows directly into a normal worksheet table. That is a worksheet operation, not a Power Query append, and it does not make the added rows part of the query’s refresh logic. Choose based on whether you need a repeatable refreshed result or a permanent manual edit.

Frequently Asked Questions

Can Power Query append data directly to an existing Excel table?

It can combine data and load the result as a table, but it does not reliably insert refreshed rows into an existing manually maintained table while preserving unrelated manual edits. Append the source queries and load the combined result as the query output.

Will Power Query keep rows I type into its output table?

Do not rely on it. A refresh recalculates the query output from its sources, so manually typed rows in that output are not a dependable data source and may be lost. Put lasting additions in a separate source table included in the query.

Does Append Queries remove duplicates?

No. Append stacks the rows from its inputs and retains duplicate records. If duplicates are not wanted, use a deliberate deduplication step based on the fields that define a unique record.

Can I append tables with different column names or orders?

Yes, but Power Query aligns columns by header name, not position. Different names become separate columns; a missing field produces nulls for the source that lacks it. Rename equivalent fields consistently if they should be combined.

How do I update an appended table after adding records?

Add the records to one of the query’s source tables or files, confirm the source includes them, and choose Data > Refresh All. The query will rebuild its result from the updated sources.

Platform note

These instructions describe Excel for Microsoft 365 on Windows. Power Query is also available in Excel for Mac, but connector availability and some commands can differ by build, so the ribbon may not match these Windows paths exactly. Excel for the web also has different Power Query capabilities from desktop Excel; use the desktop app if the needed query-editing command is unavailable in your web version.

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.