XML data in Excel

A

aareiner

Version: 2004 Operating System: Mac OS X 10.4 (Tiger) Processor: Intel Is it possible to open XML data files in Excel for Mac?

I have several kml files that have sites with names and, latitude and longitude numbers for each. I would like to have this listing in excel. However, when I try to open the file as an xml file in Excel I get this message

The file you are trying to open is not a valid Excel XML Spreadsheet.

You can open the file as text in Excel.

I know this is true, however, I am expecting it to create a schema and display the data. I have given this file to a friend running a PC version of Excel '03 and it opens fine the data is a bit messy but perfectly usable. On my mac, no such luck.

Suggestions?
 
C

CyberTaz

No suggestions to be offered -- XML is poorly supported in the PC version &
even less in the Mac version... XML Spreadsheets, yes - XML Data files, no.

Regards |:>)
Bob Jones
[MVP] Office:Mac
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Shortcuts in OneDrive 0
Found few bugs in my daily routine of work in excel for MAC 0
Internal Data Integrity (Type 4) Details Needed 1
Found few bugs in my daily routine of work in excel for MAC 0
Embedded Excel into Word with Tables 0
Cell data entering slow! 0
Add additional information to excel form after original data entry 0
Embed the same Excel multiple times 0

Top