1Password CSV importer breaks if first column of CSV is sometimes empty

edited June 17 in Memberships

When I export my passwords from Bitwarden in CSV format, the first column is folder, which may have an empty value. When this is the case, the CSV importer on my.1password.com considers the first non-empty field to be the folder, thus causing everything to become horribly misaligned.

Here's a sample CSV file:

folder,favorite,type,name,notes,fields,login_uri,login_username,login_password,login_totp
,,login,1fichier,,API Key: XXXX,https://1fichier.com/,email,XXXX,
,,login,Adobe,,,https://www.adobe.com/,email,XXXX,
,,login,AliExpress,,,https://aliexpress.com/,email,XXXX,
,1,login,Amazon,,,https://www.amazon.com/,email,XXXX,otpauth://totp/Amazon:email?secret=XXXX&issuer=Amazon&algorithm=SHA1&digits=6
,,login,appdb,,,https://forum.appdb.to/,username,XXXX,
,1,login,Apple,"Backup code:

XXXX",App-specific password (Cydia Impactor): XXXX,https://appleid.apple.com/,email,XXXX," "
,,login,Atlassian,"Backup code:

XXXX",,https://id.atlassian.com/,email,XXXX,otpauth://totp/Atlassian:email?secret=XXXX&issuer=Atlassian
,,login,Barion,,,https://www.barion.com/,email,XXXX,

Running sed -i 's/^,/"x",/g' bitwarden_export_sample.csv allows the 1Password web importer to work correctly.

Before:

After:


1Password Version: Not Provided
Extension Version: Not Provided
OS Version: Not Provided
Sync Type: Not Provided

Comments

  • ag_anaag_ana

    Team Member
    edited June 17

    Hi @nyuszika7h!

    Thank you for reporting this! I was able to reproduce this issue on my machine, so I will open an internal issue so that the developers can look at this :)

    I have also edited the CSV data since it included your personal information, since this is a public forum :+1:

    ref: dev/b5/b5#12615

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file