import XML

Question

Purchased Office 2016.  Can't find the import XML feature (PC has it).  Am I missing something?  I can open the XML file but it opens it in text format which isn't helpful.   I want the data import feature for an XML file.

Answer 1

No version of Mac Excel has the XML tools available in the Windows versions... Excel for Mac can open files saved as XML Spreadsheet files but not XML Data files.

The simplest solution is to open the file using a Windows version of Excel then Save As in any of the file types common to both Win/Mac Excel [.xlsx, .xlsm, .csv, Excel 2003/2004 XML Spreadsheet, etc.].

Answer 2

Can't be done with Office for Mac...the feature has been explicitly excluded.  Either run a Windows VM with the PC version of MS Office installed or keep a PC around for this type of work...or mooch off of a friend ;)

Answer 3

This page has a work-around.  It appears that if you save a workbook as an XML workbook and fiddle with the saved XML code a bit you can fool Excel into thinking it wrote the XML

http://www.techrepublic.com/article/convert-an-xml-file-into-an-excel-spreadsheet-with-this-technique/

Answer 4

Exactly.  None of those options handle XML properly.

Answer 5

Clicking on Import in Excel 2016 results in this which is all the types Office 2016 Mac can import:

On 2011 Excel it's:

_________

Disclaimer:

The questions, discussions, opinions, replies & answers I create, are solely mine and mine alone, and do not reflect upon my position as a Community Moderator.