Man typing on laptop

Merge Sheets Google Sheets Add-On

  • open source
  • tools

Ever wanted to combine the data from multiple sheets in a Google Spreadsheet into one?

by Bobby Steinbach 26 December 2018

Ever wanted to combine the data from multiple sheets in a Google Spreadsheet into one? No? Well, um, we did, so we built the fabulous (and creatively named) Merge Sheets Google Sheets add-on. Don’t knock it till you try it! Check out the video below to see the Merge-inator in action.

For the non-video folk

Step 1: To install the plugin you have two options: 1) Get it directly from the chrome store; 2) From within a Spreadsheet, click the “Add-ons” menu item. Then, select “Get add-ons”. Finally, search the chrome store for “Merge Sheets”, scrolling till you find the MeanPug entry.

Step 2: After installing, be sure to grant the permissions required in the prompts. These basically just give us access to all your past, current, and future data. I joke! You’re just granting us read/write access for the sheet’s data
(so we can write the merged data + read from the fragmented sheets).

Step 3: Merge Sheets”. Finally, click on “Start Merge”. Important: Make sure you’re in the sheet you plan to write the merged data into. The first thing the script does is erase all data currently in the active sheet, so be careful not to erase your source data!

We’d love to hear your feedback, reach out at

If you’re looking for help with web or app development, paid search, social advertising, or SEO, the Pug is especially interested.

Ping us at, we’re always around.

Other News plus icon Back to all
Useful Resources plus icon Get your freebies
legal marketing resources

Check out our Free Resources for marketing tips and tricks.

There’s no better time to transform your firm than today. Take the first step by downloading our free marketing checklists and ebooks.

We’ll never turn our backs on you again

Don't be shy. Fill out the form and we'll be in touch shortly