XLTM - Excel Open XML Macro-Enabled Spreadsheet Template

Last modified by Kashif Iqbal on 2019/06/11 12:41

The XLTM file extension represents files that are generated by Microsoft Excel as Macro-enabled template files. XLTM files are similar to XLTX in structure other than that the later doesn't support creating template files with macros. Such template files are used to generate and set the layout, formatting, and other settings along with the macros to facilitate creating similar XLSX files then.

Brief History

It was in the early 2000 when Microsoft decided to go for the change to accommodate the standard for Office Open XML. Documents, of different types, under this new Standard were identified by appending "X" in their extensions, where "X" being for XML. By 2007, this new file format became part of Office 2007 and is carried on in the new versions of Microsoft Office as well. The new file type has added advantages of small file sizes, less changes of corruption and well formatted images representation.

XLTM File Format Specifications

XLTM files are based on the Office OpenXML file format and use XML and ZIP to reduce file size.  These can be opened with Microsoft Excel by double clicking the file. The files organization in an XLTM file format can be observed by renaming the  file to ZIP and then extracting its contents to disc. 

[Content_Types].xml

This is the only file that is found at the base level when the zip is extracted. It lists the content types for parts within the package. All references to the XML files included in the package are referenced in this XML file.

_rels (Folder)

This is the Relationships folder that contains a single XML file that stores the package-level relationships. Links to the key parts of the Xltx files are contained in this file as URIs. These URIs identify the type of relationship of each key part to the package. This includes the relationship to primary office document located as xl/workbook.xml and other parts within docProps as core adn extended properties.

docProps

This folder contains the overall document properties. These include a set of core properties, a set of extended or application-specific properties and a thumbnail preview of the document. A blank workbook has two files in this folder namely app.xml and core.xml. The core.xml contains information like author, date created and saved, and modified. App.xml contains information about the content of the file.

xl (Folder)

This is the main folder that contains all the details about the contents of the workbook. By default, it has following folders:

  • _rels
  • theme
  • worksheets

and following xml files:

  • styles.xml
  • workbook.xml

References

Created by Farooq Sheikh on 2019/05/28 08:08