Submit a request

Import Size Limitations?

Comments

4 comments

  • Avatar
    Justin Murphy

    Hi Andrew -

     

    It seems to largely depend on how many columns you have. We have found that with around 15-20 columns, we try to keep to about 5,000 rows. 

    If you only have a couple of columns, you might be able to do larger chunks.

    If you are working with less or more columns, you may need to experiment.

    Justin

    0
    Comment actions Permalink
  • Avatar
    AmeriCommerce Accounting Team

    The newest versions, 2013.4+ that has the new admin can support very large files although there are some limits if you use Microsoft Excel specifically.  I want to say that is like 65k rows or so.  Additionally, in 2013.5+, our even newer version, we added Pause and Resume capabilities to imports!  This allows processing HUGE files, and if the app recycles or anything, or if you push 'pause', it will pick up exactly where it left off!  Neat right!  Let us know how all this works because we value import and export challenges highly.

    0
    Comment actions Permalink
  • Avatar
    Andrew Broughton

    Great information. To the Support Agent, you said "if you use Microsoft Excel", if I used something else would the limits go away? if yes, what else would I use for importing?

    Thanks!

    Andrew

    0
    Comment actions Permalink
  • Avatar
    Placeholder Support #5

    It looks like Excel 2007 and 2013 has expanded the limits to 1,048,576 rows by 16,384 columns.  http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx?CTT=1

     

    From what I can tell, the open source alternative LibreOffice has the same limits with its version 3.3.3 (pre 3.3.3, the limit was was about 65k while 3.3.3 and later has a limit of 1,048,576). Unfortunately, I cannot find official documentation to confirm that, its just based on various forum questions on their website.

    0
    Comment actions Permalink

Please sign in to leave a comment.

We're Here To Help


Standard Support Hours: Monday-Friday 8AM-6PM CST
Looking for Premium Support? Just ask!

Speak to a live person
1 (800) 936-9006
Submit A Support Ticket
Submit Your Ticket Here