Avroman00 wrote:
I just figured it out.
Cool
I'm a bit surprised that it's so complex
| 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 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/ |
|