Skip to content

Convert WKS to XLSM

How to convert WKS spreadsheet files to XLSM for use in modern Excel with macro support.

Convert WKS files online

We don’t have a dedicated online converter for WKS to XLSM yet, but you can convert WKS files online to these formats:

Want to convert WKS to XLSM?

Let us know. We pick the conversions to add next by how many people ask for them.

How to convert wks to xlsm file

101convert.com assistant

101convert.com assistant
1yr

Understanding WKS and XLSM file formats

WKS files are spreadsheet documents created by Lotus 1-2-3 or Microsoft Works, both of which are now discontinued. These files store data in a tabular format, similar to modern spreadsheets, but lack advanced features found in newer formats.

XLSM files are macro-enabled spreadsheets used by Microsoft Excel. They support complex formulas, charts, and embedded VBA macros, making them suitable for advanced data manipulation and automation.

Why convert WKS to XLSM?

Converting WKS to XLSM allows you to access legacy spreadsheet data in modern Excel, enabling you to use advanced features, macros, and improved compatibility with current software.

How to convert WKS to XLSM

Since WKS is an outdated format, direct conversion to XLSM is not natively supported in most modern software. The process typically involves two steps:

  1. Convert WKS to XLS/XLSX: Use a compatible program to open the WKS file and save it as an Excel file.
  2. Save as XLSM: Open the converted file in Excel and save it as XLSM to enable macro support.

Recommended software for WKS to XLSM conversion

  • LibreOffice Calc: LibreOffice Calc can open many WKS files. Open your WKS file, then use File → Save As and choose XLSX as the format.
  • Microsoft Excel: Newer versions of Excel do not support WKS directly, but older versions (Excel 2003 and earlier) may. If you have access, open the WKS file and use File → Save As to save as XLS or XLSX.
  • Convert to XLSM: Once you have the file in XLS or XLSX format, open it in Excel and use File → Save As and select XLSM to enable macro functionality.

Online converters

Some online converters, such as Zamzar or CloudConvert, may support WKS to XLSX conversion. After converting to XLSX, open the file in Excel and save as XLSM.

Important tips

  • Macros: WKS files do not support macros. You will need to add macros manually after conversion to XLSM.
  • Formatting: Some formatting or formulas may not transfer perfectly due to differences between formats.
  • Backup: Always keep a backup of your original WKS file before conversion.

Note: This wks to xlsm conversion record is incomplete, must be verified, and may contain inaccuracies. Please vote below whether you found this information helpful or not.

Was this information helpful?

WKS vs XLSM: format comparison

How the WKS and XLSM formats compare on the properties that matter most for this conversion.

Comparison of the WKS and XLSM file formats
Property .WKS Lotus 1-2-3 worksheet .XLSM Microsoft Excel Macro-Enabled Workbook
Editable text No Limited
Fixed page layout No No
Text formatting Basic Extensive
Images No Yes
Interactive elements No Yes
Password protection Not supported Basic
Opens in a web browser No Partial
Typical file size Small Medium
Open standard No Partly open
Best used for Data exchange Editing and post-production
Introduced 1982 2007
Developer Lotus Development Corporation Microsoft
MIME type — application/vnd.ms-excel.sheet.macroEnabled.12

Information about file extensions and file types is provided by File-Extensions.org

Additional formats for
wks file conversion

Convert to xlsm from
other formats

Share on social media:

Already downloaded

This file has already been downloaded. For your privacy it was deleted from our server right after the download, so it cannot be downloaded again. To get it once more, convert the file again.