Refresh the XML Mapping of a Folder

New Contributor

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" click.

Is it then possible to update an XML mapping without necessarily importing?


Thank you in advance for your feedback,




6 Replies
Import XML Files into Excel

Just a info to help

@Nikolinothank 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.


Other ways to import XML 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.



I know I don't know anything (Socrates)

Hello @Nikolino,

Thanks for your answer but we don't know how it is possible to refresh an XML file folder




Refresh an external data connection in Excel

You can keep the data in your workbook up to date by "refreshing" the link to its source. Each time you refresh the connection, you see the most recent data, including anything that's new or has been deleted.

Security Note: Connections to external data may be currently disabled on your computer. To refresh the data when you open a workbook, you must enable the data connections by using the Trust Center bar, or you must place the workbook in a trusted location. For more information, see Add, remove, or modify a trusted location for your files, Add, remove, or view a trusted publisher, and View my options and settings in the Trust Center.


Click the heading for more information.


Thank you for your understanding and patience




I know I don't know anything (Socrates)



First of all I'm sorry for the response time. I have consulted your links and everything seems ok to me, however I cannot update (see the photo).


I tell myself that maybe the problem comes from my files because they are in .xdp format and not .xml as Excel would like.

In this case, is it not possible to obtain data from a Folder that only takes into account .xdp files?




Thank you