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.
This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread.
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.].
As an MVP my contributions here are purely voluntary.
Please mark Yes/No as to whether a Reply answers your question.
Regards, Bob J.
21 people were helped by this reply
Did this solve your problem?
Sorry this didn't help.
Great! Thanks for marking this as the answer.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.