• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3788
  • Last Modified:

How do I import XML into Excel 2008 for Mac?

Hi all,

Hopefully I'm blind because I can't see an obvious way of importing an XML file into Excel 2009 for Mac.

In Excel 2003/2007 for Windows it's easy but not in Excel 2008 for Mac.

Can anyone help?  The XML file is a .GPX file from geocaching.com but it's well-formatted so I know there are no problems with the file itself.

Thanks!
0
Number5ix
Asked:
Number5ix
  • 3
  • 3
1 Solution
 
Rory ArchibaldCommented:
AFAIK, there is nothing in Excel 2008 for importing XML files unfortunately. Last I heard (Excel 2004) the MacExcel BU didn't see it as a real need...
0
 
Number5ixAuthor Commented:
Wow, you gotta be kidding me.  If the decision was made to not add that functionality because there's no real need then that's the stupidest decision I've ever heard - it's an analysis product and a large amount of data these days is in XML format.

Thanks for your answer though, points to you simply for taking the time to answer.  :)
0
 
Number5ixAuthor Commented:
Partially accurate as this isn't confirmed but looks like nobody else is going to answer.  Thanks!  :)
0
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 
Rory ArchibaldCommented:
Nope - the stupidest one was the "well, no-one really uses VBA so we'll just leave it out of 2008" one... :)
0
 
Rory ArchibaldCommented:
PS Yes, I know it was actually down to time constraints!
0
 
Number5ixAuthor Commented:
I'm just shocked really.  Time constraints is such a stupid reason to leave 2 *critical* features of Excel.  How can analyse data properly if you can't even get the data into Excel in the first place?

Although this discussion is about using Office on a Mac this is why I switched to Mac in the first place ...
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now