How to Use Excel Tables in Outlook Online

Are you aware of using Excel tables in Microsoft Outlook? This is the right page to check how to use the Excel table in Outlook Online. Microsoft Outlook is not only for sending emails also it has many features. Adding an Excel table in Outlook makes effective communication.

If we are in the organization, we have to make sure our information is conveyed in a proper way. The Excel table in Outlook lets the user understand the email in an easier way.

Instead of typing more information in the body of the mail, if we show it in tabular format then users find an easier way to read it. Let’s get started to see more about this.

Table of Contents

Copy and Paste Excel Table in Outlook Online

Below are the steps to copy and paste the Excel table into the Outlook Online desktop application.

Open Microsoft Outlook in the desktop application.
Make sure you have an Excel file on your PC to paste into Outlook Online.
Click New Email on the Home page of the Outlook Online desktop application.

Now copy (ctrl+c) the Excel table that you want to add to the Outlook Online table.

Now paste (ctrl+v) in the Outlook Email body of the mail from the Outlook Online desktop application.

If it is pasted without cells, no worries. We can change it to the tabular format. Select all the text and right-click Insert then click All Borders to form table.

This is one method of adding the Excel table into the Outlook Online desktop application.

Copy and Paste the Excel Table into Outlook Online Web Application

We can edit the table information in Outlook. This is the only method we can edit. The method involves straightaway copying and pasting an Excel table into an Outlook email.

Open Microsoft Outlook from a browser such as Chrome, Safari, or Internet Explorer.
Make sure you have an Excel file on your PC to paste into Outlook Online.
Click New Email on the Home page of the Outlook Online Web application.

Now copy (ctrl+c) the Excel table that you want to add to the Outlook Online table.

Paste (ctrl+v) in the Outlook Online Web application. In case of the Outlook Web application, it will paste in the Excel table format directly.

This is the simple and standard method to include an Excel table in the Outlook Online Web application.

Adding Excel Table in Outlook Without Editing

Instead of the previous method, we may also insert an Excel table as a photo in an email. However, we cannot update or edit the table after adding it to an email.

Open Microsoft Outlook in the desktop application.
Make sure you have an Excel file on your PC to paste into Outlook Online.
Click New Email on the Home page of the Outlook Online desktop application.

Now copy (ctrl+c) the Excel table that you want to add to the Outlook Online table.

Now Right-click on the body of the Outlook Email and select Picture (U) from the Paste Options.

Now the Excel table will be pasted in the Outlook Online desktop application without editing.

Excel table to Outlook Online desktop application

This is one method to send an Excel table to the Outlook Online desktop application.

Screenshot to Add Excel Table to Outlook

Another method we can use is taking screenshots of the Excel table and pasting them into the Outlook body of the mail.

Open Microsoft Outlook in the desktop application.
Make sure you have an Excel file on your PC to paste into Outlook Online.
Click New Email on the Home page of the Outlook Online desktop application.

Now take the screenshot by clicking prt.sc on the keyboard. (Here I am using the Snaggit tool to take the screenshot).

Click (ctrl+v) to paste into the Outlook Online desktop application.

This is how we have to add the Excel table to the Outlook Online desktop application through the screenshot method.

Attaching Excel Table in Outlook Online

Here the traditional method comes where we can attach the Excel file to the Outlook Online desktop application. This method can be applicable to Web applications as well.

Open Microsoft Outlook in the desktop application or Web application.
Click New Email on the Home page of the Outlook Online desktop application.

Click the Attachment icon at the top of the page to add an Excel table in Outlook Online.

Attach Excel table to the Outlook Online

Click the Browse this PC option to attach Excel in the Outlook Online desktop application.

Choose the file location and click Insert to add the Excel file to Outlook Online.

Microsoft Outlook Attach Excel to Outlook

The Excel file will be added to the Outlook Online desktop application.

This is the method to add the Excel table to the Outlook online desktop application by the attachment method.

Reason for Using Excel Table in Outlook Online

There might be several reasons to use Excel tables in Outlook Online. Here are some reasons why we want to copy an Excel table into Outlook.

Sharing of Data – If we have important data or information stored in an Excel table that we want to share with the team through email, copying it into Outlook allows us to send the data as part of our email message. This is helpful for sharing reports, financial data, project updates, and more.
Reduced File Size – If we have a larger number of files, but the team member or client wants a particular portion of data, then we can select and send the chosen part this save the file size in Outlook Online.
Security and Permissions – We can control who gets access to the data when we send an Excel table within an Outlook email. Depending on our security needs, we can configure permissions and restrict forwarding, printing, or copying.

Conclusion

From this, you have learned how to use the Excel table in Outlook Online. I have discussed enough ways to add excel in Outlook Online. Try all the ways and make use of whichever it is comfortable for you.