Lotus/IBM Approach 97 file magic bytes (.apr)
.apr file signature: D0 CF 11 E0 A1 B1 1A E1 | application/vnd.lotus-approach
Category: Office
Lotus/IBM Approach 97 is a proprietary spreadsheet document format created by Lotus Development Corporation and later associated with IBM’s Approach 97 suite. It was used to store database-oriented spreadsheet files for business reporting, data entry, and simple record management in the Approach application. It is a legacy format from the 1990s and is generally safe to open, though modern software support may be limited or require conversion.
Magic Bytes
Offset 0
D0 CF 11 E0 A1 B1 1A E1
Sources: Gary Kessler
Validation Code
How to validate .apr files in Python
def is_apr(file_path: str) -> bool:
"""Check if file is a valid APR by magic bytes."""
signature = bytes([0xD0, 0xCF, 0x11, 0xE0, 0xA1, 0xB1, 0x1A, 0xE1])
with open(file_path, "rb") as f:
return f.read(8) == signatureHow to validate .apr files in Node.js
function isAPR(buffer: Buffer): boolean {
const signature = Buffer.from([0xD0, 0xCF, 0x11, 0xE0, 0xA1, 0xB1, 0x1A, 0xE1]);
return buffer.subarray(0, 8).equals(signature);
}How to validate .apr files in Go
func IsAPR(data []byte) bool {
signature := []byte{0xD0, 0xCF, 0x11, 0xE0, 0xA1, 0xB1, 0x1A, 0xE1}
if len(data) < 8 {
return false
}
return bytes.Equal(data[:8], signature)
}API Endpoint
/api/v1/apr
curl https://filesignature.org/api/v1/apr
See the full API documentation for all endpoints and parameters.
Related Formats
Frequently Asked Questions
What is a .apr file?
A .apr file is a Lotus/IBM Approach 97 file. Lotus/IBM Approach 97 is a proprietary spreadsheet document format created by Lotus Development Corporation and later associated with IBM’s Approach 97 suite. It was used to store database-oriented spreadsheet files for business reporting, data entry, and simple record management in the Approach application. It is a legacy format from the 1990s and is generally safe to open, though modern software support may be limited or require conversion.
What are the magic bytes for .apr files?
The magic bytes for Lotus/IBM Approach 97 file (.apr) files are D0 CF 11 E0 A1 B1 1A E1 at byte offset 0. These bytes identify the file format more reliably than the extension alone.
How do I validate a .apr file?
To validate a .apr file, read the first bytes of the file and compare them against the known magic bytes (D0 CF 11 E0 A1 B1 1A E1) at offset 0. This is more reliable than checking the file extension alone, as extensions can be renamed.
What is the MIME type for .apr files?
The primary MIME type for .apr files is application/vnd.lotus-approach.
Is it safe to open .apr files?
Lotus/IBM Approach 97 file (.apr) files are generally safe to open. They are classified as low risk because they primarily contain data rather than executable code. However, always ensure files come from a trusted source.