How to clean a large list of keywords?

Benji1

Benji1

Registered Member
Joined
Jan 15, 2022
Messages
89
Reaction score
15
Hey guys,

How do i clean up a large list of Keywords? I have a List of 900 Keywords from Ahrefs Matching Terms Report.

Many keywords in the list are duplicated, just in a different spelling or different word order.

Is there a way to group those Keywords by Topic or to clean up the duplicates?

I tried working with GPT3.5 and Keywordcupid but no good results.

Looking forward!
 
Advertise on BHW
you can try Keyword Insights, and other options are Cluster AI, KeyClusters, and Umbrella.
 
If they are only 900 then I can suggest you something.

Copy them and paste in docs.google.com/spreadsheet - new file

1. Click on the row, you don't need to select the row.
2. Then go in the menu of google spreadsheet and click on DATA > Sort by column A to Z
3. It will sort the similar keywords next to each other in a row.
4. All you need to do now is scroll down and see which one's are the one's that you like and which one's are useless.

I do it like that.
Hopefully it will help you.
 
Benji1 said:
Hey guys,

How do i clean up a large list of Keywords? I have a List of 900 Keywords from Ahrefs Matching Terms Report.

Many keywords in the list are duplicated, just in a different spelling or different word order.

Is there a way to group those Keywords by Topic or to clean up the duplicates?

I tried working with GPT3.5 and Keywordcupid but no good results.

Looking forward!
Click to expand...
I would suggest Keyword Surfer and KeyClusters.
 
alonelywriter said:
If they are only 900 then I can suggest you something.

Copy them and paste in docs.google.com/spreadsheet - new file

1. Click on the row, you don't need to select the row.
2. Then go in the menu of google spreadsheet and click on DATA > Sort by column A to Z
3. It will sort the similar keywords next to each other in a row.
4. All you need to do now is scroll down and see which one's are the one's that you like and which one's are useless.

I do it like that.
Hopefully it will help you.
Click to expand...

This is not going to work, it sorts based on the first word of the keyword phrase.

best laptops for nursing
laptops for nursing
good laptops for nursing

all 3 are the same but will not get sorted together.
 
DeadJoe said:
This is not going to work, it sorts based on the first word of the keyword phrase.

best laptops for nursing
laptops for nursing
good laptops for nursing

all 3 are the same but will not get sorted together.
Click to expand...
Now i see, I didn't think it that way. I only read till the part where OP wrote wrong spellings. So I thought this might help since it will place the wrong spelling one's right next to right spelling one's. Hope the above suggested sites by other users provide any help.
 
Scrapebox does this. You can import a list of keywords in a txt file and remove the dupes. There’s also a bunch of other options in the right hand menu of the software.
 
It has to be done manually. I have tried all the techniques listed here, none of them will give you a refined list.
 
DeadJoe said:
This is not going to work, it sorts based on the first word of the keyword phrase.

best laptops for nursing
laptops for nursing
good laptops for nursing

all 3 are the same but will not get sorted together.
Click to expand...

Exactly! Sounds Like @DeadJoe Really Understands the Problem!
 
I don't think there's a tool out there that does this to my knowledge. If you have any programming knowledge it could be done. Off the top of my head, I'd probably approach it this way:
Add all keywords to an array
Take the next entry, calculate all permutations of the keyword string (there are algorithms out there to do this easily), removing the original of course
Take each of these permutations, go through the array and delete any matches
Repeat for each remaining array entries

Filtering the spelling errors would require something else, but personally I'd probably keep them.
 
Clustering tools are very basic, and won't do this for you either. You need to go through the list manually and group related keywords. It's a pain in the ass, but it is the only way to get the job done. Alternatively, you can hire a freelancer and ask them to do this for you.
 
export the rows from the spreadsheet to a csv
with php, python, bash or anything really, parse each line and order by keyword
then remove any repeats,,
this is a for loop or foreach loop through an array
 
DeadJoe said:
Clustering tools are very basic, and won't do this for you either. You need to go through the list manually and group related keywords. It's a pain in the ass, but it is the only way to get the job done. Alternatively, you can hire a freelancer and ask them to do this for you.
Click to expand...
What is the exact instruction you Tell him to do?
 
Benji1 said:
What is the exact instruction you Tell him to do?
Click to expand...

Tell them you are looking for keywords/phrases that mean the same thing. Use Teamviewer, share your screen and show them what you are doing. Do it 2 or 3 times and then ask him to do it on his computer while you watch. It is not rocket science, if a freelancer isn't able to understand the process with this level of assistance, then you should just fire them and find someone else.
 
Advertise on BHW
You must log in or register to reply here.
Sign up now!

Main Menu

Home Main Forum List Black Hat SEO White Hat SEO BHW Newbie Guide Blogging Black Hat Tools Social Media Downloads

Marketplace

Account Selling Content / Copywriting EBooks / Methods Hosting Misc Proxies For Sale SEO - Link building SEO - Packages Social Media Social Media - Panels Web Design More

Making Money

Affiliate Programs Hire a Freelancer IM Journeys Making Money Pay Per Click Site Flipping Want to Buy

BlackHat World

Dispute Resolution Forum Suggestions & Feedback Introductions Lounge
Back
Top