Its widely used across the web and in many apps and software.Excel has support for XML files and its actually really easy to import and covert them to tables using power query.
You can open any of the XML files in your text editor of choice to view the inner workings of an Excel file. Most websites have a sitemap.xml file which is an XML file of the websites link structure. This is literally a map of the website for bots like Google to crawl and index. It lists all the pages on the site and includes information about when the page was last updated, how often the page is updated and how much weight search engines should give that page. Notice that its in a nice table format Thats automatically done by power query. For example, the Name field contains a First and Last field for the first and last names of the person. If our data had a simple structure without any sub-fields, we could skip the query editor and press the Load button to directly load the data into the workbook. Depending on the data structure, we may need to do this several times. Youre likely to come across it sooner or later if you work with data. Maybe there is some sort of non-printing character that is delimiting the data If so, you can use power query to split by delimiter. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |