Video: How to move multiple Google sheets to new, existing or several separate spreadsheets

Have you ever tried to move — cut & paste — Google sheets from one file to another? There's no such option available in spreadsheets. But it doesn't really matter if you have Sheets Manager at hand. It knows how to split your Google spreadsheet by tabs or simply move multiple tabs to a new or the existing file at once.

Video transcript: Move multiple Google sheets using Sheets Manager

In this video, I'll show the quickest way to move Google sheets from one file to another.

By the end, you'll know how to swiftly split your Google spreadsheet per tab into separate files and how to cut & paste multiple selected sheets into a new or any existing file.

Since Google Sheets doesn't have such options at all, I will use the Sheets Manager add-on.

Start Sheets Manager

So here's my spreadsheet with 12 different tabs.

To move any of them from this file to another, Google Sheets leaves no choice but to copy the tab to the destination file first and then delete it from here. And it doesn't get any easier when you have to do this for several sheets in a row.

Sheets Manager turns this into child's play.

It shows a list of all tabs in its sidebar. Just tick off all those sheets that you want to move away from this file, click Move to and pick your destination:
3 options to move sheets using Sheets Manager.

Move Google sheets into a new spreadsheet

Go with the first one if you want to put all these sheets into a new file.

The add-on will create it in your Drive next to this spreadsheet and will offer a link to open it right away.

See? All those 6 tabs have been moved here. I go back to my original file and those sheets are not here anymore.

Move Google sheets into the existing spreadsheet

The same happens if you move tabs to an existing spreadsheet.

You'll just need to manually select the file where those sheets should go and press Move.

As soon as the add-on cuts the tabs from this file and pastes them into another one, it will offer to open the target spreadsheet. And here they are — all those 6 tabs.

Move multiple Google sheets — each into its own individual spreadsheets

Finally, Sheets Manager knows how to put each one of these sheets into its own spreadsheet. It's especially helpful if you want each person to work on their own document.

The add-on creates a folder in your Drive next to this original file and pastes all new spreadsheets there, each with its own tab.

This is how you move multiple Google sheets between different spreadsheets.

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

Thanks for watching and see you in the next videos!

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 :)