Link to home
Start Free TrialLog in
Avatar of WeThotUWasAToad

asked on

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


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.

Avatar of Shaun Vermaak
Shaun Vermaak
Flag of Australia image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of WeThotUWasAToad


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