Is there any way to take a certain row of cells from an Excel Sheet and bring it to smartsheets?

Mathew Palter

I have multiple sheets on excel in which they track improvements continuously and would like to have the data automatically transferred into smartsheets as I have a master of all the excel sheets. Is there a formula or an add on that can allow this without having to manually copy and paste it every month? For example every 1st of the month I would need to go to each tracker and copy and paste the row from excel to smartsheets. I have heard of data shuttle but I am not sure if that would fix the issue.

Andrée Starå

Hi @Mathew Palter

I hope you're well and safe!

Yes, the Premium App, Data Shuttle, would be perfect for this, it seems.

More info: 

https://www.smartsheet.com/marketplace/premium-apps/data-uploader

Is that an option?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!