Easily merging multiple sheets into one comprehensive sheet

Hiro@MPI

This may be a very specific problem but I appreciate any help! 

 

I am collecting a certain set of data from people and what I would like to do is provide an Excel template for folks and once they return the template, upload their data into Smartsheet. I know that any import creates a brand new sheet. But I'd like all of the data to eventually be compiled into one sheet so I can compare their data. 

 

Is there an easy way to do this? I hope my explanation makes sense, thanks again for any help in advance. 

Andrée Starå

Hi Hiro,

There are a few options.

• Manually copy/move the rows to the master sheet
• Automate it with the help of a third-party tool like Zapier or similar
• Automate it with the Premium Add-on Data Uploader

More info: https://www.smartsheet.com/datauploader

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting