Importing a 10,000 lines x 60 columns sheet
Hello,
As I am trying to import a large xls sheet I come a cross a SMartsheet limitation: 5,000 rows max
So I import the first 5,000 rows & try to paste manually the following rows.
I then come across a 2nd limitation: not more than 500 rows & 50 columns max.
But when I paste 300 lines & 45 columns I still get the error message stating the limit of 50 columns.
In essence importing the 10,000 rouws & 60 columns into Smartsheet turns into a nightmare.
And my Company doesn't have avaialble the DataShuttle module license unfortunately.
Would someone has guidance / tips on how should I handle this in a smarter way ?
Thanks
Pierre-Eric
Best Answer
-
use it as your criteria for your move workflow.
- import sheet A (first 5k rows)
- import sheet B (second 5k rows)
- add checkbox column to sheet B
- add move workflow to sheet B (if checkbox column changes to checked, then moved to sheet A)
- Check the first checkbox in sheet B. Copy the checkbox, then hit ctrl-shift-down to highlight the entire column
- paste and then save
- wait a couple minutes, grab a coffee, do something else.
- refresh the screen
Answers
-
Try importing 2 separate smartsheets with 5k rows each. Then you can use a move workflow with a checkbox column to merge them together.
-
Thanks L_123
I am not sure yet what would be the purpose/benefit of the checkbox column but if you can elaborate a litte would be very useful to me
-
use it as your criteria for your move workflow.
- import sheet A (first 5k rows)
- import sheet B (second 5k rows)
- add checkbox column to sheet B
- add move workflow to sheet B (if checkbox column changes to checked, then moved to sheet A)
- Check the first checkbox in sheet B. Copy the checkbox, then hit ctrl-shift-down to highlight the entire column
- paste and then save
- wait a couple minutes, grab a coffee, do something else.
- refresh the screen
-
very smart, thank you !
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives