Excel binary files

Since the release of Excel 2007 it has been storing data as an XML file. This is a good practice if we want to exchange spreadsheets between different platforms, or even operating systems, but when it comes to complex calculations, which contain hundreds of thousands of rows, such documents can take up a lot of disk space. This can be overcome by saving with the use of the XSLB extension. You can read about the advantages and disadvantages of this approach in the text that follows.

Import of XML files

Excel has previously offered possibility to import XML files, but it was a rather tedious process because it was necessary to join the corresponding XML schema with the file. Although by definition it is simple, it often happened that my success, and others’ failure, could only be explained by the words: “Excel loves me and does not love you”. You will admit, this is not a fair explanation. Power Query maximally simplified this operation!