Find solution
How to Display Woocommerce products in Table Format?

When I copy a small table from Excel and paste it into Gmail while composing an email, why do I lose the table format?

  • I copied a table from Excel of 10x2 with column A as names and column B as the money they donated, and pasted it into gmail, I lost the table format. Instead data showed as a text in two lines on Gmail. How do I retain the table format? Update: 's answer below works! If someone has alternative (or better) solution, please write that too.

  • Answer:

    Set gmail to "rich text" format Copy the Excel cell/table into MS Word Copy the table/cell from MS Word into Gmail Why does it do that?  Because Excel is a spreadsheet program and G-mail is not.  The same could be said about Excel and Word, but they're made by the same company and designed to work with one another (i.e. play nicely together).

Garrick Saito at Quora Visit the source

Was this solution helpful to you?

Other answers

If you are using the Chrome browser, you will lose your table format. You have two options to try: 1. use another browser, like Internet Explorer or Firefox. 2. copy the spreadsheet first to Microsoft Word. Make sure it looks right in Word. Then make sure your Gmail is using rich text format. You do that by checking the formatting bar at the bottom of the message window where you are typing your email. On the right side of the bar, the words "Plain text" will be shown if it is plain text. If it is rich text, the area on the right side of the bar will be blank. Finally, copy the spreadsheet from Word to Gmail. The formatting should be maintained in Gmail. Here is a link to a Google forum where this is discussed: https://productforums.google.com/forum/#!topic/gmail/C91vLx7jV5A Good luck!

Irv Cantor

Hello Everyone, we have developed a tool to help you solve this problem. CloudCodes Insertable Browser Extension help you paste Excel Table directly in Gmail without loosing the formatting Check out http://blog.cloudcodes.com/how-to-paste-microsoft-excel-table-in-gmail Regards Rahul

Rahul Bhavsar

I just showed Garrick Saito's trick with the help of Screenshots. You can take a look at this question:

Paramdeep Singh

This video can help you: https://www.youtube.com/watch?v=ZkjmR2-GQD8Good Luck!

Seo Man

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.