How to insert a table into an email in Gmail

Currently, Gmail does not provide a tool for users to create data tables while composing an email. However, you can completely create a data sheet from Google Sheets (or Microsoft Excel or Google Docs) and simply 'paste' it into your Gmail email.

Insert a table into a Gmail email on the web

To get started, go to Google Sheets in any web browser on your computer.

On the Google Sheets interface, if there is already a spreadsheet, click on it to open it. If not, you can create a new spreadsheet by clicking the " Blank "on the screen.

How to insert a table into an email in Gmail Picture 1How to insert a table into an email in Gmail Picture 1

If you create a new workbook, enter the data into the open blank spreadsheet as usual, such as in the example below.

How to insert a table into an email in Gmail Picture 2How to insert a table into an email in Gmail Picture 2

Next, select the area containing the entered data in the spreadsheet. You can use the mouse or the arrow keys on the keyboard to do this.

The selected worksheet should look like this:

How to insert a table into an email in Gmail Picture 3How to insert a table into an email in Gmail Picture 3

Now copy the selected area to the clipboard. Do this by clicking Edit > Copy. Alternatively, you can also press Ctrl + C on Windows or Command + C on Mac to copy the table.

How to insert a table into an email in Gmail Picture 4How to insert a table into an email in Gmail Picture 4

Your spreadsheet is now copied and ready to be pasted into an email in Gmail. Open a new tab in your web browser and go to Gmail. From upper left screen, click " Compose " to create a new email.

How to insert a table into an email in Gmail Picture 5How to insert a table into an email in Gmail Picture 5

A new compose message window will open. Here, right click on the email content and select ' Paste '  from the menu that appears. Or you can also press Ctrl + V (Windows) or Command + V (Mac) to paste the table.

How to insert a table into an email in Gmail Picture 6How to insert a table into an email in Gmail Picture 6

The data sheet that you copied from Google Sheets has appeared in the new Gmail email. You can now send this email as usual, or add more content if needed.

How to insert a table into an email in Gmail Picture 7How to insert a table into an email in Gmail Picture 7

Insert table into Gmail email in mobile app

First, launch the Google Sheets app on your iPhone, iPad, or Android phone.

In the Google Sheets application interface, if you have already created a spreadsheet, click on it to open it. Otherwise, a new spreadsheet can be created by tapping the ' + ' (plus sign) in the bottom right corner of the screen.

How to insert a table into an email in Gmail Picture 8How to insert a table into an email in Gmail Picture 8

In case you create a new spreadsheet, enter the data in the spreadsheet as usual. Then, drag your finger from the top left corner to the bottom right corner of the table to 'black out' the spreadsheet.

How to insert a table into an email in Gmail Picture 9How to insert a table into an email in Gmail Picture 9

Small in the options menu appears, click ' Copy ' ( Copy ).

How to insert a table into an email in Gmail Picture 10How to insert a table into an email in Gmail Picture 10

Your table is now copied. Close the Google Sheets app.

Now, launch the Gmail app on your phone. At the bottom right of the app, select ' Compose ' .

How to insert a table into an email in Gmail Picture 11How to insert a table into an email in Gmail Picture 11

On the compose new email screen, tap and hold a place under ' Compose Email '.

How to insert a table into an email in Gmail Picture 12How to insert a table into an email in Gmail Picture 12

From the menu that appears, select ' Paste '.

How to insert a table into an email in Gmail Picture 13How to insert a table into an email in Gmail Picture 13

The table you copied from Google Sheets will be pasted into the Gmail email. You can now send this email as usual, or add more content if needed.

How to insert a table into an email in Gmail Picture 14How to insert a table into an email in Gmail Picture 14

5 ★ | 1 Vote