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

Can deleted sheets, workspaces and automations from a deactivated user be recovered?
We had a licensed user delete several files before leaving our organization. All of the sheets he owned have been transferred to someone else. However, there was one form we could not retrieve - Themed/Research Session Submission Form. Is there a way to recover that form? Any help is appreciated. Beverly Vance AMATYC…
Smartsheet Backups
Is there a way to save as a backup all sheets and workspaces? I am able to create a backup for all of the files shared with me. As the account's admin, can I back up all of the sheets and workspaces by all of our licensed users - even if they are not shared with me. We recently had a licensed use delete sheets and…
I Want to Filter Based on a Status and Date
Hello all, I have a weekly report that I'm building and would like to be able to only expose two weeks worth of status. The report has a status and a commit date column and I'd like to remove anything that is "Done" and more than 2 weeks old. I'm trying to avoid having a report that has 100 rows of tasks that have been…