XL File Documentation

Overview

Feature Value
File Extension .xlsx
MIME Type application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Developed by Microsoft
Format Type Binary/Zip
Latest Version Excel 2019/Office 365
Open Format Yes (Office Open XML)
Primary Use Spreadsheets, Data Analysis, and Charting
Compression ZIP-compressed XML files
Encryption Supported (password protection)
Macro-Enabled Format .xlsm
Compatibility Backward compatible with older versions via conversion
Mobile Support Yes
Cloud Integration Yes (OneDrive, SharePoint)
Maximum Rows per Sheet 1,048,576
Maximum Columns per Sheet 16,384 (Column XFD)
Formulas and Functions Supported
Data Types Text, Number, Date, Time, etc.
Collaboration Supported via SharePoint and Excel for the web
Visual Basic for Applications (VBA) Supported
Charts and Graphs Extensive variety available
PivotTables Supported