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

Keep getting Selected data cannot be charted. Please select a new range.
Hello, I am trying to create a chart widget in my dashboard, but I keep getting "Selected data cannot be charted. Please select a new range." error. The report I am using is already summarized in numeric value. What is funny is I have report that I created a chart widget in another dashboard, and when I use that same…
Countifs formula to count based on two columns
I have a picture below for an example of this. I want to create a formula to get counts of items in "Column2", but if "Column4" states "change" I want the "Column2" count to not work and instead count what is it "Column3" in that given row. Column4 can also have several different things in it besides "good" that I want it…
Is there an issue with using reports on a dashboard to create a graph?
I've done this a million times - create a report, separated by campus with a total $$. Then add it to a dashboard and make a graph. NOTHING is working right now when I try to do this. I get an error that the data cannot be charted. What the what? Help anyone? Is this a issue since they apparently changed something in the…