I'd like to copy multiple sheets to another spreadsheet, it doesn't seem selecting multiple sheets simultaneously is a feature. Is there a workaround, add on, perhaps an available script?

2 Answers 2


The Google app script and add on community continues to prove to be an industrious bunch, currently testing Bulk Sheet Manager.

Update: unable to "copy to" another sheet, resorting to copying entire spreadsheet and bulk removing unwanted sheets with add on.


How about this? You make a copy of the original file. Then rename the new copy of the file to FILE#2. FILE#1 remains the same. FILE#2 has a copy of all the sheets/tabs as FILE#1. You then open FILE#2 and delete the sheets/tabs that you don't want. Save FILE#2. FILE#2 now has copies of the sheets/tabs from FILE#1. :)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.