How to encrypt an Excel file in 2025

Sharing a financial spreadsheet or customer database as an Excel file without encryption is like leaving your office door unlocked—anyone who gains access can view and modify your sensitive data. Excel encryption protects your spreadsheets by requiring a password to open them, preventing unauthorized access even if the file is shared, lost, or stolen.

Excel encryption transforms your spreadsheet into unreadable code that can only be decrypted with the correct password. Whether you're protecting financial data, customer information, or proprietary formulas, encrypting Excel files adds a crucial security layer. This guide covers multiple methods to encrypt Excel files, from built-in Microsoft Office features to secure cloud-based solutions with advanced protection features.

Quick recap of Excel encryption methods

1. Microsoft Excel built-in: Native password protection with encryption using Excel's built-in security features
2. Archive encryption: Create password-protected ZIP files containing Excel workbooks
3. Third-party encryption tools: Use specialized software like VeraCrypt or AxCrypt for advanced encryption
4. Secure sharing platforms: Use Papermark for encrypted Excel sharing with analytics and access controls
5. Cloud storage encryption: Leverage encrypted cloud storage services with additional security layers

Method 1: Encrypt Excel using Microsoft Excel built-in features

Microsoft Excel provides built-in encryption options that offer strong security without requiring additional software.

Step-by-step guide for encrypting Excel files:

1. Open your Excel workbook in Microsoft Excel
2. Navigate to encryption options:
   • Click File > Info
   • Click Protect Workbook > Encrypt with Password
   • Alternatively, go to File > Save As > Tools > General Options
3. Set password protection:
   • Enter a strong password in the Password to open field (minimum 8 characters, mix of letters, numbers, and symbols)
   • Confirm the password
   • Click OK
4. Save the encrypted workbook:
   • Click Save or Save As
   • The file will now require the password to open

Microsoft Excel uses AES-256 encryption for password-protected files, making it extremely difficult for unauthorized users to access your spreadsheet without the password. This encryption applies to the entire workbook, protecting all worksheets and data within the file.

Additional Excel protection options:

Worksheet-level protection (restricts editing but not viewing):

1. Select the worksheet you want to protect
2. Click Review > Protect Sheet
3. Set permissions: Choose which elements users can edit (cells, formatting, etc.)
4. Enter a password (optional but recommended)
5. Click OK to apply protection

Workbook structure protection (prevents adding/deleting worksheets):

1. Click Review > Protect Workbook
2. Check "Structure" to prevent worksheet changes
3. Enter a password and confirm it
4. Click OK

Note: Excel's built-in encryption is strong, but it doesn't provide access tracking or the ability to revoke access after sharing. For business use cases, consider Method 4 for additional features.

Method 2: Encrypt Excel using archive tools

Creating password-protected ZIP archives is a simple way to encrypt Excel files without modifying the spreadsheet itself.

Windows: Create encrypted ZIP files

1. Select your Excel file in File Explorer
2. Right-click and select Send to > Compressed (zipped) folder
3. Double-click the ZIP file to open it
4. Click File > Add a password (Windows 10/11)
5. Enter a strong password and confirm it
6. Click OK to apply encryption

Note: Windows built-in ZIP encryption is relatively weak. For stronger security, use third-party tools like 7-Zip.

Using 7-Zip (Windows/Mac/Linux)

1. Download and install 7-Zip from 7-zip.org
2. Right-click your Excel file (or folder containing Excel files)
3. Select 7-Zip > Add to archive
4. Configure encryption:
   • Set archive format to "7z" or "zip"
   • Enter a strong password
   • Select "AES-256" encryption method
   • Check "Encrypt file names" for additional security
5. Click OK to create the encrypted archive

7-Zip uses AES-256 encryption, which is much stronger than Windows' default ZIP encryption. The encrypted archive will require the password to extract and view the Excel file.

Mac: Create encrypted ZIP files

1. Select your Excel file in Finder
2. Right-click and select Compress [filename]
3. Open Terminal (Applications > Utilities)
4. Navigate to the ZIP file location:

   cd ~/Desktop
   

5. Encrypt the ZIP file:

   zip -e encrypted_file.zip original_file.zip
   

6. Enter and verify a password when prompted

Archive encryption provides an additional layer of protection, but recipients must extract the archive before opening the Excel file. This method is best for email transmission or basic file storage.

Method 3: Encrypt Excel using third-party encryption software

For advanced encryption needs, specialized software provides additional features and flexibility beyond Excel's built-in options.

VeraCrypt (Windows/Mac/Linux)

VeraCrypt is a free, open-source disk encryption software that can create encrypted containers for Excel files.

1. Download and install VeraCrypt from veracrypt.fr
2. Create a new volume:
   • Click Create Volume
   • Choose Create an encrypted file container
   • Select volume type (standard or hidden)
   • Choose location and name for the container
3. Configure encryption settings:
   • Select encryption algorithm (AES recommended)
   • Choose hash algorithm (SHA-512 recommended)
   • Set volume size (large enough for your Excel files)
4. Set a strong password (minimum 20 characters recommended)
5. Format the volume and mount it
6. Copy Excel files into the mounted volume
7. Dismount when done to secure the files

