Sheets Manager for Google Sheets

The handiest way to manage multiple Google sheets at once

This add-on lists all tabs in its tree view offering you controls to select and handle numerous sheets in one go. You will hide/unhide several Google sheets at once, lock/unlock sheets, color, reorder, duplicate, copy, move, and delete sheets. Among extra features are possibilities to count sheets and copy/move them to multiple new spreadsheets.

Try it for 30 days for free
Sheets Manager for Google Sheets

With Sheets Manager you will

  • Navigate between all tabs in the file with ease See all sheets in the tree view: instantly spot protected, hidden, colored sheets, your active sheet and those tabs you selected to handle.
  • Copy and move several sheets to multiple new spreadsheets Have the add-on copy or move each selected sheet into its own new spreadsheet – all collected in a new Drive folder.
  • Protect sheets with 2 different permission settings Block the editing completely or choose to get a note asking others if they want to make any changes to the protected sheets.
  • See all hidden sheets of the file in the list Make the tool show all hidden sheets in its tree view with just one setting, or keep only visible tabs in the list.
  • Manage multiple selected sheets Hold Shift or Ctrl to select the tabs the classic way or turn on the Selection mode to get a checkbox next to each name.
  • Handle all selected tabs in one go Use the toolbar or the context menu to hide/unhide, lock/unlock, color, rename, copy, move & delete all selected sheets in a click.
  • Reorder sheets using drag-n-drop Or move them up/down & to the top/to the bottom of the entire list (and the file) from the context menu.
  • Make use of the sheet count Check the total number of tabs in your file and see how many of them you selected to process.

How to lock, copy, unhide, etc. multiple Google sheets

Find Sheets Manager in Power Tools
Find Sheets Manager in Power Tools
Control whether you want to see all hidden sheets in the add-on tree view
Control whether you want to see all hidden sheets in the add-on tree view
Reorder multiple tabs using drag-n-drop
Reorder multiple tabs using drag-n-drop
Use checkboxes or your mouse along with <em>Ctrl</em> or <em>Shift</em> to select several sheets to handle
Use checkboxes or your mouse along with Ctrl or Shift to select several sheets to handle
Manage tabs via the context menu or the options in the toolbar
Manage tabs via the context menu or the options in the toolbar
Copy or move multiple sheets to multiple new spreadsheets (or one new/existing spreadsheet)
Copy or move multiple sheets to multiple new spreadsheets (or one new/existing spreadsheet)
Get a link to open a new Drive folder with the new files right away
Get a link to open a new Drive folder with the new files right away

License benefits

Our customers get

Unconditional
30-day money-back guarantee
Free support
Volume discounts: the more you buy, the less you pay

These companies choose Ablebits products

Frequently asked questions

What is Sheets Manager and what do I need it for?

This add-on takes your sheet management to a next level. You will see all tabs in the add-on pane and navigate & reorder them quickly. You will select any number of tabs and process them all in the same way in just a click: lock Google sheets, copy, unhide sheets, etc.

Why should I invest in this tool if I can do this with Google Sheets means?

Sheets Manager has a few major advantages:

  1. It is a user-friendly pane with a list of all sheets from your file. You will instantly see all types of tabs: whether they are protected, colored or hidden; whether they are closer to the beginning or the end of the file.
  2. All actions are conveniently located as buttons on the toolbar to make it even easier for you.
  3. In Google Sheets, you must repeat the action with each tab individually. With our add-on, you will handle multiple selected sheets in one go.
  4. There's a brand new option: copy or move sheets to multiple new spreadsheets. If you've always wanted to transform your spreadsheet into several separate files (per tab) — this is your opportunity :)
  5. There's a sheet count available in the add-on. You will always know the exact number of all tabs and how many of them you have selected.

How do I handle Google sheets with Sheets Manager?

  1. Run Sheets Manager (look for the Process group or Smart Toolbar if you have Power Tools).
  2. Select the sheets you want to process.
  3. Click one of the buttons depending on what you want to do with the selected tabs.

See a more detailed description here.

If I copy/move sheets to multiple separate spreadsheets, where do I find them?

The add-on creates a new folder in your Drive next to a file you work with and puts all spreadsheets there. No worries, it will give you a link to open that folder right away.

Can I reorder sheets within the file using this add-on?

Sure. Select and drag them to the required position directly in the add-on pane or right-click the selected tabs in the list and move them to top/bottom or up/down via the context menu.

There's no button to rename a sheet.

This option is available for each tab individually. Hover your mouse over the sheet you want to rename and look for the pencil icon to the right of its name.

Where do I find the sheet count?

It's at the bottom of the add-on pane, next to the Ablebits logo.

Choose your plan

12-month

  • 12-month access with all updates
$15.00
Buy now

Lifetime

  • Get all new features and updates for free ever!
$39.95
Buy now

System requirements

Operating Systems

  • Microsoft: Windows 7 and up
  • Mac: Yosemite 10.10 and up
  • Chrome OS™

Browsers

  • Chrome™
  • Firefox
  • Safari (Mac only)

Any questions or comments?

Please contact us here

Our working hours:
12:00 am - 10:00 am PST; 3:00 am - 1:00 pm EST; 8:00 am - 6:00 pm CET.

Your message was successfully sent.

Thank you for contacting us!
We will get back to you shortly.

You will receive a delivery confirmation for your message within a few minutes. If you don't get it, please re-send your message and make sure you entered a valid e-mail address.

Close