Am I able to import Excel data to a SmartSheet with existing data?

Brandi AS · 03/07/24

I have a SmartSheet that I need to add to. I am looking to import data from an Excel file to my existing SmartSheet that already has data in it but I'm not finding a way to do this.

When I upload the Excel file it uploads as its own new SmartSheet rather than adding to the one I want it to add to.

Can anyone help me understand the limitations or workarounds for this scenario?

Thank you!

Brandi

Andrée Starå · 03/07/24

https://community.smartsheet.com/discussion/comment/423955#Comment_423955

Excellent!

Happy to help!

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

SmartWay360 · 03/07/24

Hi,

For more advanced imports there is a module Data Shuttle. (Link: Data Shuttle | Smartsheet).

It is advanced module so you need an additional license for that. But usage is quite simple.

Best,

Beata

Andrée Starå · 03/07/24

https://community.smartsheet.com/discussion/118652/am-i-able-to-import-excel-data-to-a-smartsheet-with-existing-data

Hi,

I hope you're well and safe!

To add to Beata's excellent advice/answer.

Another option is what I sometimes do in my client solutions. Create an import sheet to which you paste or move the data, and then it's automatically added to the correct sheet(s).

Would that work/help?

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!

Brandi AS · 03/07/24

Thank you for your replies. I don't know that I'll be able to get the data shuttle license paid for but I'll try the copy and paste method. I'd tried the copy and paste but it won't paste, I'm checking in to my SS license to make sure I have that capability.

Best,

Brandi

Andrée Starå · 03/07/24

https://community.smartsheet.com/discussion/comment/423955#Comment_423955

Excellent!

Happy to help!

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

Am I able to import Excel data to a SmartSheet with existing data?

Best Answer

Answers

Categories