|How do I copy & paste tables from Excel Spreadsheet Into Gmail While in Chrome & Maintain Original Formatting & Borders||Gary Y.||6/21/10 9:18 AM|
Please describe your question/comment in detail (for example, steps to reproduce the problem): My job requires the use of Excel to create numerous spreadsheets and relevant tables. I often have to filter the spreadsheet to pull streamlined data and create tables from it for submittal via email to relevant staff members. When I copy from Excel and paste into Gmail through Chrome Browser, I end up with a text only version, no borders, no background colors or anything. If I copy and paste through Internet Explorer 7 or 8, It pastes the table exactly as it appears in the Excel spreadsheet, background colors, borders and all.
As a test/workaround, I have also tried to first copy the table and paste into MS Word (as suggested by a Chromium help article), then copy and paste from MS word into Gmail while in Chrome and this works fine also as it carries over all the original formatting. That is progress, but an extra step I would prefer to avoid. How do I get this to work where I can simply paste from Excel directly into Gmail while using Chrome and maintain all of the original Excel formatting? It is my desire to work 100% in Chrome, but this puts a wrench in the mix and would love to see it resolved.
Google Chrome version (type about:version into the address bar): 5.0.375.70 (Official Build 48679)
Operating System:Windows XP Pro and Home, Windows 7.
Error Message: n/a
Crash ID (follow the steps here: http://goo.gl/fKKK): n/a
URLs (if applicable):Extensions installed: n/a
|Re: How do I copy & paste tables from Excel Spreadsheet Into Gmail While in Chrome & Maintain Original Formatting & Borders||QQFarmer||6/21/10 9:43 AM|
I seriously doubt you can use Gmail as a spreadsheet editor. It would be a much better idea to edit the tables in Excel and put the saved file in an attachment in Gmail.
You can also post your question in the Gmail Help Forum: http://www.google.com/support/forum/p/gmail?hl=en.
|Re: How do I copy & paste tables from Excel Spreadsheet Into Gmail While in Chrome & Maintain Original Formatting & Borders||Gary Y.||6/21/10 10:23 AM|
Thanks for your response. Please note I do not wish to use Gmail as a spreadsheet editor. I simply want to be able to paste tables, including the borders and background colors, from out of Excel into Gmail while using Chrome and the tables maintain the original formatting as was originally established in Excel.
Gmail does do this successfully when I am working through IE8, but drops all formatting when I am working through Chrome leaving a text only paste result. Also, if I first copy and paste it from Excel into Word, then from Word into Gmail while in Chrome, it will maintain the original Excel formatting (which was also caried over into Word). It just will not copy from Excel and Paste directly into Gmail while in Chrome and maintain the original formatting. It appears to be a flaw when copy & pasting from Excel into Gmail thru Chrome, because it works perfectly when doing the same in IE8.
|Re: How do I copy & paste tables from Excel Spreadsheet Into Gmail While in Chrome & Maintain Original Formatting & Borders||virginia85218||7/9/10 3:21 AM|
Note that I'm having the same exact problem. I wish to add that when I am successful when I use Mozilla as the web browser. My Excel columns are all mashed together.
I wish to display parts of the table and not as an attachment. And like Gary want to use Chrome as my web browser. NO I.E.
|QQFarmer||7/9/10 11:14 AM|
Thought of a workaround that might work: upload your spreadsheet to Google Docs and open it with Google Spreadsheet and save it. Then copy and past into Gmail.
|JuanLanteri||7/22/10 9:11 AM|
@QQFarmer: Copy and Paste from Goggle Spreadsheets to Gmail does the same: only paste the text, not columns and colors.
|QQFarmer||7/22/10 9:55 AM|
Now I'm thinking of a PDF virtual printer and screen capture....
|donatsaturn||7/27/10 8:17 AM|
Same problem copying Excel table data to Gmail in Chrome. Copying from Excel keeps data but loses format. Turning Excel worksheet into a google doc then copying to gmail is even worse - everything copies as a text line. Only workaround I found is copying Excel data into Word document, then copying into gmail with Chrome. That works, but it is also a lot of additional work. This is one of the major things standing in the way of my leaving Explorer behind.
|bgibney||9/8/10 11:47 AM|
Depending on your version of Office, you want to look for the "copy as picture" option. In 2003 it is under the edit tab, in 2007 it is accessed through the arrow underneath the clipboard picture. Select the area you would like to copy in Office, then chose "copy as picture" and then return to gmail and paste. Hopefully this will solve your dilemma
|Gary Y.||9/28/10 7:06 AM|
I found the copy as picture feature in Excel 2007. Oddly enough, it is located under the paste menu in the ribbon at the top of Excel 2007, but while I was able to select to copy as picture, it would not past into the email in Google Chrome.
|Dustin805||11/5/10 9:04 AM|
The simple work-around to paste from excel into word, re-copy and paste into Chrome/ gmail. This is not ideal and it used to work for me straight from excel into gmail/ chrome, so I know there is a setting that does it right to preserve formatting. I'd love to hear the setting or answer if anyone knows it. Pasting into word as frequently as I do, is annoying but not the end of the world.
|SmallBizzer||11/19/10 9:05 AM|
works with firefox and ie but not CHROME.
|This message has been hidden because it was flagged for abuse.|
|This message has been hidden because it was flagged for abuse.|
|chris_dw||2/10/11 6:32 PM|
I came along with the solution:
# publish your spreadsheet as a web page
# open the web page and copy , paste to your gmail
|Drewsonian||4/5/11 9:38 PM|
I'm having the same issue. Is there a place where we can submit this to the Google team as a bug?
|Drewsonian||4/5/11 9:44 PM|
Google might listen to this issue if we submit a bug via the following steps (who knows, it's worth a shot if it's really an annoyance to everyone here):
1. Click the Page menu .
2. Select Report a bug or broken website.
3. Choose an issue type from the drop-down menu. The web address of the webpage you're on is recorded automatically.
4. If possible, add key details in the 'Description' field, including steps to reproduce the issue you're experiencing.
5. Keep 'Send source of current page' and 'Send screenshot of current page' checkboxes selected.
6. Click the Send report button to report a Google Chrome bug.
|Speedy Kepke||5/17/11 2:01 AM|
I KNOW THE WHOLE SOLUTION :
* copy from an Excelfile and Paste your notices PERFECTLY in your Gmail - if you want, you can also add columns
* the reverse operation (vice versa) is possible
If anyone is interested, let me know.
One disadvantage, it is written in Dutch, but if necessary, I'll translate it
|Gestapo||7/13/11 10:02 PM|
As of this post time, the latest version of Internet Explorer and Mozilla Firefox does not do what you guys have reported. No more other steps just switch browsers.
|Eva Quirinius||7/30/11 3:58 AM|
I found a method which is not at all perfect, but better than the plain-text copy from Google Docs Spreadsheet into Gmail:
Select the table in Google Docs Speadsheet, and use Web Clipboard to copy the selection ("Copy cell range"). So: not the normal copy-paste.
then, still in Google Docs, File -> New -> Document
then use Web Clipboard to paste the table into the Document. You possible have to reformat a bit
then select the text in the Document, and do a normal Copy (Control - C)
then in Gmail paste (Control - V) the copied text. This will include formatting.
Tested in Chrome on Ubuntu Linux.
|ChuckBSomeone||8/21/11 3:43 PM|
#1 In Excel 2003 under File menu --> Web Page Preview
#2 This will open a new tab in your browser with the spreadsheet in it.
#3 Then select your cell range in the web page and it will paste into Gmail unaltered.
|Jasmine Goh||9/12/11 9:50 PM|
#1 In Excel 2003 under File menu --> Web Page PreviewHow about in Excel 2007
|GBebawy||11/4/11 7:33 AM|
Is Google doing nothing to fix this Issue... Is the only answer to use another browser or be inconvenienced?
I know Gmail Keeps the Format from Excel in other browsers so it's a Google Chrome Issue
It should be a simple fix give us an update already.
|gabe117||1/5/12 9:04 AM|
In Google Spreadsheets download as html. this will open html version in new tab. Copy this and paste into Gmail. Will have unaltered formatting.
In Excel 2007 or 2010 file, save as web page. Go to file, right click, click open with and select browser of choice. Select the content copy and paste into Gmail. This will preserve formatting perfectly.
I've used the copy and paste into word trick, but it doesn't preserve spacing when you actually send it.
|dibya.indoo||2/5/12 3:30 AM|
Hiii, here's a Simple solution that works fine.
All u need to configure ur Gmail into Outlook Express.
In Outlook Express it pastes unchanged as it copies from an excel sheet.
Hope it will solve all of urs problems.
|Kelemvor||2/22/12 11:15 AM|
Wow, sucks that this has gone so long without being fixed. None of the work arounds actually work other than the multi step pasting into different programs and then ending up in Gmail.
All I need to be able to do is go into a Google Spreadsheet. Select a range of specific cells. Paste those specific cells into Gmail and have it keep the data formatted as rows and columns.
This does not work for me in ANY browser. I tried FF10, Chrome 17, and IE8 which are all I have access to at work.
I also tried pasting into Word 2003 and it pasted as plain text in there too.
|hoyoyi||2/27/12 12:33 AM|
Solution is worked as below!
Paste your excel sheet in word file, copy the table and paste in gmail, it worked perfectly to me! I hope this help ^ ^
|GeoFan49||3/19/12 2:54 PM|
Works fine in Firefox on a Mac. You can select parts of a table, copy and paste. The problem seems to be in Chrome.
|MediaSurfer||5/25/12 1:04 AM|
I just had this problem and did a quick search. There's actually a Chrome Plugin that handles this called 'Gmail Mail Handler'.
You can install it from either of these places:
Basically it adds an envelope icon to your toolbar, then you click 'paste special'. Then you get wonderful formatted Excel Tables in Gmail or ANY other cloud rich-text area. We needed to fix email tables in Zoho Mail which is why we needed this.
If this works for you, I urge you to ask the author to create a separate extension for "Paste from Excel".
|Rosario||7/20/12 1:36 AM|
I am interested and I read Dutch. Please let me know your solution.
|Mario Silvestri III||10/10/12 6:55 AM||<This message has been deleted.>|