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
MrC's avatar
MrC
Super Contributor
4 years ago

Ah, that's the difference, Boosh ,

Each of the Categories has different "templates". And those templates have different field names internally, as well as field counts. CSV was never designed to have varying numbers of columns. So the 1Password CSV exporter creates a column for every field you ask, and for certain fields, a value can be mapped into multiple columns.

So your best bet is to export one Category at a time.

There is a way to get your data in a nice, tabular format, but I'm thinking it is going to be more work than you are care to undertake. Sample:

or

So I'm trying to help find a way that's easy for you.

That said, you're right. It's rather pointless to use a secure password manager, and then store such data in an unencrypted plain text document.