How to Send an Excel Spreadsheet as Email

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
Excel 2013 automatically attaches the workbook to your email message.
Image Credit: Image courtesy of Microsoft.

Some spreadsheets are just too important to keep to yourself. Whether you want to collaborate with coworkers, send a file to a client, or show your friends that you finally cataloged all your comic books, Excel 2013 gives you several options for sharing a workbook without having to open another app. Send a link to any Excel file in your OneDrive folder, or email it as an attachment as a PDF, XPS or an Excel XLSX file.

Advertisement

Step 1

Delete an irrelevant worksheet by right-clicking its tab.
Image Credit: Image courtesy of Microsoft.

Open a workbook in Excel. Examine the entire workbook, including each worksheet, to ensure it contains only information that you want to share. If you're sending a price breakdown to a client, for example, make sure your costs aren't included as well. To delete a worksheet, click its tab at the bottom of the window and select "Delete."

Advertisement

Video of the Day

Step 2

Save a copy in OneDrive if you plan to email a link.
Image Credit: Image courtesy of Microsoft.

Save the workbook with a new file name, if you made any changes to it, by clicking the "File" menu and selecting "Save As." If you decide to send a link instead of using an email attachment, save the copy to your OneDrive folder rather than on your computer.

Advertisement

Step 3

Click "Email" in the Share options.
Image Credit: Image courtesy of Microsoft.

Click the "File" menu, select "Share" and click "Email." You have four choices to send an email from Excel: as an attached Excel file, an attached PDF file, an attached XPS file, or as a link to your OneDrive file.

Advertisement

Advertisement

Step 4

An Excel file attached to an email message.
Image Credit: Image courtesy of Microsoft.

Click the "Send as Attachment" option. Excel launches an Outlook window, with the XLSX already attached. Type one or more recipient names in the "To" text field, add a message and click "Send." The Outlook window automatically closes.

Advertisement

Step 5

Excel inserts a link to the spreadsheet in an open email window.
Image Credit: Image courtesy of Microsoft.

Click the "Send a Link" icon in the Share window's Email options only if the file has been saved to your OneDrive folder.. Excel automatically generates a link to that file and pastes it in an email message. When you send this link to a recipient, it opens in Excel Online. If the recipient doesn't have a free Microsoft account, the same link gives him the option to create one.

Advertisement

Advertisement

Step 6

Select the PDF or XPS option for email attachments.
Image Credit: Image courtesy of Microsoft.

Select the "Send as PDF" or the "Send as XPS" icons if you don't want the recipient to be able to edit the file. Windows 8.1 opens both PDF and XPS files using its Reader app.These are also good choices if you're not certain that the recipient has a Microsoft account, as it saves him the hassle of signing up for one in order to see your spreadsheet.

Advertisement

Step 7

Excel's Get a Sharing Link options.
Image Credit: Image courtesy of Microsoft.

Click the "Get a Sharing Link" icon in the Share options if you prefer to email a link using a different email account, or through a messaging service. Note that you have two choices here. You can get a link that lets the recipient edit the document, or a link that is view-only. Click the "Create Link" button and then then copy the link provided and paste it into a message or email.

Advertisement

Advertisement

Step 8

Specify if you want users to edit the file or not.
Image Credit: Image courtesy of Microsoft.

Click the "Invite People" share option if you want to collaborate on a spreadsheet with others. Enter your coworkers' names and specify if you want them to edit the file, or just view it. This is similar to the Get a Sharing Link option, with two important differences. First, if you use SharePoint at your office, you can require that recipients sign in before accessing the document by clicking the check box. Secondly, if you no longer want someone to have access to the file, you can return to this same screen and click "Remove User."

Video of the Day

Advertisement

Advertisement

references