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

Find more posts tagged with

Accepted answers

L_123

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

All comments

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.

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

Pierre-Eric Collette

very smart, thank you !

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.