A quick guide to Excel file types.
You have a number of different options when it comes to Excel file types. This quick guide will help you tell your XLXS from your XLSB.
XLS files were phased out about 1,000 years ago and so we're not going to discuss these here. The three main files types you'll need to deal with when saving your model are:
XLSX
This is the default file structure that replaced the old binary .xls format. This format does not support Excel macros. Underlying this format there is a folder of XML documents. This makes this file structure extensible. This means that external applications or programs can manipulate the contents of the underlying XML format, allowing programmers to create software that can edit Excel spreadsheets without ever opening Excel. The XLM file structure are also less susceptible to corruption than binary files.
XLXM
This is the same file structure as XLSX but with macros enabled.
XLXB
These are binary file. They open and save faster than XML based file and take up less space. However, they can have difficulties integrating with non-Excel applications such as Bloomberg or Capital IQ. They also have a higher risk of file corruption.
Experiment.
In this chapter we introduced a macro into the workbook, and we saved the file in XLSB format.
The file was 609 KB in XLSB format.
If we save the same file in XLSM format the file size becomes 732 KB.
Recommendation
If you have macros in your file and do not need to integrate with external apps that require an XML file structure - use XLSB.
Excel file type quick summary
Excel file type | XLSX | XLSM | XLSB |
File format | XML | XML | Binary |
Can store VBA? | No | Yes | Yes |
File size | Larger | Larger | Smaller |
File opening | Slower | Slower | Faster |
Risk of file corruption | Lower | Lower | Higher |
Comments
Sign in or become a Financial Modelling Handbook member to join the conversation.
Just enter your email below to get a log in link.