My improvement for importing data from "1Password"

There is already an article how to import your data from “1Password” into “Bitwarden”:

I tried importing my logins into “Bitwarden” but there are some things which are missing after the import or which didn’t work as I wanted the import function to work. So I had to do some things manually in Microsoft Excel after exporting my data from “1Password”.

I was using a computer with Windows 10 and “1Password v7” installed. So I only had the possibility to export as a CSV file.

Here are the steps I took:

  1. Select all login enries in “1Password” you want to export and chose “Export” when right clicking on them.
  2. Export CSV from “1Password”.
  3. Import CSV file into Microsoft Excel to check and edit exported data.
  4. If you are using German umlauts check exported CSV if they were exported correctly! Otherwise change characters manually.
  5. If you are using 2FA codes you should check if all TOTP-links are in the same column. Otherwise cut and paste the links into the column and rename this folder into “2FA”. “Bitwarden” doesn’t import 2FA codes correctly. But after importing into “Bitwarden” you now have the possibility to search for “2fa” as a filter and you will get all entries which include 2FA codes. Now you have to edit these entries and copy the otpauth-link into the field “Authenticator Key (TOTP)”. After saving the 2FA code is active and can be used as normal.
  6. If you are using tags in “1Password” and want to have them as folders in “Bitwarden” please be aware that you are only able to use one folder per entry. So you should only have one tag per entry. “Bitwarden” doesn’t detects tags from “1Password” and switches them to folders automatically. So just rename the column “TAGS” into “Folder”. After creating all folders manually in “Bitwarden” you also have to manually put the entries into the folders. Therefore you now find a custom field “Folder” in each entry. You only have to select this folder and delete the custom field afterwards.
  7. If you are using favorites and want to take them with you you should add the column “Favorite” at the end of all entries because “1Password” doesn’t export favorite status. Set the value to “IsFav” for your favorites. After importing into “Bitwarden” you are able to search for “IsFav” as a filter, mark every entry as favorite manually and delete the custom field.
  8. Export your data as a separator-separated CSV file from Microsoft Excel.
  9. Import your data into “Bitwarden” selecting “1Password 6 and 7 Windows (csv)” file.

Please be aware that there are a lot of values which are not imported correctly into “Bitwarden”! Mostly they are imported as custom fields. So please check complex entries before deleting them from “1Password”!

Also I only exported my logins from “1Password”. Secure Notes and other stuff I will create manually in “Bitwarden”!

I hope that this little guide helps importing your logins from “1Password” into “Bitwarden”. If you have any improvements just answer and I will take a look at my guide. :wink:

I wish I would have been aware of the tags → folder would have saved me a lot of time. Now I have no idea which entries are 2FA, 2FA-AppleID, 2FA-GoogleID from 1P into BW without doing this manually.

Sorry, @D_Y.
Indeed, it is a little tricky to move from “1Password” to “Bitwarden”. Hopefully this will be improved in the future.

1 Like

Hi @DenalB,
I am yet another 1Password user looking to migrate away to Bitwarden this year - largely due to the inept release of 1Password v8 (which I suspect is what’s driving many others)! Anyway as it’s been 18+ months since your discussion above, 1Password now exports pux files, and Bitwarden now can import pux files as well Import 1pux files from 1password; are the requirements around 1PW “Tags” vs. BW “Folders” and the 2FA Links still relevant do you know - if pux is used for the import?

Many TIA.

Hey @Mycenius ,

I have to say sorry, because I’m not able to test anymore. I switched back to 1Password some months ago.

Hi @Mycenius and welcome to the community :tada:

The 1pux importer maps a lot more item types and data then the previous 1pif importer.

A pretty extensive list of mappings/feature can be found on the Pull Request. I’d still love to hear what the community has to say about their experience with the 1pux import.

@DenalB Just curious, but may I ask if the reason to switch had anything to do with the import? (edit: I should have read your initial post opening this thread :see_no_evil:. Seems you migrating from 1password was a long time ago and yes things have definitely improved with the 1pux importer)

Here are detailed instructions on how to proceed with the import from 1password (1pif, 1pux, csv).

Kind regards,
Daniel

1 Like

No. The main reason to switch back was the lack of categories in Bitwarden.

In 1Password it looks like this:

And I’m using some of these categories:

A long time ago, I took part in a survey from Bitwarden where new categories were introduced, and I thought “Yes, that’s it!” But … It was a long time ago and nothing happened. So I switched back to 1Password.

But, never say never, and I’m willing to give Bitwarden another chance as soon as new categories are there. :wink:

Thank you for your feedback @DenalB

Additional item types are definetly planned, just had to clear up some tech debt, to make that easier to implement.

The current 1pux importer maps all of 1password’s item types into the existing Bitwarden ones (Mapping is detailed on the Pull Request I mentioned). Once we have additional item types, we’ll change the importer to map directly into the new ones.

1 Like

It would be more than great! :+1:

1 Like

OK Thanks @DenalB

1 Like

Thanks @djsmith85 - yes I successfully imported my 1Password vault into Bitwarden yesterday so am just familiarising myself with it at present - I let it import the pux file as is and just do its default process and it seems to have worked (I had not as yet enabled internal 2FA function in 1Password so didn’t have authenticator strings to worry about luckily so that made life pretty simple - I would have had them but when the dog’s breakfast that is “1Password v8” came out about April-May (2022) it put the breaks on that just as I was starting to look at it and as there are still unresolved broken features 8 months or so on in v8 - plus an unwillingness by 1PW to implement some basic logical functionality I’ve been asking about for 12 months - it’s made up my mind for me to move to BW).

