To protect your privacy: email us with billing or account questions instead of posting here.

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

alexiaa
alexiaa
Community Member
edited June 2021 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_ana
    ag_ana
    1Password Alumni
    edited June 2021

    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

  • ag_ana
    ag_ana
    1Password Alumni

    @nyuszika7h:

    I wanted to send you a quick update to let you know that our developers have recently looked at this and tested a fix, which has been released already:

    The CSV importer now preserves the integrity of columns while handling csv files. {12475}

    Thank you again for reporting this :+1:

This discussion has been closed.