Which CSV option should I use to import TeamPassword exported logins?

Ask the Community Password Manager
,
1

Which CSV import option will read TeamPassword exported CSV files?

I’ve exported my logins from TeamPassword and want to import them into BitWarden but there is no option in the drop down for TeamPassword. I tried another CSV option (Universal Password Manager (csv)) but that failed.

There are 39 CSV import options. Rather than try each one I thought I’d ask the community and thereby provide an answer to the next person trying to do the same.

If it helps, the TeamPassword CSV columns are

name,url,username,password,notes,organization,group
2

@Bernhard Welcome to the forum!

Could you explain how you are using the “Organization” and “Group” column data, and specify whether it is important for you to retain (or approximate) this functionality in Bitwarden?

Were you planning to import this CSV file into your individual Bitwarden vault, or into an organization vault?

1 Like
3

Hi @grb

Thank you for the warm welcome.

I believe those (organisation and group) columns are the only two columns that are not vital to us so we could strip them from the CSV file if necessary.

I would be looking to import the nearly 500 items into a organisation vault. Users will also want to import their own exports to their own vaults. I have about 25 private logins to import to my own vault for example.

4

Create a copy of the CSV file and change the following column titles:

  • url → login_uri (all lowercase; note that the last character is i, not l)
  • username → login_username (all lowercase)
  • password → login_password (all lowercase)

For CSV files that are to be imported into individual vaults, create the following 6 additional columns (all column titles must be lowercase):

  • folder
  • favorite
  • type
  • fields
  • reprompt
  • login_totp

Optionally (and if applicable), use the information in the columns named organization and/or group to populate the newly created folder column (otherwise, leave this column blank).

For CSV files that are to be imported into the organization vault, create the following 5 additional columns (all column titles must be lowercase):

  • collections
  • type
  • fields
  • reprompt
  • login_totp

Optionally (and if applicable), use the information in the columns named organization and/or group to populate the newly created collections column (otherwise, leave this column blank).

Now delete the organization and group columns.

Finally, in the column titled type, for every nonempty row (except the column title row), enter the word login (all lowercase).

Save the file, and import it into your vault, using the format option “Bitwarden (csv)” .

2 Likes
5

Thanks so much @grb. I’ve also been sent a link to Condition a Bitwarden .csv or .json | Bitwarden Help Center from the sales team (since I’m evaluating BitWarden as an alternative) that might also help others.

6

You’re welcome. Yes, the instructions that I provided above are just an adaptation of the general information in the Help Center article, customized to your particular situation.