Importing an Excel Workbook

Jessicaf209

Hello,

I have an Excel workbook with about 20 tabs that I would like to import into Smartsheet. However, when I import the workbook, it always defaults to one specific worksheet and doesn't allow me to choose which worksheet to import. Ideally, I would like all 20 worksheets imported, but I need help finding options. Does anyone have any suggestions?

Thank you in advance.

Andrée Starå

Hi @Jessicaf209

I hope you're well and safe!

It will only import the first tab in the workbook, so you would either have to split the tabs into different sheets, copy the sheet (one for each tab), and then move the next tab so it's the first or import each tab, move the next to the first position and so on.

Make sense?

I hope that helps!

Have a fantastic week & Happy Holidays!

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!

Jessicaf209

Hi, Andrée,

That totally makes sense! Thank you for the guidance.

Happy Holidays!

Andrée Starå

@Jessicaf209

Excellent!

Happy to help!

✅Remember! 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!