Forum Discussion

Copper Contributor

Mar 08, 2021

Refresh the XML Mapping of a Folder

Hello everyone, Currently I have a mapped table where all my XML forms are gathered, however I would like Excel to automatically import this data to me without having to click on the "import" cli...

Charting

developer

excel

Formulas and Functions

Macros and VBA

office 365

NikolinoDE

Platinum Contributor

Mar 08, 2021

Import XML Files into Excel
https://www.howtoexcel.org/power-query/import-xml-files/

Just a info to help 🙂

Remi131765
Copper Contributor
Mar 08, 2021
NikolinoDEthank you for your answer.
However it seems to me that this import method via Power Query only allows you to select a single XML file while my objective would be to bring all my new XML files back to my table from an actualization.
- NikolinoDE
  Platinum Contributor
  Mar 08, 2021
  Remi131765
  Other ways to import XML data
  Import an XML data file as an XML table
  Import multiple XML data files
  Import multiple XML data files as external data
  Open an XML data file to import its data
  For more information about issues, see Common issues with importing XML data at the end of this article.
  
  I would be happy to know if I could help.
  
  Nikolino
  I know I don't know anything (Socrates)
  - Remi131765
    Copper Contributor
    Mar 15, 2021
    Hello NikolinoDE,
    
    Thanks for your answer but we don't know how it is possible to refresh an XML file folder
    
    Remi