How 1password deal with csv file?

Hi
Our team is planning using 1password to manage our team's password. we want to import csv file to 1password. but the separate isn't what we expect. so I wonder how 1password deal with csv file.


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

Comments

  • GregGreg

    Team Member

    Hi @Grace,

    You can learn how to create a 1Password compatible CSV file in this article on our website. We have a sample CSV file there, so please check it out and compare it with yours.

    Let me know if this is what you need. If it is not, any additional info about your situation will be appreciated. Thank you! :) :+1:

    ++
    Greg

  • MrCMrC Community Moderator

    @Grace

    If the native 1Password CSV importer doesn't work for your needs, you can use the csv converter in the converter suite . With it you can tell it which field separator to use. I'm assuming you are using Tab rather than Comma.

  • brentybrenty

    Team Member

    @Grace: As mentioned in the article Greg linked above, a CSV will need to have fields in the following order for importing Login items into 1Password:

    title,website,username,password,notes,custom field 1,custom field 2, custom field …

    Yours appears to be the following:

    Application(?), Username, Password, Environment(?), Target Server Name, etc.

  • hi, we don't want to use "field" as the name of the field, because we want to use some meaning words to be displayed, can we customize the custom field name , since there are hundreds of logins for our project, we don't want to change it one by one. is there a simple way to change all items? I attach image for reference.

  • MrCMrC Community Moderator

    @Grace,

    The csv converter in the converter suite allows for custom names of your custom fields. All fields that are non-stock 1Password fields (i.e. those that are not part of a 1Password category template) will be assigned the custom names you've provided in the CSV header row.

  • MrCMrC Community Moderator
    edited July 11

    @Grace,

    The csv converter in the converter suite allows for custom names of your custom fields. All fields that are non-stock 1Password fields (i.e. those that are not part of a 1Password category template) will be assigned the custom names you've provided in the CSV header row.

    You can see the result below in the animated gif, which shows the same record imported twice, once without custom field mappings (whereby these go to Notes), and once with custom fields being added:

    The commands run were:

    perl convert.pl csv -v ~/Desktop/grace.csv
    
    perl convert.pl csv -v ~/Desktop/grace.csv --addfields
    

    Note: I changed one field name, which happened to collide with the pre-defined Membership field (Expiration Date), but this can be worked-around trivially. I also changed your Target Server Name field label so that the value would get mapped into 1Password's URL field for the Login (presuming this is what you're expecting). This too can be worked-around if you don't want that behavior.

Leave a Comment

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