.XLK File Extension
Microsoft Excel Backup File
Developer | Microsoft |
Popularity |
3.2 | 10 Votes |
What is an XLK file?
An XLK file is a backup file created by Microsoft Excel, a common spreadsheet application. It contains a backup copy of a file saved in Excel, such as an .XLSX or .XLS spreadsheet, that is utilized to recover data in the event that a file saved by Excel is lost or corrupted.
More Information
Microsoft Excel is a widely-used spreadsheet application that is part of the Microsoft Office suite. It provides a large number of tools for organizing, manipulating, and visualizing data.
When working on spreadsheets with a lot of data it is a good idea to create backups of your data. While Excel provides the AutoRecover feature in case the application crashes, it is important to have backups of your work in case you are no longer able to open the original file or you want to archive the data.
How do I create an XLK backup of a file in Excel?
Excel automatically creates an XLK backup of your file when you save a file in the application with the "Always create backup" option selected. To turn this option on or off in Excel:
- Select Tools → General Options... in the Save As dialog when saving a file
- Check the "Always create backup" option to create the XLK backup file or uncheck it to stop Excel from creating a backup file
- Click OK, choose your save location for the file, and click Save
Excel creates the XLK file in the same location as the location of the file you are saving. However, it does not create the XLK file until you save the original file and it is always one save behind the original file.
Also, Excel names it as Backup of, and then the name of the original file. For example, an XLK backup for a file named Example Spreadsheet.xlsx is named Backup of Example Spreadsheet.xlk.
How to open an XLK file
You can open XLK files with Microsoft Excel in Windows and macOS. To open an XLK file, select File → Open, navigate to the XLK file, and click Open. After opening the file in Excel, you can save it in a different format, such as XLSX, XLS, .XLSM, or .XLSB.
You can also open XLK files with OpenOffice Calc (cross-platform). However, the application may not fully support the formatting of the spreadsheet.