I have a large excel file to import

Question

Level 1

0 points

I have a large excel file to import

into the numbers app on my 32 gb ipad. It is 1.9mb, 9 columns by 32,000 rows. (it is regional sales data for my company). I don't want to delete any data. I have tried importing this via itunes and email and get the same error message - too many cells. Breaking up this file into smaller parts will defeat the whole purpose of what I am trying to accomplish for our traveling salespeople who want to show customers charts regarding sales history using the ipad.

Any suggestions to get this file imported will be very much appreciated!!

Posted on Apr 14, 2012 7:45 PM

Reply

Answer 1

Barry

Level 9

59,867 points

Apr 14, 2012 11:06 PM in response to thlogans

The message is pretty clear. There are too many cells.

That message makes the means of importing the document pretty obvious: Reduce the number of cells.

Regards,

Barry

Faint Hope clause: You may also want to check the (currently) last post in this thread.

B

Reply

Answer 2

thlogans Author

Level 1

0 points

Apr 14, 2012 11:13 PM in response to Barry

But I understand through a previous message in this forum that Numbers supports 65,000 rows and 256 columns. Is that true?

BTW, I do understand the message, but am wondering if Numbers thinks I have more cells than I actually do somehow, though I have cleared the contents from the blank cells in case there was a piece of data floating somewhere.

Reply

Answer 3

Barry

Level 9

59,867 points

Apr 14, 2012 11:29 PM in response to thlogans

"But I understand through a previous message in this forum that Numbers supports 65,000 rows and OR 256 columns. Is that true?"

True with the revision shown above.

Numbers '09 tables may have a maximum 65 000 rows (the actual number is a few hundred greater).

Numbers '09 tables may have a maximum 256 columns.

But Numbers '09 tables do not support a maximum 65 000 rows AND 256 columns in the same table.

Note that those specifications are for Numbers '09, and do not necessarily apply to Numbers for iOS.

"…but am wondering if Numbers thinks I have more cells than I actually do somehow…"

Possibly. see the thread linked in my previous message.

Regards,

Barry

PS: I've requested this thread be transferred to the iWork for iOS community. If there is a more favourable answer, you're more likely to find it there.

B

Reply

Answer 4

KOENIG Yvan

Level 8

41,807 points

Apr 15, 2012 1:02 AM in response to thlogans

The table size is limited by two features :

(1) the application's code itself which can't work with more than 65525 rows and more than 256 columns.

It's linked to design choices

(2) the memory available to allow the app to open the doc.

On my mac with 12 Gbytes installed the memory limit never strike.

Some times ago I made extended tests and posted their results in this forum.

Here they are one more time.

When we import a text file (TSV or CSV) here are the greater tables which may be imported :

65535 x 13 = 851 955 OK

65431 x 14 = 916 034 cells

61069 x 15 = 916 035 cells

57252 x 16 = 916 032 cells

53884 x 17 = 916 028 cells

50890 x 18 = 916 020 cells

48212 x 19 = 916 028 cells

45801 x 20 = 916 020 cells

43620 x 21 = 916 020 cells

…

3578 x 256 = 915968 cells

Yvan KOENIG (VALLAURIS, France) dimanche 15 avril 2012

iMac 21”5, i7, 2.8 GHz, 12 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.3

My Box account is : http://www.box.com/s/00qnssoyeq2xvc22ra4k

Reply