Consolidate sheets in Google Sheets

The standard ways to consolidate data in Google Sheets feature Pivot table and the QUERY function. To get a summary report in the Pivot table, you will still have to copy all records to one place manually or using VLOOKUP. And sadly, both VLOOKUP and QUERY have proven to be intricate to learn and time-consuming to build.

Consolidate Sheets is a formula-free solution to add up columns and rows from multiple Google sheets. You won't have to bother with functions and waste your time copy-pasting values anymore. The intuitive and clear options make your experience with the add-on swift and easy.

Go to the Extensions menu to start the tool and do the following:

1. Select sheets you want to merge and calculate.
2. Import more files from Drive if necessary.
3. Pick the function to calculate numbers.
4. Decide to summarize data by labels or position.
5. Choose where to place the result.
6. See if you want to have the result as a formula.
7. Click Consolidate.

See a more detailed description here.

Forget about it. :) To merge several files, use the add-on to scan your Drive and add spreadsheets to a tree view. The tree view lets you manage all files and ranges within one window.

In case you still want to open the spreadsheet, the tool provides you with a link to do so for every file.

The tool calculates your numbers with 11 consolidate functions: SUM, COUNT, AVERAGE, MAX, MIN, PRODUCT, COUNT NUMBERS, STDEV, STDEVP, VAR, VARP.

But there's no need to learn how to build formulas though. The utility takes this burden off your shoulders and does all the math for you.