gmail does not offer a tool to add tables to your emails. however you can create tables in google sheets and move them to your gmail emails. we’ll show you how.
how does this work
In gmail, there is no option to create or add tables to your emails directly on the compose screen. but you can copy tables from outside of gmail and paste them into your emails.
The solution shown below uses google spreadsheets to create a table. will make your table in sheets, copy the table from there and paste it in your emails in gmail. gmail preserves the original formatting of your table, which means 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 create and add tables to your emails.
To get started, launch Google Sheets in a web browser on your computer.
On the sheet site, if you’ve already created a spreadsheet, click it to open it. otherwise, create a new spreadsheet by clicking “blank” on the site.
If you are creating a new spreadsheet, enter your data into the blank spreadsheet open in your browser. We will use the following spreadsheet for the demo:
Next, select the area that contains the data entered in your spreadsheet. use your mouse or the arrow keys on your keyboard to make this selection.
The selected spreadsheet should look like this:
now, copy the selected area to your clipboard. do it by clicking edit > copy in the sheets menu bar. alternatively press ctrl+c on windows or command+c on mac to copy the table.
your table is now copied and you are ready to paste it into an email in gmail. To do this, open a new tab in your web browser and launch the gmail site. in the upper left corner, select the “compose” button to create a new email.
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.
The table you copied from the sheets is now available in your new gmail email. now you can send your email containing the table.
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 body of the email. finally, press “send” at the bottom of the window.
and your recipient should receive your email with your table!
insert a table in an email with the gmail mobile app
If you want 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 it. these applications work exactly like their web interfaces.
To use this method, first launch the Google Sheets app on your phone.
In the spreadsheets app, if you’ve already created a spreadsheet, touch it to open it. otherwise, create a new spreadsheet by tapping the “+” (plus) sign in the bottom right corner of the app.
If you are creating a new spreadsheet, enter your table data into the open spreadsheet on your phone screen. then start dragging from the top left corner of your table to the bottom right corner. this will select your table in the spreadsheet.
Copy the selected table to your clipboard. do this by tapping and holding the table and selecting “copy” from the menu.
your table is now copied. close the sheet app.
You will now paste the copied table into 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”.
On the “compose” screen, touch and hold the “compose email” checkbox.
from the menu that appears, select “paste”.
and the table you copied from the sheets will be pasted into your gmail email.
You can now fill in the other fields, such as the recipient’s email address and the email subject, before you hit the send option.
and this is how you send organized table data in your gmail emails!
If gmail is your main email provider and you receive a lot of emails every day, it’s a good idea to create email folders in gmail to better manage all your emails.
related: how to create a new folder in gmail