Use this basic Keyword List cleaner to scrub copied lists from Amazon, Yasiv.com and Goodreads, and any other websites.
When you click 'Format' the cleaner will replace hyphens (-) and slashes (/) with spaces and remove all other non alphanumeric characters.
If you want particular words (like 'kindle') removed you can list them by going into Settings.
The cleaner will automatically limit the keyword phrases to 10 words and/or 80 characters as per AMS requirements.
Then just Ctrl-A, Ctrl-X to take the list over to your excel sheet to alphabetise for de-duping and removing star counts etc.
Oh - and don't try with more than 1000 records - it gets tied up in knots sometimes if you do.
(And no, I don't know what the tick-box, top left, does. Just don't tick it.)
When you click 'Format' the cleaner will replace hyphens (-) and slashes (/) with spaces and remove all other non alphanumeric characters.
If you want particular words (like 'kindle') removed you can list them by going into Settings.
The cleaner will automatically limit the keyword phrases to 10 words and/or 80 characters as per AMS requirements.
Then just Ctrl-A, Ctrl-X to take the list over to your excel sheet to alphabetise for de-duping and removing star counts etc.
Oh - and don't try with more than 1000 records - it gets tied up in knots sometimes if you do.
(And no, I don't know what the tick-box, top left, does. Just don't tick it.)
© 2018 Jon Gifford, Oleander Press