Import Firefox History
It's possible to import your history from Firefox into the History Trends Unlimited Chrome extension. Follow the steps below:
- Before you begin, you should back up your history in History Trends Unlimited, so you can restore it if something goes awry.
- Find out where your Firefox Profile directory is located: In Firefox, visit about:profiles, find the section for your profile, and make a note of the "Root Directory".
- Install "DB Browser for SQLite" for your operating system from here: http://sqlitebrowser.org/
- Close Firefox.
- Open the DB Browser, click "Open Database". Navigate to the "Root Directory" for your Profile and open the "places.sqlite" file.
- Click the "Execute SQL" tab.
- Copy and paste the following SQL into the SQL box:
- SELECT moz_places.url, 'U' || (moz_historyvisits.visit_date/1000), CASE moz_historyvisits.visit_type WHEN 1 THEN 'link' WHEN 2 THEN 'typed' WHEN 3 THEN 'auto_bookmark' ELSE 'unknown' END, moz_places.title FROM moz_places, moz_historyvisits WHERE moz_places.id = moz_historyvisits.place_id ORDER BY moz_places.url
- Click the play icon (Execute SQL). The results should appear below.
- Click the button underneath the results and select "Export to CSV".
- Uncheck the "Column names in the first line" checkbox.
- Select Tab as the Field Separator.
- Select the blank option for Quote character.
- Select Windows for New line characters.
- Click Ok.
- Select a location to the save the file and click Save.
- Finally, import the file into History Trends Unlimited via the "Import History" section in the Options page.