Switch to full style
Discussions about Coollector.
Post a reply

Export to Excel on a Mac

Thu Oct 23, 2014 6:08 pm

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?

Re: Export to Excel on a Mac

Thu Oct 23, 2014 8:01 pm

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

Re: Export to Excel on a Mac

Fri Oct 24, 2014 4:26 am

That web page is for Excel on a Windows computer. I'm using OpenOffice on a Mac.

Re: Export to Excel on a Mac

Fri Oct 24, 2014 9:31 am

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.

Re: Export to Excel on a Mac

Fri Oct 24, 2014 3:25 pm

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

Re: Export to Excel on a Mac

Fri Oct 24, 2014 3:37 pm

Avroman00 wrote:I just figured it out.

Cool :D

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