Let’s say you’ve got your master list of keywords, for SEO or Adwords all ready to go. If you’ve done your homework, and read the Long Tail, you know that you should have a few thousand keywords. They’re primed, relevant and sure to please the Adwords Quality Score and you need to copy these in a more text friendly manner for say, meta keywords tag. This is something so small, but can take up so much time if you don’t know how to do it.
Converting Excel lists, to comma lists can be time consuming without such a simple trick
- Take your long list, and copy it into a blank Notepad document.
- Select All and copy it again into a Word document.
- Use Find and Replace to find “^p” without the quotes, and replace with “, ” without the quotes. I suggest putting a space after the comma to separate the values.
- Hit Replace All.
Now you have the Excel list, converted to a more user friendly view that is more helpful for meta keywords and backing up long lists. Want to convert back? Just switch the two values in Find and Replace.
Did you just write this article today? I was just looking for this info!
I do not have Word, I have wordpad or OpenOffice.org Writer, do you know how I can get this to work with either of these?
thanks so much for the great article.
Yep, just wrote this today because I was getting so frustrated with [del] [comma] [space] a million times over!
You can substitute any word processor for Word, as long as it has the find and replace function, and ^p is the label for new paragraph. Let me know what you’ve used and how it worked and I’ll update the post.
I can’t get it to work but if I figure it out I’ll let you know!
ok, FINALLY found the answer to my with using OpenOffice. Here’s what worked for me with OpenOffice Writer. Follow steps 1 & 2 above except open in OO Writer. go to Find & Replace, click on More Options, check Regular expressions. Then Search for: $ and Replace with: , and then click Replace All.
You just save me some time Chris.
Thanks
THANKS — exactly the information I needed!!
in the newer versions of word you have to use the find/replace tool a little differently. First turn on the paragraph indicator. The select the replace tool. At the bottom of the tool there is a “special” button that allows you to select Paragraph marks. It’s the only way to do it now.