How to import Bitdefender Wallet into Bitwarden

Hello everybody

I just created a Bitwarden account because I want to stop using Bitdefender Wallet.

I searched the official support and community forum on how to import my Bitdefender Wallet data into Bitwarden Vault and found nothing.

The import options in the Bitwarden web interface are specific to third-party commercial software, and there is no option for Bitdefender Wallet.

Could someone help me how to import this data?

Thanks

Perhaps this is of help:

https://sourceforge.net/p/keepass/discussion/329221/thread/4f9c217ea0/

TL;DR: Export a .csv file.

@Eduardo Export your data in .csv format, then open the .csv file in Excel, and copy the column headers. Paste the list of column headers here, and await further instructions.

Thanks for you help grb.
Here is the header in Row 1 Colunm A:
modelType,“modelVersion”,“title”,“url”,“username”,“password”,“notes”,“favorite”,“firstName”,“lastName”,“country”,“zip”,“city”,“street”,“street2”,“company”,“county”,“region”,“email”,“phoneNumber”,“text”,“color”,“name”,“cardName”,“number”,“securityCode”,“pinCode”,“type”,“expirationDateMonth”,“expirationDateYear”

Thanks for your suggestion Robert.

1 Like

:warning: Edit: I just noticed this detail in your response:

If all of these field names are actually grouped together in Column A as you say, then something went wrong when you opened the .csv file in Excel. Excel should be able to read a .csv file such that Row 1 would have modelType in Column A, modelVersion in Column B, title in Column C, url in Column D, etc.

Please try again, and let me know if there are any dialogs or other messages that appear when you try open the file in Excel.

If you are able to open the .csv file properly, in the form of a spreadsheet with 30 columns (A-AD), then please provide responses to the follow-up questions below:


Does the column “modelType” describe what type of item it is (login, credit card, etc.)? If so, what values are shown there for vault items that are logins, and what values are shown for vault items that are secure notes? Please be advised that you will not be able to import anything that is not a login or a note.

Also, please confirm that the column named “title” contains the name used to describe each vault item.

Exported again the wallet data base and when I imported to excel the columns headers were different from the first time. Now are these:

Type – Name – Location (url) – User – Password – Extra 1 – Extra 2 – Extra 3 – Extra 4

Description of each one that I could grasp:

Type: app – card – myinfo – website – wifi

Name: just an indicative of the name of the application/card name/identity name/website name/wi-fi network

Location: credit card number/identity address/url of the site

User: credicard holder name/and user for all other types

Password: credicard secutiry code/ and password for all other types

Extra 1: credit card valid until date/ myinfo email address

Extra 2: no entries on my wallet

Extra 3: credit card PIN

Extra 4: no entries on my wallet

I hope that my new inputs could help you to help me to import my BD Wallet to Bitwarden.

Thanks

Thank you. Make a copy of your exported .csv file (let’s name the copied file “Conditioned.csv”), and then make the following changes in the Condition.csv file:

  • Change the column header Type to type (all lowercase).
  • Change the column header Name to name (all lowercase).
  • Change the column header Location (url) to login_uri (all lowercase).
  • Change the column header User to login_username (all lowercase).
  • Change the column header Password to login_password (all lowercase).
  • Change the column header Extra 1 to notes (all lowercase).
  • Delete columns Extra 2, Extra 3, and Extra 4.

Next, in the type column, replace all values that say website with the new value login; replace any values that say myinfo with the new value note (I’m assuming that the “myinfo” type is the label used for a secure note, and that the note contents have been exported into column Extra 1). Also delete any rows that have the value card in the type column (credit cards cannot be imported into Bitwarden using the .csv format).

You can decide whether to also delete the rows that have type values of app and wifi. It is possible that one or both of these types could be successfully imported as logins, if you change the type value to login.

Ensure that the .csv does not contain blank rows interspersed with non-blank rows, then save the modified version of Conditioned.csv.

Next, follow these steps to import the data into Bitwarden:

  1. Log in the the Web Vault.

  2. Click “Tools” in the top navigation bar, and then click “Import data” in the lefthand navigation menu.

  3. Under “File Format”, select “Bitwarden (csv)”.

  4. Click the Choose File button, then select the Conditioned.csv file in the file picker, and click “Open”.

  5. Click Import Data, and wait for the success message (which should say something to the effect that “A total of _N_ items were imported”), then click “OK”.

  6. Click on the account profile icon in the upper right corner, and select “Account Settings”.

  7. Scroll down to the section titled “Danger Zone”, and click on “Deauthorize Sessions”.

  8. In the pop-up window, enter your master password and click “Deauthorize Sessions”.

  9. Log back in on all of your apps.

2 Likes

Thank you very much for your help.
On the sites I’ve already managed to test, your instructions worked perfectly, and I don’t imagine I’ll have problems on the others either.
Best regards!

2 Likes

Hey grb,

I came across this post when I was searching for how to import bitdefender wallet into bitwarden. The only problem is eduardo’s second version of format on his csv is different from mine. It was most similar to the first one he sent. My headers look like this:

