Go Back   MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Reply
 
Thread Tools Search this Thread Display Modes
Old May 18, 2009, 12:36 PM   #1
Sir Loin Steak
macrumors 6502
 
Join Date: Feb 2009
Location: England
How to convert Numbers into .xls files?

This is killing me...

I have these Numbers files but need to send them to someone who is using a pc with MS Excel. She won't be able to read the files if they are left as .numbers.

The odd thing is that I have successfully saved some of the files as .xls and .xls.xls and even some as .xls.numbers.

However, I have lost data when doing some of these savings - I have been taking the .numbers file and trying to save it as .xls but when I open the newly-saved file there's nothing there.

Please look at the attached snapshot of my folder structure. Can you anything in there that might be causing my problem? The red arrows are just to highlight the ones I'm particularly interested in.

tia.
Attached Thumbnails
Click image for larger version

Name:	Picture 4.png
Views:	445
Size:	78.3 KB
ID:	171523  
__________________
April 2009 24" iMac3.06GHZ, 4GB RAM, ATI RADEON HD 4850 512MB 1.0TB SERIAL ATA DRIVE WIRELESS MIGHTY MOUSE-Z
Classic 120GB iPod (2009)
Sir Loin Steak is offline   0 Reply With Quote
Old May 18, 2009, 12:49 PM   #2
snberk103
macrumors 603
 
Join Date: Oct 2007
Location: An Island in the Salish Sea
How are you "saving as"? Which version of Numbers are you using '09, or '08?

In the '09 version to save as XLS you "export". There are two ways to export. On the menu bar (at the very top of your monitor) there is a "Share" option. Choose that then Export. Or, File, then Export.

Try that and see if does what you want.

Good Luck
snberk103 is offline   0 Reply With Quote
Old May 18, 2009, 03:28 PM   #3
Sir Loin Steak
Thread Starter
macrumors 6502
 
Join Date: Feb 2009
Location: England
Hi

I'm using '09 Numbers.

I have tried the two ways you suggest to Export - in fact using the export method I get these files as pdfs which, although they give the information, it doesn't appear to be in a format that could be manipulated.

On the other hand, using the Share method, I have been able to send the file and the file appears to be an intact Excel file. I have to wait until my friend replies to see if it's any good for her. I have Excel on my old xp laptop, but getting files on to it isn't too straight forward right now, but otherwise I would check it myself.

Anyway, I think you're onto the solution, thank you. I need to see if I can send a folder of Numbers sheets in this Share manner.

__________________
April 2009 24" iMac3.06GHZ, 4GB RAM, ATI RADEON HD 4850 512MB 1.0TB SERIAL ATA DRIVE WIRELESS MIGHTY MOUSE-Z
Classic 120GB iPod (2009)
Sir Loin Steak is offline   0 Reply With Quote
Old May 18, 2009, 03:38 PM   #4
Sir Loin Steak
Thread Starter
macrumors 6502
 
Join Date: Feb 2009
Location: England
Hmm, using the Share method seems to strip everything out of the sheet.
Attached Thumbnails
Click image for larger version

Name:	Picture 5.png
Views:	236
Size:	34.5 KB
ID:	171550  
__________________
April 2009 24" iMac3.06GHZ, 4GB RAM, ATI RADEON HD 4850 512MB 1.0TB SERIAL ATA DRIVE WIRELESS MIGHTY MOUSE-Z
Classic 120GB iPod (2009)
Sir Loin Steak is offline   0 Reply With Quote
Old May 18, 2009, 03:45 PM   #5
dejo
Moderator
 
dejo's Avatar
 
Join Date: Sep 2004
Location: The Centennial State
File > Export..., click on the Excel tab, Next...
__________________
dejo is offline   0 Reply With Quote
Old May 18, 2009, 03:47 PM   #6
Sir Loin Steak
Thread Starter
macrumors 6502
 
Join Date: Feb 2009
Location: England
Got you on choosing Excel, I choses pdf by mistake.
__________________
April 2009 24" iMac3.06GHZ, 4GB RAM, ATI RADEON HD 4850 512MB 1.0TB SERIAL ATA DRIVE WIRELESS MIGHTY MOUSE-Z
Classic 120GB iPod (2009)
Sir Loin Steak is offline   0 Reply With Quote
Old May 18, 2009, 03:50 PM   #7
dejo
Moderator
 
dejo's Avatar
 
Join Date: Sep 2004
Location: The Centennial State
Quote:
Originally Posted by Sir Loin Steak View Post
Got you on choosing Excel, I choses pdf by mistake.
That would explain why you were getting PDFs then, eh?
__________________
dejo is offline   0 Reply With Quote
Old May 18, 2009, 03:56 PM   #8
Sir Loin Steak
Thread Starter
macrumors 6502
 
Join Date: Feb 2009
Location: England
There's a hint of daftness when I'm involved!
__________________
April 2009 24" iMac3.06GHZ, 4GB RAM, ATI RADEON HD 4850 512MB 1.0TB SERIAL ATA DRIVE WIRELESS MIGHTY MOUSE-Z
Classic 120GB iPod (2009)
Sir Loin Steak is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
.XLS files on iphone/ipad ? jigsb007 iPhone and iPod touch Apps 2 Nov 13, 2013 02:06 PM
Missing Numbers Files after Mavericks Update coloradostevep OS X Mavericks (10.9) 0 Nov 3, 2013 11:49 AM
highlight on .xls files JustOneQuickONe iPad Apps 0 Feb 7, 2013 02:56 AM

Forum Jump

All times are GMT -5. The time now is 01:33 AM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps