Forum Discussion

Former Member's avatar
Former Member
3 years ago

Password export process will not export password that start with the + character

Password export process will not export password that start with the + character. The export toll shows #NAME? instead of the actual password.

1Password Version: Not Provided
Extension Version: Not Provided
OS Version: Not Provided
Browser:_ Not Provided
Referrer: forum-search:https://1password.community/search?Search=Password%20export%20process%20will%20not%20export%20password%20that%20start%20with%20the%20%2B%20character

windows

2 Replies

Sort By
  • Ekalb's avatar
    Ekalb
    Super Contributor
    3 years ago

    Hello,
    With "my" Excel, I see the sign + (Excel 2016, French version).
    I don't have a "=" sign before the password. Unlike you, "my" Excel therefore does not consider it to be a formula.
    Do you still have the problem if while converting the data you change the Password column to text format?

  • ag_mike_d's avatar
    ag_mike_d
    Icon for 1Password Team rank1Password Team
    3 years ago

    Hello @gcsturtevant,

    Thanks for your message and sorry for the troubles you have encountered when exporting a password starting with a +.

    It sounds like you are referring to a CSV export in Excel. I've done some testing and see the same results when viewing an exported file. If this is the case, the password is displayed in the formula bar as depicted below and the issue is related to how Excel is viewing the data in the field following the = in this example:

    When viewing an exported 1Password CSV file elsewhere, Google Sheets for example, I see the password displayed as expected:

    I hope this information helps, but if you need further assistance, do not hesitate to contact us. We'll be here for you!