Which MIME types are related to file extension ".wks"?
The .wks file extension is associated with 4 MIME types:
application/vnd.ms-works, application/vnd.lotus-1-2-3, application/x-123, application/octet-stream.
A MIME type is a string that tells browsers and other tools how to handle a particular kind of file.
About .wks Files
WKS files are spreadsheet files used in older office software. They have several MIME types that reflect their varied history:
- application/vnd.ms-works: Used by Microsoft Works for basic spreadsheet functions.
- application/vnd.lotus-1-2-3 and application/x-123: Associated with Lotus 1-2-3 worksheet 1.0 files.
- application/octet-stream: Indicates a generic binary format used by VP-Planner Plus spreadsheets.
WKS files store data in rows and columns, often including formulas and simple graphics. Common software that can open or import these files includes Microsoft Works, Microsoft Excel, and LibreOffice Calc.
According to FilExt.com, they were popular in early productivity tools but now may require conversion to work in modern applications.
Relationship between file extension and MIME type
A file extension is a suffix at the end of a filename that indicates what type of file it is. File extensions help both users and operating systems identify what application should be used to open the file.
File extensions are typically separated from the filename by a period (dot) and consist of 2-4 characters, though they can be longer. For example, in the filename "document.pdf", ".pdf" is the file extension.
File extensions are closely related to MIME types, as they both serve to identify the format of a file. However, while MIME types are used primarily by web browsers and servers, file extensions are used by operating systems and applications.
Associated MIME types
application/vnd.ms-works, application/vnd.lotus-1-2-3, application/x-123, application/octet-stream
FAQs
How can I open a WKS file on a modern computer?
You can open .wks files using free open-source software like LibreOffice Calc or Apache OpenOffice, which maintain support for legacy formats. While older versions of Microsoft Excel (2003-2007) supported these files natively, modern versions often require file conversion or specific registry tweaks to access them.
Why can't I open my WKS file in the latest version of Microsoft Excel?
Microsoft removed support for the older Works and Lotus 1-2-3 formats starting with Excel 2013 to streamline the software and improve security. If you try to open a .wks file in Excel 2016 or later, you will likely encounter an error stating the file type is blocked or unsupported.
How do I convert a WKS file to a modern Excel format like XLSX?
The most reliable method is to open the file in LibreOffice Calc and use the Save As feature to select .xlsx or .xls. There are also online conversion tools available, but using desktop software ensures that formulas and cell formatting are preserved more accurately during the conversion.
Are all WKS files the same format?
No, the .wks extension was used by both Microsoft Works and Lotus 1-2-3, and the files have different internal structures. Software like LibreOffice usually detects the difference automatically, identifying the file as either application/vnd.ms-works or application/vnd.lotus-1-2-3 based on the file header.
What MIME type should I use for serving WKS files?
The MIME type depends on the origin of the spreadsheet. Use application/vnd.ms-works for Microsoft Works files and application/vnd.lotus-1-2-3 (or application/x-123) for Lotus files. If the specific format is unknown, the generic application/octet-stream is often used as a fallback.
General FAQ
What is a MIME type?
A MIME (Multipurpose Internet Mail Extensions) type is a standard that indicates the nature and format of a document, file, or assortment of bytes. MIME types are defined and standardized in IETF's RFC 6838.
MIME types are important because they help browsers and servers understand how to process a file. When a browser receives a file from a server, it uses the MIME type to determine how to display or handle the content, whether it's an image to display, a PDF to open in a viewer, or a video to play.
MIME types consist of a type and a subtype, separated by a slash (e.g., text/html, image/jpeg, application/pdf). Some MIME types also include optional parameters.
How do I find the MIME type for a file?
You can check the file extension or use a file identification tool such as file --mime-type on the command line. Many programming languages also provide libraries to detect MIME types.
Why can one extension have multiple MIME types?
Different programs and historical usage may assign various MIME identifiers to the same file format. Listing them together helps maintain compatibility across tools.