Video: How to copy multiple Google sheets to the current, new, existing or several separate spreadsheets

In today's video, I'll show you why Sheets Manager is a better alternative when it comes to copying multiple Google sheets. You'll see the handiest way of duplicating several tabs and, what's more, learn how to copy them into multiple separate spreadsheets in one go.

Video transcript: Copy multiple Google tabs using Sheets Manager

In this video, I'd like to talk about copying tabs in Google Sheets.

Though Google Sheets has a standard option for that, it doesn't cover all cases. I'm going to show you not only the fastest way to copy multiple sheets, but also a new feature: copy multiple Google Sheets tabs to multiple new spreadsheets. I will use the Sheets Manager add-on for that.

How to duplicate several Google sheets

Copy Google tabs with Google Sheets means

So here I have a dozen of tabs with different sales info.

Usually, to duplicate several sheets, you press the Ctrl key and hold it while selecting each required sheet. But since only a limited number of tabs fit the screen, you must scroll right to find all the other ones.

Then you right-click one of the selected sheets and choose Duplicate:
Duplicate several sheets with a standard Google Sheets option.

All copies will appear next to the first original tab; and if their order is important to you, you will need to sort them manually.

Copy multiple Google tabs using Sheets Manager

There's a much handy way with Sheets Manager.

Here's the add-on sidebar with a list of all tabs. I simply tick off these checkboxes for the required sheets and click Copy to > Current spreadsheet:
Duplicate several sheets using Sheets Manager.

In a few seconds, I can see a copy of each tab right next to its original in both the add-on and the file itself. I can quickly jump to any sheet by picking it in the add-on.

Copy Google sheets to a new or the existing spreadsheet

Sheets Manager also knows how to copy Google sheets into a new or the existing spreadsheet. The drill is the same, and though it's similar to the standard options – the add-on works faster and the overall experience with it is much friendlier and easier:
Copy all selected sheets to a new or existing spreadsheet.

Copy Google sheets to multiple new spreadsheets

Instead, I'd like to demonstrate another spark we've added: copying all selected sheets into multiple separate files. Google Sheets doesn't offer this opportunity at all so let's take a closer look.

I select my tabs and click this option:
Copy each selected sheet into its own new spreadsheet.

Basically, the add-on not just copies the tabs but splits them into their own spreadsheets.

When it's done, the add-on gives a link to a new Drive folder which is the quickest way to locate these new files. But you can always find them in your Drive next to your original file.

Here I've got 6 spreadsheets, one per tab I selected in the add-on earlier. Each file contains the data copied from its original.

These are 4 ways to copy Google sheets with the Sheets Manager add-on.

I'll put a link to Sheets Manager in the Google Marketplace in the description of this video so you could check it out.

And I'll see you in the next video where I will show you how to completely move Google tabs to other files.

You may also be interested in

Post a comment



Thank you for your comment! When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to your query. We cannot guarantee that we will answer every question, but we'll do our best :)