Importing large file from Excel into Smartsheets

TEATom

I see the limit for Excel imports equals 20,000 rows. I have a file with over 30,000 that I'd like to get into SS. Any workarounds?

Paul Newcome

@TEATom You would need to import each individually. If you are using the import function, you would need to import tab 1, move tab 2 to be the leftmost tab, save, import, move tab 3 to be the leftmost tab, save, import, etc.

If using Data Shuttle, you would need to set up separate workflows for each tab, but you can designate within the workflow which tab it should be importing.

Paul Newcome

You will need to break it down and import it into two different Smartsheet sheets. Smartsheet sheets cannot have more than 20,000 rows, 400 columns, or a combined cell count of 500,000.

TEATom

Thanks for the quick response.

I am trying to wrap my ahead around how to do that yet still keep its functionality. Any reason for the limit that seems unceremoniously small?

Paul Newcome

That depends on the functionality you need. There are a number of options for tying sheets together but structure and needs are so variable that I can't really give you a good answer without more detail.

Andrée Starå

https://community.smartsheet.com/discussion/123171/importing-large-file-from-excel-into-smartsheets

Hi,

I hope you're well and safe!

Have you explored the Premium App, Data Shuttle, and DataTable?

Is that an option?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

TEATom

I do not have Premium through my employer. Not aware of Data shuttle? Would it help in getting a larger Excel file imported?

Paul Newcome

Data Shuttle will only help if you also have Data Table because of the Smartsheet sheet size limitations.

Andrée Starå

https://community.smartsheet.com/discussion/comment/440287#Comment_440287

DataTable includes Data Shuttle, so it wouldn't help in your case to get only Data Shuttle.
You can store millions of rows of data in DataTable.

Make sense?

More info.

https://www.smartsheet.com/marketplace/premium-apps/data-shuttle

https://www.smartsheet.com/marketplace/premium-apps/datatable

Would that work?

✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

TEATom

This may work as I have reviewed Data Table but have not worked with it much in my role.

Andrée Starå

https://community.smartsheet.com/discussion/comment/440765#Comment_440765

Excellent!

Feel free to contact me at andree@workbold.com, and I'd be happy to help you with the Data Table license and more.

✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

TEATom

We were able to limit the Excel sheets to <20000 rows, however, when I upload it, only the first workbook/tab was uploaded and it has multiple. Can someone tell me how I get all of the tabs into SMartsheets?

Paul Newcome

@TEATom You would need to import each individually. If you are using the import function, you would need to import tab 1, move tab 2 to be the leftmost tab, save, import, move tab 3 to be the leftmost tab, save, import, etc.

If using Data Shuttle, you would need to set up separate workflows for each tab, but you can designate within the workflow which tab it should be importing.

TEATom

THanks. This leads to even more. There are vlookups in each tab referencing another tab. This could get messy and I have significant concerns about how to do all of this cleanly and properly.

TEATom

If I imported from the original starting with the last tab, since I'm importing, would the vlookups remain intact?

Paul Newcome

The formulas themselves may still be there, but you will need to recreate the cross sheet references.

TEATom

THanks for all of this.

I am importing by moving tabs since it will only pull the first tab on import. Once I get them all in, is there a way to get them all into one sheet or would I need to create worksheets (I believe that is what they are called in SS) that I would then need to have the vlookups from the original/1st imported tab?