homepage Welcome to WebmasterWorld Guest from 54.196.62.132
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
progex




msg:1107536
 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?

 

progex




msg:1107537
 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.

eWhisper




msg:1107538
 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.

progex




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

Thanks eWhisper, works like a charm.

kmander




msg:1107540
 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.

mquarles




msg:1107541
 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.

MQ

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