Sometimes users have a backed-up copy of a Chrome History database and they want to extract its history and get the data into HTU. Follow these instructions to do just that.
Before you begin, you should back up your history in History Trends Unlimited, so you can restore it if something goes awry.
Install "DB Browser for SQLite" for your operating system from here: http://sqlitebrowser.org/
Open DB Browser for SQLite
Click Open Database and select the History database you want to extract data from.
Click the "Execute SQL" tab.
Copy/paste the following query into the SQL text box:
SELECT IFNULL( u.url, '' ) as url, IFNULL( visit_time, '' ) as visit_time, v.transition & 15 as transition_type, IFNULL( u.title, '' ) as title FROM urls u INNER JOIN visits v ON u.id = v.url;
Click the play button above the sql box to execute the SQL. The results will appear below the SQL.
Click the "Save the results view" button above the sql box and select "Export to CSV".
In the dialog that pops up, do the following
Uncheck "Column names in the first" line.
Select Tab as the separator.
Select the blank option for Quote character.
Select Windows for New line characters.
Click Save, choose a directory, enter a filename, and click Save again.
Take the file you just created and import that into HTU on the Options page.