How can I export a numbers document to Excel for other people?

Question

Level 1

8 points

How can I export a numbers document to Excel for other people?

How can I export a numbers document to Excel for other people? I have been doing this for years and now others can't open it.

iMac (21.5-inch, Late 2012), OS X Yosemite (10.10.3)

Posted on Jul 24, 2018 3:59 PM

Reply

Answer 1

Jul 24, 2018 4:17 PM in response to mtgalpat

Outside of using the Export To.. option in the File Menu, and choosing Excel, there's no other magic way of doing it.

What issues are they having?

You can try selecting the xls option instead of xlsx in the Format dropdown of the Export Dialog for greater compatibility.

Reply

Answer 2

Jul 24, 2018 5:52 PM in response to mtgalpat

sometimes when you try to export from Numbers to Excel, you don't get the results you expect, especially if you have pop up menus and other Numbers specific features...

what you CAN do instead of converting it to Excel, is ..

1. if they have a Mac, they can run it in Numbers..

2. if they have an iPad or iPhone, they can run it in Numbers for iOS.

3. if they have a PC (windoze) then they can set up a FREE iCloud account and run it in Numbers via iCloud using Chrome or Firefox.

Reply

Answer 3

Jul 25, 2018 12:07 PM in response to mtgalpat

mtgalpat wrote:

This document was exported from Numbers. Each table was converted to an Excel worksheet. All other objects on each Numbers sheet were placed on separate worksheets. Please be aware that formula calculations may differ in Excel.

Your exported data should then be found in one of the other Sheets in Excel.

In Excel if you look at the bottom, you should see a list of sheets and the Export Summary as the first sheet.

Clicking on the secondary sheets there should show the exported data.

Reply

Answer 4

mtgalpat Author

Level 1

8 points

Jul 26, 2018 7:23 PM in response to Phil0124

Phil

I did not have a sheet 1 at the bottom of my page but I click on export summary and clicked on imported apple works date at the top and got it. Now I have to see if the person I am sending it too can it.

Thanks

Pat

Reply

Answer 5

mtgalpat Author

Level 1

8 points

Jul 25, 2018 9:57 AM in response to Barry

1. I have OS High Sierra 10.13.6

2. I can't open the exported document. It look total different than anything I have ever seen. This is what it says

This document was exported from Numbers. Each table was converted to an Excel worksheet. All other objects on each Numbers sheet were placed on separate worksheets. Please be aware that formula calculations may differ in Excel.

3. I have not tried to exporting using other programs since I have been exporting for several years using the mac converter

4. Others can't open the docs. I can send them a pdf but then they can't make changes to it if they need to.

Thanks

Pat

Reply

Answer 6

mtgalpat Author

Level 1

8 points

Jul 26, 2018 4:42 PM in response to Phil0124

This is nothing on the export that sounds like what you are explain. It shows the following


This document was exported from Numbers. Each table was converted to an Excel worksheet. All other objects on each Numbers sheet were placed on separate worksheets. Please be aware that formula calculations may differ in Excel.



Numbers Sheet Name	Numbers Table Name	Excel Worksheet Name

Imported AppleWorks Data - MOUN
	MOUNTAIN GALS Membership 2018-19	Imported AppleWorks Data - MOUN

The only thing that is highlighted is imported from AppleWorks which I haven't used for years. I have exported using numbers since it came out and this is the first problem I have had. Now it does it to all spreadsheets even ones I have done in the past. I keep both copies in my computer and can open the old Excel ones fine. Did they do something new to Excel or Numbers to cause this?

Thanks

Pat

Reply

Answer 7

Jul 26, 2018 6:49 PM in response to mtgalpat

At the very bottom of the Excel App window is the set of sheets.

This is what I get when I export and Numbers file as Excel:

If I click on Sheet 1 there, I can see the data that was exported.

Reply

Answer 8

Jul 27, 2018 7:20 AM in response to mtgalpat

Glad you worked it out. Good luck.

Reply

Answer 9

mtgalpat Author

Level 1

8 points

Jul 28, 2018 10:20 AM in response to Phil0124

Thanks to everyone for your input.

Reply

Answer 10

Barry

Level 9

60,029 points

Jul 24, 2018 4:23 PM in response to mtgalpat

Hi Pat,

What version of Numbers? (Numbers menu > About Numbers)

Your profile information shows your OS X version is 10.10.3 (Yosemite), Is that correct?

Apple menu > About this Mac.

Have you tried reopening the exported document (the one ending .xls or .xlsx) with Numbers? What result do you get?

Have you tried reopening the exported document with LibreOffice, Apache OpenOffice or NeoOffice? What result do you get? (Links go to home page for each of these open source applications. Libre is free to download and use, but does request donations to support future development. The others have both free and charged for packages.

Are 'all' of the 'others' unable to open your exported docs, or 'some' of the 'others'?

Regards,

Barry

Reply

Answer 11

mtgalpat Author

Level 1

8 points

Jul 25, 2018 10:03 AM in response to Phil0124

I get the same looking document when I tried that. It seems to of happened on my latest update to pages.

Thanks

Pat

Reply

How can I export a numbers document to Excel for other people?

Similar questions