I can't get Numbers spreadsheets to upload to Google Docs

Question

Level 1

2 points

I can't get Numbers spreadsheets to upload to Google Docs

Whenever I make a Numbers spreadsheet in my MBA OSX Lion and try to upload it to Google Docs, I get an error message.

I've tried making an Excel Copy and uploading that also.

I have the 'Conversion On' switch in G also but I just get a generic error message " The uploaded file could not be uploaded ".

Even very basic test.xls files fail.

Something simple which I am missing ?

OpenOffice in Linux or Excel in Win work fine.

MacBook, Mac OS X (10.7.3)

Posted on Feb 23, 2012 5:44 PM

Reply

Answer 1

Best reply

Wayne Contello

Level 7

26,529 points

Feb 23, 2012 6:42 PM in response to dastard

I was successful so I am including what I didf only to see if there are any differences. You clearly know how to upload since you were able to complete process in Windows and Linux.

I did the following:

1) made a simple single table:

2) Export to Excel using the menu item "File > Export":

The selected Excel in the Dialog:

3) saved on Desktop (or where ever you like):

4) logged into Google and went to Documents

5) Click the upload button:

6) Navigate to my file and select

7) I used the following Upload settings:

That's it

Reply

Answer 2

Feb 23, 2012 7:00 PM in response to dastard

I was using Firefox (version 11.0, Mac OS X, 10.7.3)

Reply

Answer 3

dastard Author

Level 1

2 points

Feb 23, 2012 7:06 PM in response to Wayne Contello

Strange.

I am doing *exactly* the same as you except that I am using Chrome.

I think that I have narrowed it down to the following.

Sheets which have NOT been created in Numbers cannot be uploaded.

Even if I export into XLS as you describe.

I am going to walk over to a Win box and try once more and will post back .

Thx Wayne !

-d-

Reply

Answer 4

dastard Author

Level 1

2 points

Feb 23, 2012 7:26 PM in response to dastard

OK, I just made a new sheet in XLS and uploaded it to G Docs with the same settings and it has worked.

Perhaps the sheet that I was using before was somehow corrupted and I was suspicious that it was a general incompatiblity problem with Numbers ( new user of it ).

Guess I didn't try hard enough.

Thx for confirmation that it does generally work fine.

-d-

Reply

Answer 5

jctakoma

Level 1

0 points

Aug 18, 2013 6:23 AM in response to dastard

Numbers > Excel > Google Sheet no problem when there are no formulas in the Numbers sheet.

Numbers > Excel > Google Sheet bizarre issues when there ARE formulas in the Numbers sheet.

Most (all?) cells with simple data (numbers, text) copy ok.

No problem in the Excel version, but some (many, but not all) cells with formulas simply appear blank in the Google Sheet.

Workaround: Numbers > CSV > Google Sheet, then manually fix the formulas. In my case, every row has the same formulas, so I fix one row, copy to all the other rows, and am done.

Possible Workaround I haven't tried: Numbers > Excel > Copy Excel sheet to a new Excel sheet > Google Sheet

This would require me to have Excel loaded on my MBA, which I don't.

Suggestions to Apple and/or Google:

1. Play nice and cut out the Microsoft intermediate step.

2. Apple could fix iCloud so that documents (rather than entire iCloud password sets) can be shared and sync'd, so that I'd not have to use Google Docs for such things.

Jeff

Reply

Answer 6

Barry

Level 9

59,861 points

Aug 18, 2013 10:47 AM in response to jctakoma

@Jeff

Hi Jeff,

You wrote:

Suggestions to Apple and/or Google:

1. Play nice and cut out the Microsoft intermediate step.

2. Apple could fix iCloud so that documents (rather than entire iCloud password sets) can be shared and sync'd, so that I'd not have to use Google Docs for such things.

Apple does not actively monitor these discussions, nor to my knowledge, does Google.

Your best route for a message directly to Apple is via the feedback channel.

Above is the general feedback link. This one is for iCloud feedback.

Regards,

Barry

Reply