What is MIME type "application/vnd.lotus-1-2-3"?

A MIME type is a string that tells browsers and other tools how to handle a particular kind of file.

application/vnd.lotus-1-2-3 is the MIME type for files created by Lotus 1-2-3, a spreadsheet application once popular in business environments. It tells programs that the file contains spreadsheet data with rows, columns, formulas, and formatting.

This type covers several file variants developed over different Lotus versions, such as configuration and worksheet files. Common examples include configuration data (CNF), primary worksheets (123), and legacy worksheets like WK4, WKS, WK1, WK3. Other specialized versions include WR1, WJ1, WJ3, and WK2.

Key points about this MIME type include:

Data Exchange: It ensures that legacy Lotus spreadsheets open correctly in compatible software.
Legacy Support: It helps users access and convert old data stored in Lotus formats.
System Integration: Operating systems and applications use it to select the right program for viewing or editing these files.

This MIME type remains relevant for users who manage archived business data or perform document conversions from older formats. For further technical details, you may explore more about MIME types from trusted online resources.

Associated file extensions

.cnf, .wr1, .123, .wk4, .wks, .wk1, .wk3, .wj1, .wj3, .wk2

Usage Examples

HTTP Header

When serving content with this MIME type, set the Content-Type header:


    Content-Type: application/vnd.lotus-1-2-3

HTML

In HTML, you can specify the MIME type in various elements:


    <a href="file.dat" type="application/vnd.lotus-1-2-3">Download file</a>

Server-side (Node.js)

Setting the Content-Type header in Node.js:


    const http = require('http');    
    
    http.createServer((req, res) => {    
      res.setHeader('Content-Type', 'application/vnd.lotus-1-2-3');    
      res.end('Content here');    
    }).listen(3000);

Associated file extensions

.cnf, .wr1, .123, .wk4, .wks, .wk1, .wk3, .wj1, .wj3, .wk2

FAQs

How do I open a file with the MIME type application/vnd.lotus-1-2-3?

You typically need specific spreadsheet software to open these legacy files. While the original Lotus 1-2-3 software is discontinued, modern suites like LibreOffice Calc and older versions of Microsoft Excel often support importing formats like .123, .wk1, and .wk4.

Can web browsers display Lotus 1-2-3 files directly?

No, modern web browsers (Chrome, Firefox, Edge) cannot render application/vnd.lotus-1-2-3 files natively. When a user clicks a link to a file like 123 or WK1, the browser will usually prompt the user to download and save the file to their computer.

How do I configure Apache to serve Lotus 1-2-3 files correctly?

You can add the MIME type mapping in your .htaccess file or main configuration. Use the directive AddType application/vnd.lotus-1-2-3 .123 .wk1 .wk3 .wk4 .wks to ensure the server sends the correct header for these extensions.

What does the "vnd" prefix mean in this MIME type?

The vnd prefix stands for "vendor," indicating that application/vnd.lotus-1-2-3 is a vendor-specific MIME type rather than a standard open format. It was defined specifically for the Lotus software ecosystem to handle their proprietary spreadsheet data structures.

How can I convert these files to a modern format like Excel?

To convert files such as WK4 or .123, open the file in a compatible program like LibreOffice Calc or Corel Quattro Pro. Once opened, use the "Save As" feature to export the data to a modern format like application/vnd.openxmlformats-officedocument.spreadsheetml.sheet (Excel .xlsx) or CSV.

Why does Nginx download the file as a generic binary stream?

If Nginx is not configured with the specific MIME type, it may default to application/octet-stream. to fix this, add application/vnd.lotus-1-2-3 123 wk1 wk4; to your mime.types file inside the types { ... } block and reload the server.

Are there security risks associated with legacy Lotus files?

Yes, like many spreadsheet formats, Lotus 1-2-3 files can contain macros (scripts). While modern viruses targeting this specific legacy format are rare, you should always scan files from unknown sources before opening them, as they could contain malicious code intended for older systems.

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 are multiple MIME types listed for one extension?

Different applications and historical conventions may use alternative MIME identifiers for the same kind of file. Showing them all helps ensure compatibility across systems.