How to Email an Excel File That’s Too Large Safely

How-to basics · Updated November 20, 2026

The most reliable way to email an Excel file that exceeds an attachment limit is to upload it to OneDrive or another approved cloud service, create a sharing link, and email that link instead of the workbook. Before sending, check that recipients can open the link and that the workbook does not contain data they should not see. You can also reduce the workbook’s size, but email limits vary by service and organization.

What You’ll Need

  • The Excel workbook, plus permission to edit it if you plan to remove content or compress pictures.
  • A cloud storage account, such as OneDrive or Google Drive, with enough available space. For work files, use the storage service approved by your organization.
  • The recipient’s email address and, if needed, their name or organization so you can set appropriate access permissions.
  • A way to check the file size. In Windows File Explorer, right-click the workbook and select Properties. In OneDrive or Google Drive, you can also see the file size in the file list or details pane.

Step-by-Step

  1. Check the size and the recipient’s limits. Find the workbook’s size before attaching it. Email services limit the total message size, not just the workbook, because attachments are encoded as part of the message. For example, Gmail generally limits attachments to 25 MB per message; Outlook.com generally has a 25 MB limit for email attachments. Work or school accounts can have different limits set by an administrator, and the recipient’s mail system may impose a lower one. If the workbook is close to a limit, use a sharing link rather than trying to squeeze it under.
  2. Make a separate copy before changing the workbook. In Excel for Microsoft 365 on Windows, use File > Save As to create a copy with a clear name, such as Sales Report – share copy.xlsx. Keep the original unchanged until the recipient confirms they have what they need. This is especially important for workbooks with formulas, macros, links to other files, hidden sheets, or carefully formatted print layouts.
  3. Remove only content that is genuinely unnecessary. In the copy, look for duplicate sheets, unused high-resolution pictures, embedded objects, and historical data that the recipient does not need. Check formulas, charts, pivot tables, and references before deleting any rows, columns, or sheets; content that looks unused may support a report elsewhere in the file. To reduce picture size in Excel for Windows, select a picture and use Picture Format > Compress Pictures. If the option to apply the change to all pictures is available, use it only if you want every image reduced. On Mac, select a picture and look for Compress Pictures on the Picture Format tab; the exact options can vary by Excel version. Lower resolution or deleting cropped areas can reduce image quality or remove recoverable image content, so work on the copy.
  4. Save, close, and check the new size. Save the edited copy, close it, and check its size in File Explorer or Finder. An Excel .xlsx file is already stored in a compressed format, so putting it in a ZIP archive often makes little difference. A ZIP can sometimes help with other file types or collections of files, but it may also be blocked by a recipient’s email system. Avoid renaming the workbook extension to make it seem smaller; that does not compress the file and can make it unusable.
  5. Upload the workbook to OneDrive. For Microsoft 365, sign in to OneDrive using the account that should own the shared file. On the OneDrive website, choose Add new or Upload, select Files, and choose the workbook. Wait for the upload to finish, then locate the file and choose Share. In a work or school account, follow your organization’s sharing rules; external sharing may be disabled. You can also save the file in a OneDrive folder on your computer and wait for its sync status to show that uploading is complete.
  6. Set link access deliberately. In the sharing dialog, choose who should be able to use the link. Options differ by account, but may include specific people, people in your organization, or anyone with the link. Prefer specific people when the workbook is confidential or contains personal information. Check whether recipients can edit or only view, and set an expiration date or password if your service and organization offer those controls. Do not use an unrestricted link for sensitive material just because it is quicker.
  7. Copy the link and email it. Use Copy link in the sharing dialog, then paste the link into a new email. State what the workbook is, whether the recipient should view or edit it, and any relevant deadline. If you use Outlook, you can compose the message in Outlook after copying the link from OneDrive. Some Outlook versions also offer cloud attachment or sharing-link options when you attach a OneDrive file; labels differ between classic Outlook, new Outlook, and Outlook on the web. Confirm that the option shares a link rather than adding a large local attachment.
  8. Test the recipient experience. Check the link from a browser or account that is not already signed in as the file owner, if practical. A private or guest browser window can reveal whether the link requests the right sign-in or permission. For a specific-person link, make sure you entered the correct email address and that the recipient is using that account. If the link is blocked by your organization, ask the recipient or your IT team which approved transfer method to use.

