+ Reply to Thread
Results 1 to 6 of 6

Importing multiple XML files in one go

  1. #1
    Registered User
    Join Date
    01-08-2018
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    9

    Importing multiple XML files in one go

    Hi there

    Ive just started using Excel 2016 and I am much impressed with it so far but I'm in need of some help and advice.

    I have an epos system that allows me to export all of our shop sales using XML format. I want to be able to import all our sales month by month and use a pivot table to show the data to see any trends etc.

    What I have done for the first year of sales is to export the sales month by month from the till to an XML file then import each file one at a time into a different workbook then copy+paste the data to a workbook that will hold all the years data.

    I have found that if I try to add another XML file to the first one it overwrites the first import, that is why I use a new workbook for each import.

    What I want to be able to do is append each import of data to the previous one, or import all 12 files at once. Is there a way to do this?

    Thank you

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Old Country
    MS-Off Ver
    PC: 5F / 61 / 7E0 (PQ/PP)
    Posts
    8,240

    Re: Importing multiple XML files in one go

    Maybe try: New Query - From Folder (where XML files are)
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Excel can do everything but still doesn't read user's wishful thinking
    The ready made solution will not teach anyone anything
    A logical description of the problem is the basis of dialogue and a rapid solution. Nobody sits in your head to understand your way of thinking

  3. #3
    Registered User
    Join Date
    01-08-2018
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    9

    Re: Importing multiple XML files in one go

    Thank you.

    I'm unable to select more than one file.

  4. #4
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Old Country
    MS-Off Ver
    PC: 5F / 61 / 7E0 (PQ/PP)
    Posts
    8,240

    Re: Importing multiple XML files in one go

    Put all xmls into one folder then try Data -NewQuery - From File - From folder (not from file). Excel should be able to import all files from this foilder by itself

    you should see something like this

    xmlfiles.jpg

    then something like this:

    binary.jpg

    all depends of what your xmls contain
    Last edited by sandy666; 02-13-2018 at 02:58 PM.

  5. #5
    Registered User
    Join Date
    01-08-2018
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    9

    Re: Importing multiple XML files in one go

    Thanks sandy666. I didn't see the folder option first time round. All imported now.

  6. #6
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Old Country
    MS-Off Ver
    PC: 5F / 61 / 7E0 (PQ/PP)
    Posts
    8,240

    Re: Importing multiple XML files in one go

    You are welcome

    so...
    If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
    then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
    If you did it already - ignore it.
    Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1