Web queries offer a handy way to import data from selected tables into a worksheet--but Excel isn't as accommodating as it should be, especially when it comes to parameters. These tricks will let ...

Edmond Woychowsky walks you through his process, including all the necessary sample code, to convert an XML file to an Excel spreadsheet.

Highlight the data file and then click "Import" to map the data directly to the spreadsheet under the table information, recreating the XML table within your Excel spreadsheet.