homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Google / Google AdWords
Forum Library, Charter, Moderators: buckworks & eWhisper & skibum

Google AdWords Forum

Excel: How to add keywords with quotes?
Copy and paste with phrase matching doesn't work

 3:41 pm on Dec 30, 2004 (gmt 0)

For some reason, copying and pasting a list of (partial match) keywords in Column A doesn't work. It strips the quotes out, leaving broad matching keywords.

Being new to Excel, perhaps I'm not doing it correctly. Is there a certain way to paste keywords in quotes?



 3:43 pm on Dec 30, 2004 (gmt 0)

Never mind, I found out a work-around.

Apparently, you have to copy the list of partial match keywords from a MICROSOFT application like Word (wordpad and notepad do not work), then paste it into Excel.


 3:51 pm on Dec 30, 2004 (gmt 0)

If copying from another application, this is how you can preserve the quotes:

1. After pasting, a little clipboard will appear at the bottom of the paste. Click on it and select "Use Text Import Wizard"

2. After fixing the first screen you'll see, hit next. At this point you'll see a " with "Text Qualifier" next to it. Change the Text qualifier to {none}.

Then just hit finished. All your quotes will be preserved.


 4:01 pm on Dec 30, 2004 (gmt 0)

Thanks eWhisper, works like a charm.


 6:37 pm on Dec 30, 2004 (gmt 0)

The tool in my profile can you help you out progex - it wraps your keyword list with whatever targetting options you chose.


 8:47 pm on Dec 30, 2004 (gmt 0)

Although it is not exactly the answer to the issue (which has been provided above), I think that it might help if you knew an easy way to add quotes and brackets back in with Excel.

1) put your keyword list in Column B
2) put the " or [ in Column A
3) put the " or ] in Column C
4) copy Column A and Column C all the way down
5) cut and paste Columns A through C into AdWords

The Google system will automatically close up the extra spaces and will consider Column A + Column B + Column C as one term.

If that isn't clear, let me know and I can provide an example.


Global Options:
 top home search open messages active posts  

Home / Forums Index / Google / Google AdWords
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved