Results 1 to 3 of 3

Thread: How to Import more than one XML files in Microsoft Excel

  1. #1
    Join Date
    Jan 2012
    Posts
    23

    How to Import more than one XML files in Microsoft Excel

    I would like to find some statistic of data from multiple XML files using Excel 2007. I want to import all the files in a folder and sub- folder into one EXCEL spreadsheet. Each XML file has the identical structure, but different data. I want to define the XML map in Excel, and import data for each file, with each file's data being on a new row. By the way, it seems that excel does not allow to import many files at once.

  2. #2
    Join Date
    Aug 2011
    Posts
    540

    Re: How to Import more than one XML files in Microsoft Excel

    Actually you can import multiple xml files into Excel (at least I could in 2003). If the files have identical structure create a map from any of them. Then just import the files you want through Data - XML - Import. The files should be located in one folder just select as many as you like.

  3. #3
    Join Date
    Aug 2011
    Posts
    564

    Re: How to Import more than one XML files in Microsoft Excel

    The below links can provide you more detailed information on the same. It is possible to import multiples files in Microsoft Excel without any errors. I will recommend you visit the following link and have a look on the detail mention below. Look under the section Import multiple XML data files.

    Import XML data

Similar Threads

  1. Help me to import more than 65000 records in Microsoft Excel
    By Shard.K in forum MS Office Support
    Replies: 5
    Last Post: 21-02-2012, 07:53 PM
  2. How to import a .xps file in Microsoft Excel 2007
    By The-Farmer in forum MS Office Support
    Replies: 2
    Last Post: 17-01-2012, 01:24 PM
  3. Replies: 5
    Last Post: 13-01-2012, 05:18 PM
  4. How to create .qif files in Microsoft Excel and Import to Quicken
    By Dennis Racket in forum MS Office Support
    Replies: 2
    Last Post: 11-01-2012, 12:46 PM
  5. How to Import CSV files using Macro in Excel
    By Kungfu Pandey in forum Microsoft Project
    Replies: 2
    Last Post: 08-01-2012, 06:37 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,705,973.82071 seconds with 17 queries