Avatar of WeThotUWasAToad
WeThotUWasAToad
 asked on

Merge two Google Chrome Bookmark files or convert Excel list into an HTML file

Hello,

How can I get a list of URLs in Excel into an HTML file to import into the Google Chrome Bookmark Manager?

After running Windows 7 for a few years, I recently upgraded to Windows 10 and at the same time, upgraded to a larger C Drive.  The previous C Drive is now Drive F.

I found somewhere online that Chrome bookmarks are saved in a file called Bookmarks which resides in this folder:

      C:\Users\Username\AppData\Local\Google\Chrome\User Data\Default

I've located that file as well as the old (much larger) file in the same directory on the F Drive but now how do I merge the two?

I tried opening the smaller file with Notepad but it's a mess (ie lots of code) but then I found that by opening Chrome's Bookmark Manager and Selecting All, I could copy all the bookmarks to Excel as a nice neat list of familiar-looking URLs. But trying that process in reverse to get them merged doesn't work.

Under the Organize heading in the Bookmark Manager is an option to:

        Import bookmarks from HTML file...

so that's why I'm wondering if I can convert the Excel list of URLs to an HTML file.

Thanks
GoogleHTMLWeb BrowsersMicrosoft ExcelGoogle Chrome OS

Avatar of undefined
Last Comment
WeThotUWasAToad

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Shaun Vermaak

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
WeThotUWasAToad

ASKER
Thanks for the suggestion Shaun.

I actually do not use the cloud for anything besides sending large files to people using dropbox.  I don't remember if I've mentioned it to you but I'm a quadriplegic and therefore in front of my desktop pretty much all of the time.  In other words, I don't/can't use a cell phone or any other portable devices so I do not have the mobility needs of others which make the cloud so convenient/important.

However, with that said, I'm open to uploading my bookmarks to some location if doing so will enable me to merge them and then download them as a single file.  Also, I unfortunately cannot boot from the F Drive.  My nephew (who built my system) explained why that is the case a while back but I don't remember the details now.

Even so, I don't really need to be able to take that step because it's easy to designate either file in my current Chrome directory simply by changing the file name. So if you could explain a bit more about the steps to uploading and address the question I raised about merging the files while they're floating around up there, that might be the solution I'm looking for.

Thanks again
WeThotUWasAToad

ASKER
I opted to input the links one-at-a-time by use of an AutoHotkey script.  It took a few minutes but was certainly quicker than doing it manually.  Thanks
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23