Importing an Excel document with multiple tabs

Penny

What is the best way to import an Excel document with multiple tabs.  I tried using the import function, but it only imported the first tab.  The formulas have been written in Excel across multiple sheets, and I don't want to lose the formulas.  Thank you for any help.

Travis

Hi Penny, currently it is only possible to import the first sheet in an Excel workbook. If you want to import other sheets, move them to the first position, save, then import the file. Repeat for each sheet.

 

Just a note, formulas in Smartsheet cannot reference cells in other sheets. The workaround for this would be to use cell linking to link the cell you want to reference to your sheet, then reference the linked cell in your formula. 

kadamson

I could really use this functionality, is this on the roadmap? I have an excel sheet with 8 tabs all relating to the first master sheet. I don't want to have to set up 8 separate smartsheets

Andrée Starå

Hi,

Smartsheet just released a new add-on called Data Uploader that could be an option.

Please see the attached link/screenshot for more information.

https://www.smartsheet.com/datauploader

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting