How-to Create and Copy a Table in Google Mail (Gmail) from Excel

On a recent project of mine, I tasked a team member with creating a communication to send out to users.  This communication involved making a table in the body of the email.  We use Gmail (Google Mail) as our email system and he couldn’t find a way to create a table in Gmail.  He even went as far as to insert a picture of a table from Excel instead of a simple table.  Looking at the icons in Gmail, there is no way that I see to make a table:image

Learn Excel Dashboard Course

I said there has to be a way as I have seen other emails with tables in them so I knew we could do it.

Here is a sample of table that I wanted to add in a Gmail email text body:image

But if I copy this table of values from Excel to Gmail email, this is what it looks like:image

You lose some of the formatting.  The numbers are now left justified.  The cell borders are gone.  The bolding is gone.  There has to be a way to make a table with borders in Google Mail.  Here is the quick trick on how to do it.





 

The Breakdown and Step-by-Step

1) Create a Table in Excel Spreadsheet Cells

2) Copy the Table of Spreadsheet Cells from Microsoft Excel and Paste in Microsoft Word

3) Copy the Table of Spreadsheet Cells from Microsoft Word and Paste in Gmail Email Text Body



 

That is the trick.  Copy from Excel to Word.  Then copy from Word to Google mail.

Here is what the Gmail table looks like when copied to Word from Excel and then to the email:image

See all the formatting and table structure with borders are intact.  Simple trick for a confusing problem when using Gmail, tables and Excel.

 





Video Tutorial

Check out this technique in this short video demonstration:

 

What other cool tricks do you use when using Excel?  Let me know in the comments below.  Also, don’t forget to subscribe up for my blog so you get the next posting delivered directly into your inbox.



Learn Excel Dashboard Course

Steve=True





29 COMMENTS

  1. Another way to copy/paste an excel table onto gmail without having to use Word is as follows:

    (1) Instead of using the “copy” function, go under “paste” and you’ll see a function called “copy as picture.” Use that.

    (2) “Paste” the table back on the excel sheet (just off to the side for the purpose of efficiency).

    (3) “Copy” the recently pasted image and you can “paste” it onto your gmail.

    • Hi Prinyanka, I am not sure what you mean. I am not aware of a setting. There are extensions available in the Chrome extensions store.

  2. Good trick! Was struggling with formatting on gmail. On doing Ctrl+V, no other option comes apart form simple paste, so definitely this works for me!!

LEAVE A REPLY

Please enter your comment!
Please enter your name here