?
Solved

How do I import XML into Excel 2008 for Mac?

Posted on 2010-01-09
6
Medium Priority
?
3,723 Views
Last Modified: 2012-05-08
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
Comment
Question by:Number5ix
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 1500 total points
ID: 26298988
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
 
LVL 3

Author Comment

by:Number5ix
ID: 26299339
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
 
LVL 3

Author Closing Comment

by:Number5ix
ID: 31675057
Partially accurate as this isn't confirmed but looks like nobody else is going to answer.  Thanks!  :)
0
The Orion Papers

Are you interested in becoming an AWS Certified Solutions Architect?

Discover a new interactive way of training for the exam.

 
LVL 85

Expert Comment

by:Rory Archibald
ID: 26299368
Nope - the stupidest one was the "well, no-one really uses VBA so we'll just leave it out of 2008" one... :)
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 26299373
PS Yes, I know it was actually down to time constraints!
0
 
LVL 3

Author Comment

by:Number5ix
ID: 26299419
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

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question