The first step is to open the Google sheet where you wish to copy the Excel data. On the top toolbar, click the Import option under the File menu. You can then upload the Excel file whose data you want to transfer to the Google sheet by clicking on Upload. When you check the import theme and click on the import data, all the data from the Excel sheets will be copied to the Google sheet.

Open the Google sheet.

Click the option called Import under the File menu in the top toolbar.

Click on Upload and select the Excel file.

After that check the import theme and click on the import data, it will copy all the data of all the Excel sheets to the Google sheet.