Export CSV from StrongBox and import to Bitwarden: the TOTP problem

If you need to export your database from StrongBox to Bitwarden and you have some entries with the TOTP code, you need to change the value.

In the CSV export of Strongbox, you will find the column "OTPAUTH" with the strings like this:

otpauth://totp/PayPal:user@domain.com?secret=7HMDCMAC21TVBX4O&algorithm=SHA1&digits=6&period=30&issuer=PayPal

This string is not compatible with the format of Bitwarden "login_totp".

From this string you must keep only the TOTP seed, in this case

7HMDCMAC21TVBX4O

If you have multiple items, you can use this formula for extract the seed. In this example the string of Strongbox is in the E2 cell:

=MID(E2;SEARCH("secret=";E2)+7;SEARCH("&";E2;SEARCH("secret=";E2))-SEARCH("secret=";E2)-7) 

Comments

Popular posts from this blog

Kali linux/Debian: Failed to copy file from CD-ROM. Retry?

how change email on improvmx.com