Google Sheets & WBmerge
Combining multiple spreadsheets together in Google Sheets is just as painful as doing it in Microsoft Excel. Let WBmerge make your life better and save you time.
Why not just download the spreadsheets to combine as Excel workbooks (.xlsx files) from Google. It is easy to download multiple spreadsheets from your Google Drive onto your local computer, as a single zip file.
Then use WBmerge to combine the Excel workbooks into one new workbook with all of your data, then import the new workbook back up to Google Sheets.
Because Google Sheets has a 5 million cell limit, WBmerge tracks the number of cells written so Google Sheets users will know if they have exceeded the Google Sheets limit.
Spreadsheets: Up to 5 million cells for spreadsheets that are created in or converted to Google Sheets. (Source - Google)
For those Google Sheets users with the need to work with merged workbooks in excess of 5 million cells, you can use Microsoft Excel to work with your data. If you do not have access to Microsoft Excel, we recommend using LibreOffice Calc which is a free download.