Automating bookmark clean up in Chrome

I am wondering if anyone has ideas of how to automate years of bad bookmark management clean up.

I am using Chrome and would like to try and clean up the bookmarks that I have bulk imported from other browsers of the years. I have basically done no management on them so far so, so there are probably a couple hundred to thousands, with a lot of duplicates. (yea I know, not a great plan)

At one point I was basically using them as my Youtube watch later list and my PKM. So some of them I can just nuke but some of the web pages I would like to migrate into my PKM (OneNote) eventually.

My original plan was to try and get them into an excel/ Google sheets doc so I can eliminate the duplicates. Then worry about figuring out a way to use the webclipper to save them to my PKM.

I rummaged around of IFTT but didn’t come up with anything that jumped off the page as the solution. I did find a service called Linkhut I am going to go exploring.

I have not explored Microsoft flow or other options yet.

Any ideas on along this chain would be greatly appreciated.

Chrome stores it’s bookmarks in a .json file in your profile directory, so for Windows that should be AppData\Local\Google\Chrome\User Data\Default , according to a quick Google search. You can import JSON directly into excel: https://www.thewindowsclub.com/how-to-convert-json-to-excel-csv :slightly_smiling_face: