Power Query is available as a free add-in on Excel 20, while it’s a built-in feature from Excel 2016 onward. You can use Power Query to merge Excel sheets based on a common column.
How to merge two Excel sheets based on one column As you can see in the image below, 3 duplicate values were removed, and we’re now left with unique values.
As well as merging sheets in Excel, you can also use the Coupler.io solution to combine Google Sheets into one. This is our result:Īs you can see in the image above, Coupler.io adds a “Sheet Name” column to help you differentiate the merged data.
Select the import mode of your data: select replace to fully update the previously imported information with the latest data.
However, you can change this by using the Cell address setting.
Select Microsoft Excel as a source app from the Application list.Click Add New importer and configure the following parameters: source, destination, and schedule. You can check out more integrations with Excel here.įirst, you need to set up a Coupler.io account. The tool is simple to use, and it doesn’t require any formulas or codes to work. You can either manually copy-paste the sheets or merge them using Coupler.io -an automation tool used to import data to Google Sheets, Microsoft Excel, and BigQuery from different sources. How would you merge the three Excel sheets (Sheet 1, Sheet 2, and Sheet 3) below?Įxcel doesn’t actually have a built-in function to merge sheets. What’s the best option? How to merge Excel sheets