VeraCrypt provides military-grade encryption and is ideal for highly sensitive Excel files that require maximum security.

AxCrypt (Windows/Mac)

AxCrypt provides simple file encryption with cloud storage integration.

1. Download and install AxCrypt
2. Right-click an Excel file and select AxCrypt > Encrypt
3. Enter a password when prompted
4. The file is encrypted and can only be opened with AxCrypt and your password

AxCrypt is user-friendly and integrates well with cloud storage services, making it convenient for encrypting Excel files stored in Dropbox, Google Drive, or OneDrive.

Method 4: Encrypt Excel using Papermark

Papermark provides a secure way to encrypt and share Excel files with advanced security features beyond basic password protection, including analytics, access controls, and dynamic watermarking.

Step-by-step guide for encrypting Excel files with Papermark:

1. Create your Papermark account:

   • Visit Papermark
   • Sign up for a free account or log in
   • Access your secure dashboard

2. Upload your Excel file:

   • Click "Upload Document" or drag and drop your Excel file
   • Papermark automatically encrypts files during upload using AES-256 encryption
   • Supports Excel files (.xlsx, .xls) of any size
   • Excel files are converted to PDF for secure viewing

3. Configure encryption and security settings:

   • Navigate to document settings
   • Enable password protection and set a strong password
   • Toggle email verification to require recipient identity confirmation
   • Set access expiration dates to limit file accessibility
   • Configure allowlist/denylist to control who can access the Excel file

4. Enable advanced protection features:
   • Activate dynamic watermarking to add recipient information to each page
   • Toggle download prevention to allow viewing only
   • Configure screenshot protection to discourage unauthorized captures
   • Set custom permissions for different recipients
   • Enable NDA gate before access for additional legal protection

5. Share the encrypted Excel file:
   • Generate a secure, encrypted link
   • Share the link via email or messaging
   • Provide the password through a separate, secure channel
   • Monitor access through Papermark's page-by-page analytics dashboard

Papermark uses server-side AES-256 encryption combined with comprehensive access controls. While it doesn't use end-to-end encryption, it provides strong security with the added benefit of document analytics, engagement tracking, and access revocation—making it ideal for business use cases where you need to track who viewed your Excel file and when.

Encrypt and share Excel files securely

Method 5: Encrypt Excel using cloud storage encryption

Many cloud storage services offer encryption features that can protect Excel files stored in the cloud.

Microsoft OneDrive

1. Upload your Excel file to OneDrive
2. Right-click the file and select Share
3. Set sharing permissions:
   • Choose who can access (specific people or anyone with link)
   • Set expiration date (if available)
   • Require password (if available in your plan)
4. Generate a secure link and share it

OneDrive uses encryption at rest and in transit, but the level of protection depends on your Microsoft 365 plan. Enterprise plans offer more advanced security features.

Google Drive

1. Upload your Excel file to Google Drive
2. Right-click the file and select Share
3. Configure sharing settings:
   • Set access permissions (viewer, commenter, editor)
   • Restrict to specific people
   • Set expiration date (if available)
4. Copy the sharing link and distribute it

Google Drive encrypts files in transit and at rest, but doesn't offer password protection for individual files. For stronger security, combine Google Drive with archive encryption (Method 2) or use a secure sharing platform.

Security considerations: Cloud storage encryption protects files stored on servers, but doesn't provide the same level of access control and tracking as dedicated secure sharing platforms. For sensitive business Excel files, consider using Papermark's secure file sharing for enhanced protection.

Comparison: Excel encryption methods

Best practices for Excel encryption

Follow these practices to maximize the security of your encrypted Excel files.

1. Use strong passwords: Create passwords with at least 16 characters, mixing uppercase, lowercase, numbers, and special characters. Avoid dictionary words, personal information, or common patterns. Consider using a password manager to generate and store strong passwords.

2. Backup passwords securely: Always store passwords in a secure location separate from your encrypted Excel files. Use a password manager or encrypted note-taking app. Never share passwords in the same email or message as the file link.

3. Choose appropriate encryption strength: For highly sensitive data, use AES-256 encryption. Excel's built-in encryption uses AES-256 by default, which is recommended for financial data, customer information, and proprietary formulas.

4. Protect formulas and structure: Use Excel's worksheet and workbook protection features in addition to file encryption. This prevents unauthorized users from viewing formulas or modifying the spreadsheet structure even if they gain access.

5. Verify encryption is working: Test that encrypted Excel files cannot be opened without the correct password before relying on encryption for sensitive data. Try opening the file without the password to confirm protection is active.

6. Combine encryption with other security measures: Encryption protects Excel files at rest, but also use secure transmission methods (HTTPS, secure email), access controls, and consider dynamic watermarking for additional protection against unauthorized sharing when using secure sharing platforms.

Conclusion

Encrypting Excel files protects your sensitive spreadsheets from unauthorized access, whether they're stored locally or shared online. Choose Microsoft Excel's built-in encryption for local file protection, archive encryption for email transmission, or Papermark for encrypted Excel sharing with analytics and advanced access controls. For business use cases where you need to track access and control sharing, Papermark's secure file sharing provides encryption plus comprehensive security features for your Excel files.

Start encrypting your Excel files

FAQ