Welcome!

Sign in to join the conversation:

Import Excel Workbook

Good morning,

Is there a way to import a whole excel workbook and not just 1 tab?

Find more posts tagged with

Project Management

Importing and Exporting

Comments

Hi Kari,

Unfortunately, as far as I know, it's not possible at the moment, it has to be one tab per import, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

I'm not aware of a way either. Would be great to have though.

Paul,

Yes, that would be an excellent addition.

Please submit an Enhancement Request when you have a moment.

Best,

Andrée

Hi Kari,

There are solutions that let you split the Workbook to separate Excel files so that it would be easier to import them to Smartsheet.

Hope that helps!

Best,

Andrée

I've already submitted one a while ago. May just submit another though.

Go for it!

Thank you

Happy to help!

Let me know if you'd want the links!

Best,

Andrée

Hi would you be able to let me know how to split a workbook that would be very helpful

Happy to!

I haven't tested any of these so research thoroughly, and backup before you try them out.

https://www.extendoffice.com/documents/excel/628-excel-split-workbook.html

Please let me know how it goes!

Hope that helps!

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Linking another Sheet
Hi All, I am having some challenges which I was hoping someone might be able to help me with… There is an existing Smartsheet that a project team uses to display new product introductions. As this sheet is updated in real time and I am not in that team, I can't add fields that I want to track into that sheet; however, some…
New to Smartsheet and completely overwhelmed - how do I manage trials with multiple tasks?
This is what I would like to accomplish using Smartsheets but I am struggling to find the best way to go about it. Each year we get new vegetable varieties that we need to test in various locations at different times. I would like a tool that I can follow each variety up with a grower. The following data is added:…
I upgraded from free to pro. I cannot access my sheets or Smartsheet support. Help?
I recently upgraded to a paid Pro account. The day I upgraded I could access everything I had created. I created a new sheet and it put it in a new untitled workspace. When I went back to access my other (previously created) Workspace today, I get a message "An error has occurred in Smartsheet." I've logged out and logged…