Apart from Data Shuttle Is there any other method to upload data from Excel to Smartsheet

Sandhiya07

Hi Team,

I need to upload the data from Excel to Smartsheet, already my Smartsheet is having more than 1000 rows, daily I'm getting Excel report from my team once in a day.

So while moving data from excel to Smartsheet, it has to check already that data is present or not.

If we present need to update the details of that particular record(row) or else add as new row.

Kindly help me on this.

Thanks,

Sandhiya P

Andrée Starå

Hi @Sandhiya07

I hope you're well and safe!

You could possibly use 3rd-party options like Zapier, Power Automate, or something similar.

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!

Sandhiya07

Hi @Andrée Starå ,

Can we do it using API method?

I hope you got my scanrio.

Thanks

Andrée Starå

@Sandhiya07

Happy to help!

Yes, you could use the Smartsheet API too. I forgot about that one.

There's also this option.

https://help.smartsheet.com/learning-track/integrations-and-add-ons/live-data-connector

✅Remember! 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!

LaurenLong

@Andrée Starå what's your best recommendation for an org that isn't using Data Shuttle? I've looked at Zapier, but seems like it's not fully fleshed out. I've used Live Data Connector to push data down from Smartsheet, but I'm needing to push from Excel to Smartsheet and can't do Data Shuttle this year. Power Automate seems more of a push from Smartsheet down to something else as well.