Discussion in 'Black Hat SEO Tools' started by rankore, Jul 23, 2014.
Which is the best email manager, for free hopefully. Need to clean my lists of duplicate emails etc.
I'd use Openoffice Calc (free) or Excel (if you're minted)
Sort the list alphabetically, then in the column next to it (Column B most likely) do an "If" command
If A2 = A1;"Duplicate";"Unique"
Then copy column B and paste back over itself as "Value Only"
Then sort by column B alphabetically. This will separate all the dupes from the unique - the delete the block of duplicates (they will be in one block easy to delete)
Other stuff like sorting my email provider, sporting alphabetically, splitting the list etc. All done in a few seconds in a spread-sheet. You can even send email from within Excel these days.
Not the idea solution, and there is software out there that will do more for you. But Openoffice is 100% free and most list manipulation is a cinch once you've cracked 2 or 3 principles.
Thanks Scritty, that was really helpful for me as well!
Separate names with a comma.