modelType - modelVersion - title - firstName - lastName - country - zip - city - street - street2 - company - county - region - email - phoneNumber - notes - url - username - password - favorite - text - color - name - cardName - number - securityCode - pinCode - type - expirationDateMonth - expirationDateYear

where:

modelType - what’s under it is: Identity, Account, Note and CreditCard

modelVersion - just the numbers 1 and 3

title - name for the entry

firstName - per the heading

lastName

country

zip

city

street

street2

company

county

region

email

phoneNumber

notes

url

username

password

favorite - I’m guessing TRUE and FALSE goes here because everything was set to FALSE

text

color

–everything below here is credit card-related info–

name - title name for the entry

cardName - per the heading

number

securityCode

pinCode - card number again for some reason

type - the only two entries says “generic card”

expirationDate

expirationYear

–

I hope I detailed it as much as possible.

I apologize for re-igniting the thread, I just do not want to start a new one when there is just a recent one already.

I hope you can help me out, thank you in advance!

@winngggg Welcome to the forum! I will try my best to help.

Please note that you will only be able to import login items (which I assume are the items for which the “modelType” value is set to “Account”) and secure notes (presumably the items with “modelType” set to “Note”).

Are you comfortable with importing a .csv file into Excel, and using Excel to sort by specified columns? (If you need help with sorting in Excel, see here.) I would suggest that you start by getting rid of all Credit Card and Identity items (but first make a backup of your .csv export, so that you don’t lose the Credit Card and Identity information; you will need to transfer these manually). One way to remove those items would be to sort the spreadsheet rows alphabetically by the modelType column, then highlight all rows that have CreditCard or Identity in the modelType column, and then right-click one of the highlighted rows and select “Delete”.

Then, look for any columns that are empty (except for the column header) and delete those — e.g., by highlighting the empty column, then right-clicking the highlighted column and selecting “Delete”.

After you have completed the above, please let me know which columns remain. It should probably be just modelType, modelVersion, title, notes, url, username, password, and favorite, but please confirm. Also, please let me know if you still see two different values (1 and 3) in the modelVersion column, and if so, whether you notice anything different in the row contents for items with modelVersion=1 vs. modelVersion=3.

1 Like

@grb I did what you told me and the columns that are left are: modelType, modelVersion, title, url, username, password and favorite.

Turns out the modelVersion=1 are Notes type of account which I only have two of, so I just discarded them since they are not important anyway.

I’m ready for the next step to complete my transfer to Bitwarden. Thanks for helping!

You can go ahead and delete the modelVersion column, too, then.

Have I understood correctly that all of remaining rows have the value Account in the modelType column, and that all of these records correspond to login information for online accounts?

If so, please proceed as follows:

  1. Change the column names as follows (making sure to use all lowercase letters):
    a. modelType ⇒ type
    b. title ⇒ name
    c. url ⇒ login_uri
    d. username ⇒ login_username
    e. password ⇒ login_password

  2. In the type column, change the value Account ⇒ login (all lowercase).

  3. In the favorite column, change the value FALSE to the number 0.

  4. Add the following new column headers in the first row, starting in the 7th column (which should be the first empty column, immediately after the favorite column): folder,notes,fields,reprompt,login_totp (all lowercase).

  5. Save the .csv file.

 

Is your Bitwarden vault completely empty? Or at least, can you confirm that none of the records that exist in your Bitwarden vaults correspond to the items that are in you .csv file? If records already exist in your Bitwarden vault, then the import process may create duplicate entries.

If your Bitwarden vault is empty, then proceed as follows:

  1. Log in to the Web Vault.

  2. Click “Tools” in the top navigation bar, and then click “Import data” in the lefthand navigation menu.

  3. Under “File Format”, select “Bitwarden (csv)”.

  4. Click the Choose File button, then select the .csv file from Step #5 in the file picker, and click “Open”.

  5. Click Import Data, and wait for the success message (which should say that “A total of N items were imported”, where N should correspond to the number of items in your .csv file), then click “OK”.

  6. Click on the account profile icon in the upper right corner, and select “Account Settings”.

  7. Scroll down to the section titled “Danger Zone”, and click on “Deauthorize Sessions”.

  8. In the pop-up window, enter your master password and click “Deauthorize Sessions”.

  9. Log back in on all of your apps.

1 Like

It worked! Every single entry that I have managed to make it in. Thank you very much, I really appreciate your help! Now I don’t have to manually enter all the data like I planned.

Hopefully this thread will help other people that are migrating to Bitwarden. Thanks again @grb! :smile:

You’re welcome, glad I was able to help!

For the benefit of future readers of this thread, please note that Bitdefender Wallet .csv exports evidently come in at least two flavors, and the import instructions differ for each case:

  • If the exported .csv file has the headers Type, Name, Location (url), User, Password, Extra 1, Extra 2, Extra 3, Extra 4, then you should follow the instructions in this comment.

  • If the exported .csv file has the headers modelType, modelVersion, title, firstName, lastName, country, zip, city, street, street2, company, county, region, email, phoneNumber, notes, url, username, password, favorite, text, color, name, cardName, number, securityCode, pinCode, type, expirationDate, expirationYear, then you should follow the instructions here (Part 1) and here (Part 2).

2 Likes