Forum Discussion

Boosh's avatar
Boosh
New Contributor
4 years ago

Need help exporting passwords to CSV for Excel

I need to export a dozen or so 1Password entries for a family member. They want it to look tidy and readable. So, I've exported the data to comma delimited text and then import it into Excel. But...
macos
Boosh's avatar
Boosh
New Contributor
4 years ago

I don't export tags. I only exported "Common Fields": First One-time Password,Notes,Password,Title,Type,URL,Username. I have no idea why they default to that order when exporting but it results in the categories being out of order in Excel.

In addition, entries get displaced to the wrong category. For example, some usernames got moved to the URL column, some secure notes and titles got moved to the Password column, URLs to Type column, etc. It's a jumble and that's just with 16 items. If I had exported dozens or hundreds of items, it would take an impossibly long time to fix.