coollector.com
https://www.coollector.com/

Export to Excel on a Mac
https://www.coollector.com/viewtopic.php?f=1&t=1411
Page 1 of 1

Author:  Avroman00 [ Thu Oct 23, 2014 6:08 pm ]
Post subject:  Export to Excel on a Mac

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?

Author:  (cool) Hector [ Thu Oct 23, 2014 8:01 pm ]
Post subject:  Re: Export to Excel on a Mac

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

Author:  Avroman00 [ Fri Oct 24, 2014 4:26 am ]
Post subject:  Re: Export to Excel on a Mac

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

Author:  (cool) Hector [ Fri Oct 24, 2014 9:31 am ]
Post subject:  Re: Export to Excel on a Mac

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.

Author:  Avroman00 [ Fri Oct 24, 2014 3:25 pm ]
Post subject:  Re: Export to Excel on a Mac

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

Author:  (cool) Hector [ Fri Oct 24, 2014 3:37 pm ]
Post subject:  Re: Export to Excel on a Mac

Avroman00 wrote:
I just figured it out.

Cool :D

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

Page 1 of 1 All times are UTC + 1 hour [ DST ]
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/