How-To

How to Insert a Table Into a Gmail Message

How to Insert a Table Into a Gmail Message

If you’re trying to insert a table in Gmail, you may be wondering where the option is. We’ll show you how to pop a table into your email.

When you want to include information in a Gmail message that’s structured, you’d probably want to use a table.

Unfortunately, there isn’t an easy way to insert a table in Gmail directly — there’s no table tool, for instance. While it isn’t possible to add tables to Gmail messages directly, there are some ways around the problem.

For instance, you can use Google Sheets or Microsoft Excel to create your table, then copy and paste it into your email. To do this, here’s what you’ll need to do.

How to Add a Table Into a Gmail Message

We’ll dive into the specifics next, but here’s a short version of what you need to do to insert a table into a Gmail message.

  1. First, create and format your table in Google Sheets or Microsoft Excel.
    Data in Google Sheets
  2. Next, select and copy all of the cells from your table. You can right-click after selecting your cells and choose Copy, or you can use the keyboard shortcut Ctrl+C (Windows) or Cmd+C (macOS).
    Copy table in Google Sheets
  3. Finally, paste the table into your Gmail message. You can right-click in the email where you want the table to appear and choose Paste. If you prefer keyboard shortcuts, the standard Ctrl+C works under Windows, and Cmd+C is the one for macOS.
    Paste into a Gmail message

Next, let’s look at any of the details in those steps you might be unsure of.

Create a Table in Sheets or Excel

First, you’ll need to make a table in a third-party tool. Google Sheets or Microsoft Excel are perfect for this, as the data is already separated into a table-like structure.

To begin, open Google Sheets or Microsoft Excel and enter your data. You can format the data using bold or italics for fonts, currencies, or decimals for numbers, cell borders — whatever it is you want and need from your table. This formatting will carry over when you copy and paste the table.

Data in Google Sheets

Copy the Table From Sheets or Excel

With your “table” data ready, select it and be sure to include all the cells. You can do this easily by dragging your cursor across the inserted data. Next, use one of these Copy actions:

  • Right-click and select Copy.
  • Use the keyboard shortcut Ctrl+C on Windows or Cmd+C on a Mac.
  • In Google Sheets, go to Edit > Copy.
  • In Microsoft Excel, click Copy in the ribbon on the Home

Copy table in Google Sheets

Paste the Table into Gmail

Head over to Gmail and hit the button on the top-left to compose your message as you usually would. Place your cursor in the message body where you want to insert the table. Then, use one of these Paste actions:

  1. Right-click and select Paste.
  2. Use the keyboard shortcut Ctrl+V on Windows or Cmd+V on macOS.
    Paste into a Gmail message
  3. You’ll then see your table of data formatted and structured nicely in your email.
    Table in Gmail email

Plain Text Mode Could Strip Your Table Formatting in Gmail

If your table appears jumbled without any structure when you paste it in (as shown in the screenshot below), you may have Plain Text Mode enabled for your email. This mode will not display a formatted table. To disable this, follow these steps.

  1. Click the three dots on the bottom right of the message to open More Options.
  2. Deselect Plain Text Mode to switch it off.
  3. You can then remove the messy data and paste the table again. It should then appear correctly.
    Plain text mode in Gmail

Edit the Table in Gmail

Once you insert a table in Gmail, you can make changes to it. You can edit the data, reformat the text, and add or remove data from the table after it’s pasted into Gmail. The structure remains the same as long as you don’t remove or modify any of the table cells.

Edit a table in Gmail

You cannot edit the table itself, such as inserting columns, removing rows, or adding borders.

Create an Organized Message in Gmail

Hopefully, the ability to insert a table into an email will be a feature that Google will add to Gmail in the future. Until then, you can still add structure and organization to the information you’re sending in your message by copying and pasting a table into Gmail using the abovementioned steps.

Click to comment

Leave a Reply

Your email address will not be published. Required fields are marked *

 

To Top