Importing Excel file to Smartsheet
Hi All,
I have an excel file that I imported to Smartsheet - I have built a dashboard based on this report and it all works great. The issue is, as it is an extract from one of our customer's programs, we get this on a weekly basis, which means I will have to upload it to Smartsheet weekly. I don't want to build a new dashboard every week to represent the up to date data. Is there a way to bring a new report on to the existing sheet so the dashboards gets automatically updated?
I have tried the file - import from excel function but it seems it's creating a new sheet every time I tried. Copy and paste is not really doing it for me either as it's only allowing 50 cells and the extracts are much bigger.
Do you have any other ideas please?
Answers
-
Hi @angelapaj
I hope you're well and safe!
Here's a possible workaround or workarounds
- Premium app, Data Shuttle
- Add a so-called helper sheet where you can copy and paste the information and then have the rows added to the sheet. (you should be able to copy/paste 500 rows)
Would any of those options 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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I agree that the premium add-on Data Shuttle is the perfect tool for this.
@Andrée Starå I think the 50 cells is more related to columns as opposed to rows. You can only paste 50 columns at a time.
-
Where have you seen that limit?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thank you all. I will check the above solutions and see what works best for me. Of course, I meant columns, not cells - my mistake, apologies :)
-
Excellent!
Happy to help!
✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Andrée Starå When trying to copy/paste from an Excel file.
-
I must have never pasted that many because I've never seen it before.
Good to know! Thanks!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Andrée Starå It was definitely an annoying one to learn the hard way.
@angelapaj Another possible option would be to go ahead and import the Excel doc as a new Smartsheet, then use a copy or move row (either automation or at the row level) to push the data over to the original sheet.
If you have a [Created Date] type column in the original sheet, you can filter to show all rows that were not added "today" and delete those to get rid of the old data. This won't run into the limit of copying too many columns and should work pretty smoothly assuming you have room in the original sheet (or delete the rows from the original sheet first).
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives