Pros and cons of .XLSX files.
So now you know what .XLSX files are and their uses. But before you decide to use one for your next project, it may be helpful to weigh out some of the pros and cons of this file type below.
- Smaller file size. XLSX files are much smaller in comparison to their older counterparts. Their smaller file size means that XLSX files take up less space on hard-drives and are much quicker to transfer between devices.
- Password protection. If you want to safeguard your data, you can protect your .XLSX files with a password. This will stop anyone from being able to open, view and edit your .XLSX files unless they know the password.
- Easy to use. You can easily make changes to .XLSX files and save them without losing any data.
- Not supported on older versions of Microsoft. If you’re still using an edition of Microsoft that’s older than 2007, you won’t be able to open an .XLSX file.
- Does not support macros. .XLSX files cannot save Macros. To include macros, you’ll need to save your spreadsheet in the ‘Excel-Macro-Enabled Workbook’ (.XLSM) format instead.
- Slower than older formats. Although XLSX is Microsoft’s latest file format, it can be slower than older formats, especially if the file contains large amounts of data.
Need to covert an Excel file to PDF?
Whether you need to transform your sales spreadsheet into a client-ready presentation slide or create a user-friendly document of a table of instructions for your team, you can easily covert your Excel file to a PDF with Adobe’s free Convert Excel to PDF tool.
Similarly, you can also convert a PDF into an Excel if you need to, using the same tool.
How to open an .XLSX file.
The easiest way to open an .XLSX file is with Microsoft Excel, available in both Windows and macOS. Excel is also available for Android and iOS. But again, just make sure you’re using version 2007 or higher, otherwise you won’t be able to open the file.
To open an .XLSX file with Microsoft Excel, simply:
- Double click the file. If you already have a compatible version of Excel install on your device, the file will open automatically.
- Alternatively: Drag and drop the file. if you already have Excel open, you can drag the .XLSX file into the spreadsheet.
- Click ‘open with Excel’. If you double-click the file and it won’t open, right-click on the file and select the Open With option, then choose Microsoft Excel.
How to create, read and edit an .XLSX file.
You can use Microsoft Excel to create, read and edit an .XLSX file. But if you don’t have Microsoft Excel install on your device or you’d rather edit your file in the cloud, Google Sheets is a great alternative. Google Sheets is fully compatible with the .XLSX format and the best part is, it’s entirely free to use. In addition to the web-based version, Google Sheets is also available for Android and iOS.
What’s the difference between an .XLS and an .XLSX file?
.XLS and .XLSX are both file extensions created by Microsoft Excel, used for storing spreadsheet data. However, .XLSX is the default file format for Excel version 2007 or higher, while .XLS is the default file format for older versions of Excel. Additionally, .XLSX files save in the open .xml format, which stores data as separate files under a compressed Zip folder. Whereas XLS files store data in a single binary file. .XLS is also a proprietary file format, while .XLSX is open and royalty-free.
Learn more about similar file types to .XLSX.
Introduced by Microsoft in 1987 with the release of Excel, explore the previous spreadsheet file format.
Discover more about the generic data file that contains information relating to the programme that created it.
Learn more about the word processing document created by Microsoft Word.
Find out everything you need to know about the HTML web file that is widely used online.