Importing XML data into Excel

Posted on 2009-02-10
Last Modified: 2012-06-27
Hi there,

I am having difficulties importing XML data into excel in one go.

There are around 25000 records and 30 columns, howver when I try to import the data in one go i get the below error:

no data was imported or only some of the data was imported

To overcome this i break the xml file into roughly half the size and import this into excel without any problems. Is there any way i can actually import all the xml data in one go as there will always be 25000 or less records and 30 columns.



Question by:bhups23
    1 Comment
    LVL 74

    Accepted Solution

    Can you post the XML that does not work, and the XML that does work, for comparison purposes?

    Another option would be to import the XML data to MS Access first, then export from Access to Excel.


    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    This very simple solution applies to a narrow cross-section of the "needs to close" variety. In this case, the full message in Event Viewer was in applog, Event ID 1000: Faulting application iexplore.exe, version 8.0.6001.18702, faulting module …
    Article by: Leon
    Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

    732 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

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now