See all How-To Articles

How to Paste Excel Table Into Gmail

This tutorial demonstrates how to paste an Excel table into Gmail.

 

paste excel table in gmail final data

 

Paste Table Into Gmail

When pasting an Excel table in Gmail, some formatting (like borders) may copy over incorrectly or be lost completely. To avoid this and paste a table with existing formatting, you can use Google Sheets or Word as a helper. Say you have the following table in Excel.

 

paste excel table in gmail initial data

 

As you can see this table has thick outside borders, which won’t be pasted correctly in Gmail if you copy it directly from Excel. To avoid this, follow these steps:

  1. Select the table you want to copy (here, the range B1:E8), (2) right-click anywhere in the selected area, and (3) and choose Copy (or use the keyboard shortcut CTRL + C).

 

paste excel table in gmail 1

 

  1. Now open your Google Sheets file, right-click somewhere in the sheet (B1) and choose Paste (or use the keyboard shortcut CTRL + V).

 

paste excel table in gmail 2

 

  1. Now, (1) select the data range to copy in Google Sheets (B1:E8), (2) right-click anywhere in the selected area, and (3) choose Copy (or use the keyboard shortcut CTRL + C).

 

paste excel table in gmail 3

 

  1. You can go to Gmail and open a new email, right-click in the mail, and choose Paste (or use the keyboard shortcut CTRL + V).

 

paste excel table in gmail 4

 

As a result, the table with all formatting from Excel is pasted in Gmail.

 

paste excel table in gmail final data

 

You could also convert the table to an image within Excel first, then copy and paste to Gmail.