How to share Excel files securely by email, cloud or link

Sending an Excel file looks like the simplest task in the world: attach it and hit Send. But that file may carry hidden sheets, internal comments, the name of whoever created it or customers’ personal data that nobody outside your team should see. And once it’s sent, you no longer control where it ends up.

This guide shows you how to check what the file contains before sharing it, send only the data that’s needed, encrypt it with a password and choose wisely between email, cloud and link depending on the situation.

Before sharing: check what the file really contains

What you see on screen isn’t everything that’s in an Excel workbook. It’s common to find:

• Hidden or very hidden sheets with calculations, internal rates or other customers’ data.
• Hidden rows and columns that are still there even if you can’t see them.
• Comments and notes with remarks that weren’t meant for third parties.
• Document properties: author, company, last person who modified it.
• Links to other files on your network, which reveal paths and folder names.
• PivotTables whose cache keeps the full source data, even if the report only shows totals.

Excel includes a wizard to detect all this. Save a copy of the file first and then:

1. Go to File › Info › Check for Issues › Inspect Document.
2. Leave all categories selected and click Inspect.
3. Review the results and click Remove All for anything that shouldn’t leave the file.

Careful: some removals can’t be undone, so it’s best to work on the copy and keep the original.

Share only the data that’s needed

Copy the values to a new workbook

If the recipient only needs a summary, don’t send them the whole workbook. Select the range, copy it and paste it into a new workbook with Home › Paste › Paste Values. That way you don’t send formulas that reveal the logic of your calculations or references to sheets you don’t want to show.

Mask sensitive data

Sometimes you need to share a list without exposing full identifiers, such as ID or customer numbers. With the code in A2, this formula leaves only the first two and last two characters visible:

=LEFT(A2,2)&"****"&RIGHT(A2,2)

A code like 48213977 would appear as 48****77. Then copy the new column, paste it as values and delete the original column. If you only hide the column, the data is still inside the file.

Send a PDF if no editing is needed

When the recipient only needs to read, a PDF keeps them from seeing formulas, hidden sheets or data outside the print area. You can create it from Excel or with our tool to convert Excel to PDF.

Protect the file with an opening password

Don’t confuse protecting a sheet with protecting the file. The Review › Protect Sheet option only prevents cells from being changed, but anyone who opens the workbook sees all of its content. To stop anyone from opening it without the password, you need to encrypt it:

1. Go to File › Info › Protect Workbook › Encrypt with Password.
2. Type the password, confirm it and save the file.
3. Close it and open it again to check that it asks for the password.

If you don’t have Excel at hand or you’re working on another computer, our free tool to password-protect Excel files does it from your browser: upload the file, choose the password and download the protected version.

For the password to be worth anything:

• Use a long passphrase or at least twelve varied characters. No dates and no customer names.
• Store it in a password manager: if you forget it, there’s no reasonable way to recover the content.
• Use a different password for each sending or recipient.

Sharing by email

Email is convenient, but the attachment gets copied to your sent folder, the recipient’s inbox and every forward. Reduce the risks like this:

• Check the recipients before sending. Autocomplete is a classic cause of emails going to the wrong person.
• Never send the password in the same email as the file. Send it through another channel: a phone call, a text message or a messaging app.
• Use a neutral file name. “Full_payroll_March.xlsx” announces the content to anyone who sees the attachment.
• Let the recipient know in advance that a protected file is coming, so they don’t take it for a suspicious attachment.

Sharing through the cloud or with a link

Services such as OneDrive, SharePoint or Google Drive let you share a link instead of sending a copy. The big advantage is that you can change permissions or remove access later. A quick comparison:

When you create the link:

1. Choose access for specific people, identified by their account, rather than anyone who has the link.
2. Give view-only permission unless they really need to edit.
3. If your service and plan allow it, add an expiration date and block downloads.
4. When the collaboration ends, go to access management and remove the permissions.

A common mistake: sharing the whole folder when only one file was needed. Anything you add to that folder later will also be visible.

Checklist before you hit Send

1. I’ve worked on a copy and run the Document Inspector.
2. There are no hidden sheets, rows or columns with information that shouldn’t go out.
3. Personal data has been removed or masked as values.
4. The file is encrypted if it contains sensitive information.
5. The password travels through a different channel from the file.
6. The recipients and link permissions are correct.

Conclusion

Sharing an Excel file securely doesn’t require complicated tools, just a small routine: check what it contains, remove what isn’t needed, encrypt when there’s sensitive data and choose the channel that gives you the most control. Those few minutes of review prevent the hardest problem to fix: a file with confidential information that you can no longer get back.

Frequently asked questions