Common Mistakes

  • Assuming a link automatically grants access. A link can point to the file while still denying the recipient permission. Set access before sending, and confirm the recipient’s email address when sharing with specific people.
  • Choosing anyone-with-the-link access by default. Anyone who obtains that link may be able to open the workbook, depending on the service settings. Use the narrowest setting that works, especially for customer, employee, financial, or health information.
  • Sending a ZIP file without checking whether it helps. Because .xlsx files are already compressed, zipping one commonly saves little space. Some email systems also block ZIP attachments for security reasons.
  • Removing rows or sheets without checking dependencies. Formulas, charts, named ranges, pivot tables, and other worksheets may depend on content that looks redundant. Make a copy and verify key results after any cleanup.
  • Forgetting the recipient may need a different format. A shared workbook is best when the recipient needs formulas or multiple sheets. If they only need a data extract, a CSV may be suitable, but it generally preserves one sheet of values rather than workbook formatting, formulas, or multiple tabs. Explain any format change before sending.
  • Sending a link before upload finishes. A file that is still syncing may not be available when the recipient clicks. Wait for the upload or sync to complete, then test the link.

Tips

  • Use the service your recipient can open. OneDrive is convenient for Microsoft 365 users, while Google Drive may suit recipients who already use Google accounts. A company may require SharePoint or another managed service instead. Do not upload confidential work files to a personal account if policy forbids it.
  • Give the file a clear name. Use a descriptive filename and, when useful, a date or version number. Avoid names such as final-final-new, which make it hard to identify the correct copy.
  • Say what the recipient can do. Tell them whether they have view or edit access and whether they should download a copy. If several people will edit the workbook, agree on one shared version rather than emailing successive copies that can diverge.
  • Keep the original attachment route for small files. If the workbook is below both senders’ and recipients’ limits and your organization permits it, a normal attachment may be simpler. A link is not automatically better if the recipient cannot access the cloud service.
  • Think about what a CSV does and does not contain. A CSV can be much smaller for a plain data table, but it usually does not carry Excel formulas as formulas, formatting, charts, macros, or other worksheets. Save a new CSV copy and open it to confirm that the exported rows and columns are the intended ones.

Troubleshooting

  • The email still says the file is too large. Check that you pasted a sharing link rather than attaching the local workbook. Remove any other large attachments. If you must send an attachment, ask the recipient or administrator for the applicable message-size limit; reducing the file slightly may not be enough because the email itself adds overhead.
  • The recipient sees an access request or permission error. Open the sharing settings for the file, verify the recipient’s address, and grant the appropriate level of access. If the account does not allow external sharing, use an approved alternative or ask an administrator to arrange access. Do not work around a company restriction by creating a public link.
  • The upload is stuck or incomplete. Check your internet connection, available cloud storage, and whether the service reports an upload error. Try again from the service’s website, or use its desktop sync app if permitted. Do not send the link until the file appears in storage and the upload has completed.
  • The workbook is still very large after cleanup. Look for embedded images, objects, extensive formatting, or large amounts of data the recipient does not need. Excel’s Ctrl+End shortcut on Windows moves to the last used cell; on Mac, use Control+End or Fn+Control+Right Arrow depending on the keyboard. If it lands far beyond the visible data, do not delete whole ranges blindly. First confirm that the cells are truly unused, then clear or delete only the excess content in a copy, save, close, and reopen the workbook to check whether the used range and file size improve.
  • The recipient cannot edit the workbook. Check whether the link was set to view-only and whether the recipient signed in with the account to which access was granted. Change permission to edit only if collaboration requires it. If they are opening a downloaded copy, their edits will not update the shared original unless they work in the shared file or upload their revised copy.
  • The workbook opens incorrectly after conversion. If formulas, multiple sheets, formatting, or macros matter, send the original Excel workbook through a cloud link rather than converting it to CSV. If you did export a CSV, compare it with the original and repeat the export with the correct worksheet selected.

Frequently Asked Questions

What is the best way to email an Excel file that is too large?
Upload it to an approved cloud service such as OneDrive, set the right viewing or editing permissions, and email the sharing link. This avoids the attachment-size limit while retaining the workbook format.

Can I send a large Excel file through Gmail?
Gmail generally limits attachments to 25 MB per message. For a file beyond the limit, Gmail may offer to share it through Google Drive. Upload the workbook to Drive, set access for the intended recipients, and include the link in your message.

Does zipping an Excel workbook make it small enough to email?
Usually not by much if the file is an .xlsx workbook, because that format is already compressed. A ZIP may still be useful for sending several files together, but check your recipient’s email rules because some systems block archives.

Can I email an Excel file without giving the recipient access to my cloud account?
Yes. Share access to the individual file rather than your account, and grant only the permissions required. The recipient may need to sign in or verify their email, depending on the service and link settings.

Will the recipient see changes I make after emailing the link?
If the link points to the same cloud-stored workbook, recipients with access generally see the current shared file. If they download a copy, their copy will not automatically update. Tell collaborators to use the shared version when you want everyone working on one file.

Is it safe to use an anyone-with-the-link setting?
It can be convenient for non-sensitive files, but anyone who receives or forwards the link may be able to access it. For private or business information, use named recipients or organization-only access where possible and follow your organization’s security rules.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.