There are 8 file extensions supported by Microsoft Excel for Mac in our database. In the further part of this page, you will find detail information about all the Microsoft Excel for Mac with their brief description and a list of file extensions supported by Microsoft Excel for Mac. If you use Microsoft Excel on your Mac, you can save the spreadsheets you create and open them in Numbers, Apple’s spreadsheet app. It’s a handy feature to use in case you can’t access. In Office 2011 for Mac, Excel can try to load tables from a Web page directly from the Internet via a Web query process. A Web query is simple: It’s just a Web-page address saved as a text file, using the.iqy, rather than.txt, file extension. You use Word to save a text file that contains just a hyperlink and has a.iqy file extension.
You expect Excel for Mac 2011 to open Excel files, of course, but the program can do more than that. You can actually open, work on, and save a file in several formats. Choose File→Save As and then click Format to open the pop-up menu. Excel can open and save in the formats listed in this Format pop-up menu.
You have several options for file formats besides Excel’s default (.xlsx) format:
Excel Template (.xltx): Saves the workbook as a template, which you can open in the My Templates section of the Excel Workbook Gallery. You can also open templates by choosing File→Open and selecting Excel Templates from the Enable pop-up menu. This format does not have macros and is another open XML format.
Excel Macro-Enabled Workbook (.xlsm): Workbooks in this XML format contain Visual Basic for Applications (VBA) programming language code, or Excel 4.0 macro code. When opening this format file, Excel displays a prompt asking whether you want to remove the macros contained in the file. The default is Disable Macros. You must instead click Enable Macros if you want macros to run.
Excel Macro-Enabled Template (.xltm): The same as .xlsm, except this is a template. The macro warning dialog displays when you open a workbook in this format, and you must click Enable Macros if you want macros to run.
Excel Add-In (.xlam): Saves a macro-enabled workbook as an Excel add-in.
Excel Binary Workbook (.xlsb): This is the most compact file format, and is recommended for large files. This format doesn’t conform to open source standards.
Comma Separated Values (.csv): Saves a worksheet data table as text separated by commas. This format is text only. All other content is discarded.
Web Page (.htm): Save the workbook in a format that Web browsers understand and can display. Excel creates a file in HTML format, along with a supporting folder. Upload both the file and folder to a Web server if you want to share your workbook via the Internet.
Excel can open and save Web pages in HTML (HyperText Markup Language) format and do great things with Web tables and data from the Web, but don’t uninstall your HTML (Web page) code editor. Excel can’t replace that.
Excel For My Mac
Version (as of 8/1/2019) | 2019 |
Platform | |
License | Commercial |
Category | Productivity |
Rating: |
Software Overview
Mac Excel 2011
Main Features
- Industry-standard, widely used spreadsheet program
- Basic and advanced data manipulation
- PivotTables for summarizing data
- Support for large data sets
- Can import and export data in many different formats
- Complex mathematical formula support
- Advanced support for VBScript scripting
- Sparklines for detecting data trends
- Improved functions and charts
Microsoft Excel for Mac is a widely used spreadsheet program that is part of the Microsoft Office suite. It allows you to organize, analyze, manipulate, and visualize data.
Excel provides workbooks that are divided by tabbed worksheets that can be edited independently. Contained within each worksheet is a grid of cells, which can be formatted in a variety of ways. Excel allows you to perform basic tasks, such as sorting data and creating simple formulas. The program also comes with advanced capabilities, such as Sparklines for detecting trends within your data, VBScript macro scripting, and PivotTables for summarizing your data. Excel saves workbooks in the Office Open XML (OOXML) .XLSX format, while still supporting the older .XLS format.
The spreadsheet application provides thousands of online templates that are available for download within the user interface. This gives users many different options for out-of-the-box styling, formatting, and mathematical computation, allowing them to focus on the data rather than extensive amounts of time on presentation. For example, financial templates can be downloaded by home or business users for tracking income, expenses, and transactions, as well as for automatically generating summary graphs. Excel also provides rich tools for visualizing data such as bar charts, line graphs, pie charts, and scatter plots, as well as more complex ones for more in-depth analysis.
Excel is a great program for managing your data. It provides advanced data organization and analysis tools and is an industry-standard spreadsheet program. Microsoft Excel for Mac is a great choice for organizing, analyzing, manipulating, and visualizing your data.
Supported File Types
Primary file extension
Other file extensions used by Microsoft Excel for Mac 2019
Supported File Types | |
---|---|
.CRTX | Office 2007 Chart Template File |
.CSV | Comma Separated Values File |
.DQY | Excel Query File |
.EFTX | Office 2007 Theme Effect File |
.MHT | MHTML Web Archive |
.MHTML | MIME HTML File |
.ODC | Office Data Connection File |
.ODS | OpenDocument Spreadsheet |
.PRN | Lotus 1-2-3 Formatted Text File |
.SLK | Symbolic Link File |
.THMX | Office 2007 Theme File |
.TSV | Tab Separated Values File |
.UDCX | Universal Data Connection File |
.UDF | Excel User Defined Function |
.XL | Excel Spreadsheet |
.XLA | Excel Add-In File |
.XLAM | Excel Open XML Macro-Enabled Add-In |
.XLB | Excel Toolbars File |
.XLC | Excel Chart |
.XLK | Excel Backup File |
.XLL | Excel Add-In File |
.XLM | Excel Macro |
.XLR | Works Spreadsheet |
.XLS | Excel Spreadsheet |
.XLSB | Excel Binary Spreadsheet |
.XLSHTML | Microsoft Excel HTML Spreadsheet |
.XLSM | Excel Open XML Macro-Enabled Spreadsheet |
.XLSMHTML | Microsoft Excel MIME HTML Spreadsheet |
.XLT | Excel Template |
.XLTHTML | Microsoft Excel HTML Spreadsheet Template |
.XLTM | Excel Open XML Macro-Enabled Spreadsheet Template |
.XLTX | Excel Open XML Spreadsheet Template |
.XLV | Excel Visual Basic Module |
.XLW | Excel Workspace File |
.XML | XML File |
Additional Related File Formats | |
---|---|
.DATA | Analysis Studio Offline Data File |
.DBF | Database File |
.DEL | Delimited ASCII File |
.DEX | Excel Spreadsheet |
.DIF | Data Interchange Format |
.DOC | Microsoft Word Document |
.GRA | Microsoft Graph File |
.HTM | Hypertext Markup Language File |
.IIF | Intuit Interchange Format File |
.IQY | Internet Query |
.OLB | OLE Object Library |
.RDF | Report Definition File |
.RELS | Open Office XML Relationships File |
.RLE | Run Length Encoded Bitmap |
.SKV | Semicolon Separated Values File |
.TAB | Tab Separated Data File |
.TDL | Tab Delineated Format File |
.TSV | Tab Separated Values File |
.TXT | Plain Text File |
.WK1 | Lotus Worksheet |
.WK2 | Lotus 2 Worksheet |
.WK3 | Lotus 3 Worksheet |
.WK4 | Lotus 4 Worksheet |
.WK5 | Lotus 5 Worksheet |
.WKS | Lotus 1-2-3 Spreadsheet |
.WKS | Works Spreadsheet |
.WQ1 | Quattro Pro for DOS Spreadsheet File |
.XLW | Excel Workbook |
Updated: August 1, 2019