@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”
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.
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:
Log in the the Web Vault.
Click “Tools” in the top navigation bar, and then click “Import data” in the lefthand navigation menu.
Under “File Format”, select “Bitwarden (csv)”.
Click the Choose File button, then select the Conditioned.csv file in the file picker, and click “Open”.
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”.
Click on the account profile icon in the upper right corner, and select “Account Settings”.
Scroll down to the section titled “Danger Zone”, and click on “Deauthorize Sessions”.
In the pop-up window, enter your master password and click “Deauthorize Sessions”.
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!
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.
@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.
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:
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
In the type column, change the value Account ⇒ login (all lowercase).
In the favorite column, change the value FALSE to the number 0.
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).
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:
Log in to the Web Vault.
Click “Tools” in the top navigation bar, and then click “Import data” in the lefthand navigation menu.
Under “File Format”, select “Bitwarden (csv)”.
Click the Choose File button, then select the .csv file from Step #5 in the file picker, and click “Open”.
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”.
Click on the account profile icon in the upper right corner, and select “Account Settings”.
Scroll down to the section titled “Danger Zone”, and click on “Deauthorize Sessions”.
In the pop-up window, enter your master password and click “Deauthorize Sessions”.
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!
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).