1Password 8 Please Export More Fields to CSV

rckingsley

I meant to respond to this the other day, but was a bit backlogged with other projects, and it slipped my mind. I can't speak for the 1Password folks, yet I'd imagine that having a better CSV export is on their likely lengthy To Do list.

There are a couple of workarounds that you may be able to employ for your personal needs. I don't imagine these, however, would be terribly practical for your older clients (unless you can help them).

The 1PUX export file is a simple zip archive of the exported account's vaults (yes, it contains all the vaults in the account). Inside, there is a readable, unencrypted text file that contains the fields and values of all the items, per vault, for the account. There is also a folder that contains the documents that have been uploaded into the vault(s), named such they match ID values of the associated items in the vault. And there is one additional small metadata file that describes the export (so that an import can know what to expect). All of the important content is included in the 1PUX; in other words, the export is sufficiently complete and comprehensive. You cannot get this rich content in a CSV export.

That said, you can obtain a print out of the the export contents, because the primary file is a simple JSON structured text file, and of course you can print a text file. But you may not "appreciate" the format (and reformatting this structured data may be unfamiliar to you). Still, its an easily searchable text file, so finding some critical username / password is possible, and it's certainly easier than scanning a lengthy CSV print out.

Here's an screenshot of an example dump of a 1PUX I generated from a 1PUX created by my converter suite (using a quick tool I wrote to dump the 1PUX contents to the terminal for quick viewing):

I mention this level of detail, so you can perhaps rest easier knowing that you can get your data out of 1Password 8. You are not locked in, and so long as 1Password exports a 1PUX, it can easily be converted. I have no doubt that other password managers will soon support importing a 1PUX file - it's in their best interest to do so.

You mention concerns about better backups. You should feel more conformable having a 1PUX file as a backup. More so than CSV, as any CSV export will be quit lossy (on import back into 1Password, no file attachments/documents, lots of missing metadata). Just export a 1PUX, and be sure you secure it somehow (as it is of course, unencrypted). That's your best personal backup option.

Another method to extract the "rows" of data you desire is to use the 1Password command line tools. While not difficult to use, there is some learning curve. But you have more control over exactly which values you retrieve, and how you ultimately decide to output / format them.

I do realize you'll likely still want better CSV / print support, but until that time, I hope this helps a bit.