How to clean a large list of keywords?

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!
 
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.
 
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!
I would suggest Keyword Surfer and KeyClusters.
 
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.

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.
 
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.
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.
 
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.

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
 
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.
What is the exact instruction you Tell him to do?
 
What is the exact instruction you Tell him to do?

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.
 
Back
Top