It is currently Fri Nov 24, 2017 8:38 pm

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 6 posts ] 
Author Message
 Post subject: Export to Excel on a Mac
PostPosted: Thu Oct 23, 2014 6:08 pm 
Offline

Joined: Wed Oct 22, 2014 3:22 pm
Posts: 8
Just wondering if there is a way to export my owned movies to a file I can open with Excel in OpenOffice on my Mac? I exported the list as XML, TXT and JSON. Non of them will open in Excel. How can I print a list of my owned movies in columns with the selected fields?


Top
 Profile  
 
 Post subject: Re: Export to Excel on a Mac
PostPosted: Thu Oct 23, 2014 8:01 pm 
Offline
User avatar

Joined: Tue Sep 27, 2005 2:28 am
Posts: 5863
I haven't used Excel in years, but I'm surprised that you can't import from XML. In my mind, it's a fundamental.

If I search for "excel import xml" on Google, I get many results...

What about this one?

http://office.microsoft.com/en-au/excel-help/import-xml-data-HP010206405.aspx#BMimport_an_xml_file_into_existing_mapp


Top
 Profile  
 
 Post subject: Re: Export to Excel on a Mac
PostPosted: Fri Oct 24, 2014 4:26 am 
Offline

Joined: Wed Oct 22, 2014 3:22 pm
Posts: 8
That web page is for Excel on a Windows computer. I'm using OpenOffice on a Mac.


Top
 Profile  
 
 Post subject: Re: Export to Excel on a Mac
PostPosted: Fri Oct 24, 2014 9:31 am 
Offline
User avatar

Joined: Tue Sep 27, 2005 2:28 am
Posts: 5863
I thought it would be very similar on a Mac, but if it's not the case, you just have to add "mac" to your Google search.

I won't teach you how to use Excel as I don't use it myself. But there's no doubt that Excel can import XML.


Top
 Profile  
 
 Post subject: Re: Export to Excel on a Mac
PostPosted: Fri Oct 24, 2014 3:25 pm 
Offline

Joined: Wed Oct 22, 2014 3:22 pm
Posts: 8
I just figured it out. OpenOffice on a Mac has a spreadsheet application built in called Calc. It is not Excel. It does open and save .xls files though. OpenOffice does not open or import xml files. I had to convert the xml file to xls first, then OpenOffice will open it. The following website converts the file online:

http://www.luxonsoftware.com/converter/xmltoexcel


Top
 Profile  
 
 Post subject: Re: Export to Excel on a Mac
PostPosted: Fri Oct 24, 2014 3:37 pm 
Offline
User avatar

Joined: Tue Sep 27, 2005 2:28 am
Posts: 5863
Avroman00 wrote:
I just figured it out.

Cool :D

I'm a bit surprised that it's so complex :?


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  


Powered by phpBB © 2017 phpBB Group