How to Add a Table to an Email in Gmail

Read Time:3 Minute, 47 Second

Gmail doesn’t offer a tool for adding tables to your emails. However, you can create tables in Google Sheets and move them into your Gmail emails. We’ll show you how.

How This Works

In Gmail, there’s no option to create or add tables to your emails directly in the compose screen. But you can copy tables from outside of Gmail and paste them into your emails.

The workaround below uses Google Sheets to create a table. You’ll make your table in Sheets, copy the table from there, and paste it into your emails in Gmail. Gmail preserves the original formatting of your table, which means that your table will look the same whether it’s in Sheets or in your emails in Gmail.

You can use Microsoft Excel or Google Docs to create tables for your Gmail emails.

Add a Table to an Email from the Gmail Website

On a desktop computer like Windows, Mac, Linux, or Chromebook, use the web versions of Gmail and Sheets to make and add tables to your emails.

To get started, launch Google Sheets in a web browser on your computer.

On the Sheets site, if you’ve already made a spreadsheet, click it to open it. Otherwise, create a new spreadsheet by clicking “Blank” on the site.

Click "Blank" on Google Sheets to make a new spreadsheet.

If you’re making a new spreadsheet, enter your data in the blank spreadsheet open in your browser. We’ll use the following spreadsheet for the demonstration:

A sample spreadsheet on Google Sheets.

Next, select the area that contains your entered data in your Sheets spreadsheet. Use your mouse or your keyboard’s arrow keys to make this selection.

The selected spreadsheet should look like this:

Select a table in a spreadsheet on Google Sheets.

Now, copy the selected area to your clipboard. Do this by clicking Edit > Copy in Sheets’ menu bar. Alternatively, press Ctrl+C on Windows or Command+C on Mac to copy the table.

Select "Edit > Copy" in Google Sheets.

Your table is now copied, and you’re ready to paste it into an email in Gmail. To do so, open a new tab in your web browser and launch the Gmail site. From the top-left corner, select the “Compose” button to create a new email.

Select "Compose" on the Gmail site.

Gmail will open a “New Message” window. In this window, right-click the email body (the largest white box in the window) and select “Paste” from the menu.

Alternatively, press Ctrl+V (Windows) or Command+V (Mac) to paste your table.

Right-click the email body and select "Paste" in Gmail.

The table that you copied from Sheets is now available in your new Gmail email. You can now send your email containing the table.

A pasted table in a Gmail email.

To send the email, fill in the other fields in your new email window. This includes the recipient’s email address, the subject of the email, and the email body. Finally, hit “Send” at the bottom of the window.

Fill in email fields in Gmail.

And your recipient should receive your email with your table in it!

Insert a Table in an Email with Gmail’s Mobile App

If you’d like to send a table in a Gmail email from your iPhone, iPad, or Android phone, you can use the Gmail and Google Sheets apps to do so. These apps work exactly like their web interfaces.

To use this method, first, launch the Google Sheets app on your phone.

In the Sheets app, if you’ve already created a spreadsheet, tap it to open it. Otherwise, create a new spreadsheet by tapping the “+” (plus) sign in the bottom-right corner of the app.

Tap "+" to create a new spreadsheet in the Google Sheets app.

If you’re creating a new spreadsheet, enter the data for your table in the spreadsheet open on your phone’s screen. Then, start dragging from the top-left corner of your table all the way to the bottom-right corner. This will select your table in the spreadsheet.

Select a table in a spreadsheet in the Google Sheets app.

Copy the selected table to your clipboard. Do this by tapping and holding on the table and selecting “Copy” from the menu.

Select "Copy" in Google Sheets' context menu.

Your table is now copied. Close the Sheets app.

You’ll now paste your copied table in an email in the Gmail app. To do so, launch the Gmail app on your phone. In the bottom-right corner of the app, select “Compose.”

Tap "Compose" in the Gmail app.

On the “Compose” screen, tap and hold the “Compose Email” box.

Tap and hold the "Compose email" box in the Gmail app.

From the menu that pops up, select “Paste.”

Select "Paste" from Gmail's context menu.

And the table that you copied from Sheets will be pasted into your Gmail email.

A pasted table in an email in the Gmail app.

You can now fill in the other fields, like the recipient email address and the email subject, before hitting the send option.

And that’s how you send organized table data in your Gmail emails!

 

 

Happy
Happy
0 %
Sad
Sad
0 %
Excited
Excited
0 %
Sleepy
Sleepy
0 %
Angry
Angry
0 %
Surprise
Surprise
0 %

Check out our other content

Leave a Reply

Recent Articles

More like this
Related

%d bloggers like this: