Getting complete control of your files at any time is important to relieve your everyday tasks and boost your efficiency. Achieve any goal with DocHub features for papers management and convenient PDF editing. Gain access, adjust and save and incorporate your workflows along with other protected cloud storage services.
DocHub offers you lossless editing, the chance to work with any format, and securely eSign papers without looking for a third-party eSignature alternative. Obtain the most of the file management solutions in one place. Consider all DocHub features today with the free profile.
hey guys this is John with how to excel org and in this video were gonna take a look at importing xml data into excel and then formatting it as a table and were going to be using power query to do all this so xml data is a pretty common type of data across the web and different applications and so as an example of xml actually if you take any excel file you can see that its actually made up of a bunch of different xml files so you can see that by editing the file and if you just first of all im just gonna make copy of this so I dont accidentally screw it up if you change the extension of your excel file to a dot zip file escape so enter and yes I definitely want to change it now if you navigate into that zip folder youre gonna see some various different folders and most of what youre gonna see is dot XML extensions so files that are XML files so so lets try opening one of these up and see whats in there and as you can see its just a txt text data in a certain format so were