Option to import from Microsoft Authenticator

Feature Requests Password Manager
22

I had written this above:

For those who don’t want to click on links, here are the full instructions:

  1. Open the exported file in Excel, and ensure that you can see three columns with the column headers url, username, and password.
  2. Go to Save As, and save the file under a different name. Ensure that the selected file type is “CSV UTF-8 (Comma delimited) (*.csv)”.
  3. Change the header of the url column to login_uri instead of url. Ensure that the new column title is all lowercase, and ends with i (not l) .
  4. Change the header of the username column to login_username (all lowercase) instead of username.
  5. Change the header of the password column to login_password (all lowercase) instead of password.
  6. Add a 4th column (Column D), and name it type (all lowercase). Copy and paste the word login (all lowercase) into every element of the type column (from the second row to the row that has the last login item from your old vault).
  7. Make 6 empty columns (Columns E-J), and name the column headers as follows: folder, favorite, notes, fields, reprompt, login_totp (all lowercase).
  8. Insert an empty column (Column A) just before the login_uri column, and give this column the title name (all lowercase).
  9. Assuming that the login_uri column is now the second column (Column B), enter the following Excel formula in the first empty cell of the first column (Cell A2):*
=IF(ISNUMBER(SEARCH("www",B2)), PROPER(MID(B2, FIND("://",B2)+7, IFERROR(FIND("/",B2,FIND("://",B2)+7), LEN(B2)+1) - FIND("://",B2) - 7)),PROPER(MID(B2, FIND("://", B2) + 3, IFERROR(FIND("/", B2, FIND("://", B2) + 3), LEN(B2) + 1) - FIND("://", B2) - 3)))
  1. Copy the Excel formula from Cell A2, and paste it into all remaining cells in Column A (starting at A3, and ending at the last row of your exported data).
  2. Save the file after making all the above changes.
  3. If the contents of your vault need to be cleared to start over from a clean slate (e.g., because you made prior import attempts that created unusable vault items), then log in to the Bitwarden Web Vault, and choose the option to Purge your vault (it’s advisable to first create a JSON or ZIP export of your Bitwarden vault, in case you later realize that some of the vault contents should not have been deleted). Log out, log back in, and verify that your vault is completely empty.
  4. Import the new CSV file, selecting Bitwarden CSV as the file format.

Please heed the previous warning that Microsoft Authenticator exports do not include any TOTP authentication keys, so make sure that you keep your Microsoft Authenticator account until you have manually reset the TOTP keys for all of your accounts.

 

*Credit to Reddit users Alatrix and RexNocti for contributing to the development of the Excel formula used in Step #9.

2 Likes
23

Nail1684 thanks for pointing this out to me…I previously skipped over those older posts

1 Like
24

Brilliant, it works!
BTW my variand the formula for the name cell:

=IF(
  ISNUMBER(SEARCH("@", B2)),
  MID(B2, SEARCH("@", B2) + 1, IFERROR(FIND("/", B2, SEARCH("@", B2)), LEN(B2) + 1) - SEARCH("@", B2) - 1),
  MID(B2, FIND("://", B2) + 3, IFERROR(FIND("/", B2, FIND("://", B2) + 3), LEN(B2) + 1) - FIND("://", B2) - 3)
) & " (" & TRIM(C2) & ")"
1 Like