I’m just familiarising myself with the use and will look to purchase a family or premium subscription once I’ve got my head around it’s operation…

My main interests to trial around functionality of BW over next couple of weeks are (and if you can point to any specific help articles or discussion threads on these would be appreciated):

  1. Options for using a PIN to access BW and functionality of app on Windows, macOS & iOS¹
  2. Integrations with Web Browsers (whether browser extensions or integral to iOS mobile app)¹
  3. The integrated 2FA Authenticator functions

¹ I run a Windows 10 PC, MacBook Pro (macOS), and an iPhone & iPad (iOS) and on all 4 of these devices I have Brave, Tor & Firefox/Mozilla as my web browsers; plus obviously Safari on the Apple devices, and on Windows I also use Chrome (solely for Gmail access) and on rare occasions Opera. So key for me that BW works well with all these different O/S x Browser combinations and supports PIN use on all 3 platforms I use.

Cheers

FWIW I’m a bit similar on this - although a few less categories but more than BW currently has - but I can live with less in the interim as moving away from 1PW, and finding a long-term replacement so I don’t need to migrate again, is more important to me than the extra categories…

:grinning:

1 Like

You can really make your own categories with BW. It does not look pretty, but, for example, I came from Roboform. They have a contacts category (among many more that I never used). So, what I did was to make a “Notes” folder and a “Contacts” folder. These are folders in the “Secure Note” category, like so;

When adding a new contact, it looks like this;

So, selecting “Secure Note” gives me all notes, selecting “Contacts” gives me only contacts. And because BW is so searchable, I find I really don’t care what folder they are in as a general rule.

1 Like

So I just imported my 1password 1pux file to Bitwarden and none of my stuff ended up in the proper categories. I have like 12 vaults for organizing my passwords on 1Password and when I imported it they all landed in the “no folder” not separating them out into their own folder

1 Like

@MrCaspan Welcome to the forum!

Bitwarden primarily organizes login items into folders, not “vaults”. I’ not familiar with 1Password, but apparently, organizing items in 1Password is done either using “vaults” or “tags” (or both?). It is possible that the 1pux importer in Bitwarden doesn’t recognize 1Password’s vaults or tags, because it may too difficult to determine whether the user would want the Bitwarden folder to correspond to the 1Password “vault” or “tag”.

The good news is that Bitwarden is definitely capable of importing passwords into different folders. The easiest way to do this is if your login and password data for each vault have been exported in CSV format instead of 1pux. You can then open each CSV file in Excel, and add a new column that you will name “folder” (writing folder in the first row of the column), and then pasting the vault name (i.e., the folder name) into each empty row of the “folder” column.

Next, you will need to add and delete a few columns, and modify some of the column names. It will be more efficient if you make these changes after combining the data from each vault export into a single CSV (after you have first added the folder column to identify which vault each login item belongs to). That way, you will only need to make the following changes once.

Add a new column, which you will name “type” (writing type in the first row of the column), and then pasting the word login into each empty row of the “type” column. In addition, delete the “Tags” column and the “Archived Status” column from the exported CSV (because this information cannot easily be imported into Bitwarden). Finally, rename the columns as follows (making sure to only use lower-case letters for the new column names):

1Password Column Name Bitwarden Column Name (Case-Sensitive)
New column folder
New column type
Title name
Website login_uri
Username login_username
Password login_password
One-time password login_totp
Favorite status favorite
Notes notes
Archived status Unused: Delete this column
Tags Unused: Delete this column

 

Save the resulting CSV file, then clear the contents of your Bitwarden vault (by going the the Web Vault and selecting Purge Vault), and import the new CSV using the Bitwarden CSV format.

2 Likes

Thanks for the reply, ouch we have an entire team coming from 1Password to BitWarden as our corporate tool. Am I going to have to do this for every single user (40 of them)?

Sorry also is there a way to wipe my account so I can test reimport all my data again from 1password and do as you suggested?

In general, the best strategy for importing will depend on the particulars of each user’s situation (i.e., what kind of vault item “types” you have, how the items are organized using tags or vaults in 1Password, etc.). I wrote the above guidance with the assumption that you are a single user who is storing only logins and passwords, and that you use different “vaults” as a way of organizing your logins by category.

Bitwarden does support enterprise solutions, including administration of users, access control, sharing of credentials, etc., but the details of how this is implemented in Bitwarden is likely different from how it is implemented in 1Password, which may affect the logistics of migration.

I would suggest contacting Bitwarden’s Support Team if you are already a customer, or their Enterprise Sales Team for pre-sale support.

To wipe your account, log in to the Web Vault app and use the Purge Vault option in the Account Settings.

It would seem that CSV export only exports Usernames & Passwords and nothing else so CSV is not an option

See my disclaimer above:

In any case, you can use the CSV method for passwords and logins, and then do a separate export for your other items. If you simultaneously want to deal with the “vault” organization problem and the issue of non-login item types, then you would have to look into using a conditioned JSON. Unless you have access to some good JSON editing utilities, or are adept at scripting code, you may be better off just using the 1pux importer and then manually organizing the imported items into folders. In the web vault, you have the ability to select multiple items and move them all at once into the same folder, so it should hopefully not be too much of a headache.

Oh its just a JSON file? Well that makes it simple. Ill have a look at that!

1 Like