How to merge all files in google drive?

Question

excel

There are table files on google drive, I need to merge them all into one new table. How to do it? Is there a script or tool to do this?

Answer 1

Merge Google Documents service helps to combine several Google documents or spreadsheets into one file .
To start working with the service, you will have to authorize it in your Google account. This is necessary to work with files on the Disk. The connection request will appear the first time you click on the file selection button.
To connect, you need to click the Login & Authorize button and copy the application authorization code (this is safe). Then click Login.
After the done actions, you can already freely work with the service. The first step is to select all files to merge. These can be documents or tables, but you can only merge documents of the same type.
The selected files will appear in the list to merge. The list can be saved for later. And below, select a folder and specify the name of the file into which the documents will be combined.
Select the settings and click Merge Documents, Spreadsheets and get the merged file.
Everything)