Importing a 10,000 lines x 60 columns sheet

Pierre-Eric Collette

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

L_123

use it as your criteria for your move workflow.

1. import sheet A (first 5k rows)
2. import sheet B (second 5k rows)
3. add checkbox column to sheet B
4. add move workflow to sheet B (if checkbox column changes to checked, then moved to sheet A)
5. Check the first checkbox in sheet B. Copy the checkbox, then hit ctrl-shift-down to highlight the entire column
6. paste and then save
7. wait a couple minutes, grab a coffee, do something else.
8. refresh the screen

L_123

Try importing 2 separate smartsheets with 5k rows each. Then you can use a move workflow with a checkbox column to merge them together.

Pierre-Eric Collette

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

L_123

use it as your criteria for your move workflow.

1. import sheet A (first 5k rows)
2. import sheet B (second 5k rows)
3. add checkbox column to sheet B
4. add move workflow to sheet B (if checkbox column changes to checked, then moved to sheet A)
5. Check the first checkbox in sheet B. Copy the checkbox, then hit ctrl-shift-down to highlight the entire column
6. paste and then save
7. wait a couple minutes, grab a coffee, do something else.
8. refresh the screen

Pierre-Eric Collette

very smart, thank you !