How to enable autofill feature on Windows and how to use Bitwarden with Brave on Android?

Ask the Community Password Manager
,
12

Since you said previously that your Bitwarden vault contains “many,many duplicates of same accounts”, these duplicates must also be present in the Bitwarden.csv file. Perhaps you forgot to re-sort the file using the “name” column before checking for duplicates.

Also, I assume that the one entry in Bitwarden.csv that had a non-blank entry in the “login_uri” column was your username and password for this community forum.

In any case, I would suggest that you proceed as follows:

  1. Make a copy of your “Chrome Passwords.csv” file; let’s call it “Conditioned.csv”.

  2. Open “Conditioned.csv” in Excel, and change the column names as follows (making sure to use all lowercase letters):
    a. url ⇒ login_uri
    b. username ⇒ login_username
    c. password ⇒ login_password

  3. In Excel, select all of the data in the spreadsheet (including the column headers), using Ctrl+A, then click on the Data tab, and look for an icon labelled “Data Tools” in the ribbon (it should be to the right of the “Sort” and “Filter” icons); click the “Data Tools” icon, and then click “Remove Duplicates” to bring up a small window for deleting duplicate entries. In this small window, check the checkbox labeled “My data has headers”. Finally, uncheck the checkmark in front of the column name, and ensure that a checkmark is placed in front of the column names login_uri, login_username and login_password, then click “OK”. Make a note of how many duplicate values were removed, and how many unique values remain (this information will be displayed in a success message).

  4. Make a 5th column by entering the column title type (lowercase) to the right of the login_password column. For every (non-empty) row that remains in the spreadsheet, enter the value login (lowercase) into the type column. You can do this quickly by entering the value once, copying that cell, then selecting the remaining cells in the type column and pressing Ctrl+V.

  5. Save the file, then close it.

  6. Make a copy of your “Bitwarden.csv” file; let’s call it “BWkeep.csv”.

  7. Open “BWkeep.csv” in Excel.

  8. Using the method described previously, select all of the data, open the “Sort” tool, and check “My data has headers”. In the “Sort by” dropdown, select “type”; also change the Order from “A to Z” to “Z to A”. Then, click the + Add Level button, which creates a second “Sort by” selector; in this second “Sort by” dropdown, select “login_uri”; leave the Order as “A to Z”. Then click “OK”.

  9. Look in the type column, and check whether you have any rows where the type value is note instead of login. Count the number of such rows if you find any, and let me know.

  10. Select all rows in which the type column says login and the login_uri column is empty. Delete those rows.

  11. Save the file, then close it.

 

In principle, you are now ready to purge your vault contents and re-import the two .csv files. However, before we continue, let’s take stock of how things went with the instructions above.