Combine XML files and load into excel

  • Status: Closed
  • Prize: $25
  • Entries Received: 23
  • Winner: minametry903

Public Clarification Board

  • BabuPC333
    BabuPC333
    • 2 months ago

    Please see my entry #16 and #17

    • 2 months ago
  • nomilknosugar
    Contest Holder
    • 2 months ago

    Please also comment whether you think this should go into an Excel powerquery data model, or can be a simple excel sheet

    • 2 months ago
    1. minametry903
      minametry903
      • 2 months ago

      You can edit and modify what every you want? All data of the XML file i did convert fully to excel and it could be a good excel one as a source of data for you. I explained to you fully on my entry #9 all the details of the converted file and added one more entry #10 to show you how you can filter and get the data of file. The number of columns in excel are 226 and the number of rows are 100326, some are empty and you can adjust delete or edit what you want, but it was converted from the XML file. You can check my entry and i can do whatever you ask me to do or extract, i worked on excel 12 years

      • 2 months ago
    2. minametry903
      minametry903
      • 2 months ago

      yes it could be power query t get any data you want and you can sort it as you want

      • 2 months ago
  • nomilknosugar
    Contest Holder
    • 2 months ago

    In your response, please show me the total number of fields to go into the excel output.

    • 2 months ago

Top entries from this contest

View More Entries

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!