Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Every time I copy and paste from a Google Spreadsheet, it adds a double quote before and after everything, and duplicates every single double quote.

For example, if I copy:

This is a "string" of sorts.

And paste ANYWHERE else (I can reproduce it on Windows, Mac, Linux, Notepad++, SublimeText, Xcode...) it results into:

"This is a ""string"" of sorts."

How can I copy and paste so that A" results in A" instead of "A""?

EDIT: I am talking about when you copy an entire cell, if you enter edit mode in a cell and copy the contents, the copy works fine. But you cannot copy formula-based cells this way, or multiple cells.

share|improve this question
I can't reproduce your results. I've taken the exact string in Google Spreadsheets and copied it to an Outlook mail (native), notepad (Window 7), all yielding the same string !! I used Crtl+C and the way to copy from within the spreadsheet. – Jacob Jan Tuinstra Mar 12 '13 at 12:06
If you click the cell first and copy the contents of the cell (not the cell itself) it will work. I am having this issue specially with concatenated strings (because there are no contents to copy beside the formula). – speeder Mar 12 '13 at 13:37
I can’t reproduce your results either. Even after you edited it. – Alex Mar 14 '13 at 17:16
I have this problem as well, it seems to happen whenever I insert a line-break. The output looks fine in the doc but the extra quotes show up when pasting. This formula should reproduce the problem: ="This is a ""string"" and "&CHAR(10)&" a linebreak" – Ben Collier Jun 13 '13 at 16:30
@BenCollier with linbreak this is by design, because otherwise it cannot know if it's break to next row or linebreak within cell (currently you can copy & paste any cells, even if they contain linebreaks). Alex, can you confirm there is no linebreaks in the cells you copying? – LogicDaemon Jan 11 '14 at 22:16

The "issue" is that Google Spreadsheet is putting valid CSV-formatted data into the clipboard.

The workaround is to publish the spreadsheet to the web (File -> Publish to Web) and copy out of that document instead.

It's not much of a solution but it can save you some time.

share|improve this answer

Try pasting without formatting: Ctrl+Shift+V (or Command+Shift+V).

share|improve this answer
I tried here on a OSX (command+shift+v) copying to sublime text, did not worked. – speeder Dec 9 '13 at 18:44

What just worked for me, after having tried copying a cell that was generated by a formula (with line breaks and some single quotes) and didn't work correctly pasting to NotePad and NotePad++, was copying to a Google Doc (or to Microsoft Word, but why do that instead?).

Google Doc and Word both displayed the wanted result.

Select what you want to copy from Google Sheets, Control-C to copy (or use the menu), make a new or open an existing Google Doc (or Microsoft Word), Control-V to paste, or use the menu.

share|improve this answer
Not very clear. – serenesat Jul 7 at 15:07
Select what you want to copy from Google Sheets, Control-C to copy (or use the menu), make a new or open an existing Google Doc (or Microsoft Word), Control-V to paste, or use the menu. – roirraW 'edor' ehT Jul 8 at 16:49

Got the solution right here.... (see example sheets file in this link)

To sum it up: If you can live without linebreaks in the text you are generating within a cell, then you will be able to paste without quotations. the line-breaking can then be done in the destination file.

Exhaustive example in the link above.

share|improve this answer
Always include essential part of the link into answer. – serenesat Jan 31 at 14:43

This annoys me too.

If you just select the cell to copy from, Gdocs will add the double quotes around your pasted content.

However, if you double click into the cell like you are going to edit the contents, select and copy it from that view, when you paste it, it will not add the quotes. Adds an extra click, but is still easier than exporting it.

share|improve this answer
Agreed but sadly, if the cell contains generated data (say, from a formula) then you just end up getting the formula :( – RedYeti Feb 5 '15 at 14:00
This was writtein in my original question... People read before replying? – speeder Feb 10 '15 at 15:00

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.