Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
SS says my Excel sheet is too big to import
I'm new to SS and attempting to upload an Excel sheet that is 85MB. But it says the file is too big. Yet the Excel sheet only has about 250 rows and 10 columns. There are no formulas, just some cells with web links. What is the size limitt, and is there a workaround for getting this spreadsheet into SS?
Comments
-
Here's the answer from tech support:
The file size limit on import is 10MB. As a workaround you can create a new blank Excel workbook and select only the data you need from the original. Copying and paste that data into the new workbook and import it into Smartsheet.
We don’t measure sheets in a particular file size once they are in Smartsheet, but there are certain maximums we have put in place. Large sheets will increase the time needed to load and save your data. Smartsheet currently enforces the following maximum sizes on sheets to minimize encountering speed issues:
- Max rows: 5000
- Max columns: 200
- Max cells: 200,000
For sheets approaching this size we recommend taking a look at ways you can move completed items to another sheet, split up data into different time frames or other logical groupings, or remove columns that might be no longer needed.
-
Alice
Not sure if applicable, but I have run into this problem when I have more than one sheet in my workbook. I will just made a copy of the one sheet I want to import and save as a new workbook to import.
Christine
-
Thanks Christine. There was just one sheet in this workbook but Tech Support did mention that I should check for that. I ended up removing all unused cells and scaled down the sheet by removing some unnecessary data. That made enough of a difference to be able to upload it.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives