nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Import Excel Workbook

Karrie Davis

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

Andrée Starå

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

Paul Newcome

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

Andrée Starå

Paul,

Yes, that would be an excellent addition.

Please submit an Enhancement Request when you have a moment.

Best,

Andrée

Andrée Starå

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

Paul Newcome

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

Andrée Starå

Go for it!

Karrie Davis

Thank you

Andrée Starå

Happy to help!

Let me know if you'd want the links!

Best,

Andrée

Karrie Davis

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

Andrée Starå

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

"Fields marked with an asterisk (*) are required." line on every form.
Hi, "Fields marked with an asterisk (*) are required." is the very first line in the body of every form I create. I don't remember seeing it before (unless you missed filling out a required field; then you would see the message). Is there a way to turn it off or change it? None of my forms are in English so the message is…
Best Way to Create a Stacked Bar Chart from multiple columns
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…
Dynamic View Issue - Group Sharing
I have a dynamic view setup for a dashboard that has NO restrictions And on the Sharing tab, I have a Group that I created as the additional share access to the view But the individuals in the Group still cannot see the data from the dashboard. Am I missing something? Because when I share the view to them individually…