Merging offline makes sense, Google Sheets has a 2m cell limit per spreadsheet. You might want to look at OpenRefine as a tool, it can import and merge multiple .CSV files. Another tool I’ve seen used with TAGS is R – this however needs you to write scripts
