How to use SQLite with Chrome

Google Chrome: Read out autofill information under Chrome

01 Use the database editor DB Browser for SQLite

Chrome stores the related information in the database Web data in his profile directory. The default path on Windows is % LOCALAPPDATA% \ Google \ Chrome \ User Data \ Default. The file can be opened with a suitable program, for example the free database editor DB Browser for SQLite, open and browse.

The open source tool has a GUI and is also available in a portable version. Simply download this program from the manufacturer's website, run it and specify the folder for the extracted files. You can then start the software directly from the last setup window.

  1. DB Browser for SQLite
    The free database editor DB Browser for SQLite can be used to open and search the Chrome database. The tool is also available as a portable app.
  2. DB Browser for SQLite
    Start the download from the manufacturer's website and save the EXE file.
  3. DB Browser for SQLite
    Then navigate to the download directory in the file manager and call up the executable file.
  4. DB Browser for SQLite
    A wizard will start and guide you through the next steps.
  5. DB Browser for SQLite
    The portable variant only needs the specification of a folder into which the program files are to be copied.
  6. DB Browser for SQLite
    From the last setup dialog you have the option of starting the database editor directly.
  7. DB Browser for SQLite
    To load the Google Chrome database, first click on "Open Database" in the DB Browser for SQLite.
  8. DB Browser for SQLite
    Then enter the path to the "Web Data" file in the top line of the dialog box. Finally press the Enter key.
  9. DB Browser for SQLite
    So that you can see the file, select "All Files" from the pull-down menu in the lower right-hand corner of the window.
  10. DB Browser for SQLite
    Now mark the file and click on "Open".
  11. DB Browser for SQLite
    When the file is loaded, navigate to the "Browse Data" tab. Select "autofill" as the table.
  12. DB Browser for SQLite
    If you have a large amount of data, you don't have to deal with SQL queries. Instead, you can also export the table in CSV format and then evaluate it in a spreadsheet.

02 Find and display Autofill information in the database

Now click on the button in the database editor Open Database, type in the top line of the Open dialog box % LOCALAPPDATA% \ Google \ Chrome \ User Data \ Default and press Enter. Choose from the pull-down menu All filesand open the file Web data.

To see the information you are looking for, switch to the tab Browse data and select the table from the drop-down list autofill out. If the number of entries is too large, it makes little sense to go through them manually. If you don't want to create SQL queries, you can export the table as a CSV file, which can then be searched in Microsoft Excel or Calc from OpenOffice / LibreOffice, for example. (hal)