Spreadsheet File Formats

Last modified by Farooq Sheikh on 2019/07/17 07:55

A spreadsheet file contains data in the form of rows and columns. You can open, view and edit such files using spreadsheet software applications such as Microsoft Excel that is now available for both Windows and MacOS operating system. Similarly, Google sheets is a free online spreadsheet creating and editing tool that works from any web browser. A spreadsheet file can be saved in several different file formats, each having a different file extension for unique representation. Data is stored in cells either in plain form such as text string, numbers, date, currency, etc. or as formulas that change a cell's value when referenced cell values change.

Common spreadsheet file extensions and their file formats include XLSX (Microsoft Excel Open XML Spreadsheet), ODS (OpenDocument Spreadsheet) and XLS (Microsoft Excel Binary File Format). 

Supported Formats of Spreadsheets

Following is a list of common spreadsheet file formats along with their file extensions.

File ExtensionFile Format
CSVComma Separated Values File
DIFMicrosoft Data Interchange Format
ODSOpenDocument Spreadsheet
OTSOpenDocument Spreadsheet Template
TSVTab Separated Values File
XLMMicrosoft Excel Macro File
XLSMicrosoft Excel Binary File Format
XLSBMicrosoft Excel Binary Spreadsheet File
XLSMMicrosoft Excel Open XML Macro-Enabled Spreadsheet
XLSXMicrosoft Excel Open XML Spreadsheet
XLTMicrosoft Excel Template File
XLTMMicrosoft Excel Open XML Macro-Enabled Spreadsheet Template
XLTXMicrosoft Excel Open XML Spreadsheet Template

List of Spreadsheet Software

Several applications are available to open, edit and view these formats including:

  • Microsoft Excel
  • NeoOffice
  • LibreOffice
  • Google Sheets

Got queries related to Spreadsheet file formats? Head on to our community forums to benefit from the knowledge shared by File Format experts. 

Created by Farooq Sheikh on 2019/07/10 12:52