Skip to main content
brettn
November 25, 2021
Question

8. How to export to .csv???

  • November 25, 2021
  • 25 replies
  • 3453 views

Hi all :)

I want to export my vault as a backup to a .csv file.

When I try exporting I get a .1pux file (whatever that is??). Is it still possible to export to .csv? If not it is very disappointing! If yes, how?

Cheers


1Password Version: 8.4.1
Extension Version: Not Provided
OS Version: Windows 11

25 replies

January 26, 2022

Hi there, I need help. I have over 200 passwords on 1 password through my employer. After 7 years, I am leaving my job for a new job. I need all my passwords. Am I trapped in using 1 password forever???? I tried to export the file and it is encrypted PIF and cannot import it into chrome. Please help!!!

1P_PeterG
1Password Alum
January 27, 2022

Hi @Estelam, thanks for asking about this (and by the way, congrats on the new position!).

Your data is absolutely not going to be trapped in 1Password. We understand that your data is yours, and we're happy to help with any export needs you may have.

To catch you up on the current state of things: export functionality is still being built out for 1Password 8. This is because 1Password 8 was built from the ground up (so it's not that there used to be an export and we took it out, rather, a whole new thing had to be built).

In any case, there are a couple options you have for getting your data out as it currently stands:

  1. You can export in the 1PIF format, as you mentioned. This is essentially a JSON file that should be readable by other password managers (should their teams put a small amount of work into building import tools that can interpret it). However, we recognize there needs to be more than this - 1PIF was just the first step.

  2. Export to CSV - You can do this in 1Password 8 by switching your update channel to the Beta, updating the app, and logging out and back in just to make sure it's refreshed. Once that's done, you can choose export, then select the account you want to export, and pick the CSV file type.

(Given that this change has made it to the Beta, it follows as well that it will be coming relatively soon to a Stable update of 1Password, too - but I don't have a timeline to share on that yet).

  1. Optionally, you can also revert to 1Password 7, which can export to CSV or text file. If you'd like to take this option, we can help you with the process of rolling back to 1Password 7 to make it happen.

And 1Password 7 continues to be able to export to CSV as always, so if you're currently on that version, then no changes need be made. You can just export as usual.

We're going to be building out a more robust export feature in 1Password 8 as time goes on, likely including functionality that goes beyond what 1Password 7 can do. As of today, these options are what we can offer - as well as our personal customized assistance with any aspect of the export process you may need.

Your data is yours, and it's yours take to take with you.

January 27, 2022

This is driving me nuts because I want to download all of my passwords so that I can quickly change and add tags to them. I reverted back to 7 to be able to export as a CSV but I can't find the Export function. All I see is an Import function. Where is it?

January 27, 2022

Of course, as soon as I posted, I found an answer on https://1password.community/discussion/126453/export-data-problem#:%7E:text=if%20you're%20using%201password%207%2C%20follow%20these%20steps%3A

1P_PeterG
1Password Alum
January 28, 2022

Glad you've got what you need, @mrstoked - but if there's anything further, let us know and we'll be happy to assist!

Ramst3r
August 27, 2022

I have just read this thread in dismay. I cannot believe that 1Password have such contempt for it's existing customers as to push them into v8 without the ability for them to export THEIR data in full. This is the final straw for me. 1Password have lost the plot.

MrC
August 27, 2022

@Ramst3r

You can export your account vaults as 1PUX, which includes all of your data, as well as your documents.

Ramst3r
August 27, 2022

1PUX is some proprietary format that MAY be able to imported by another app, but is NOT one that I, as a non developer end user can easily access my data in, like a CSV format.

If 1Password were authentic in their claim that they respect that a customer's data is theirs then they would allow a customer to EASILY export ALL their data in a readily consumable and non proprietary format like CSV, Instead they only allow a limited set of data to be exported in CSV. There is no logical reason for this other than want to increase the friction for a customer to migrate elsewhere ... and it is exactly that attitude why, after 10 years, I unsubscribed today. I'll take the hit now and move on before I get further locked into to company that, of late, has demonstrated that it is more concerned with pretty icons, a clean UI and misrepresentation (that Agilebits claim v8 is an improvement is farcical in the context of the many downgrades it brings over v7). On top of all that they are now engaging archaic customer lock in tactics ... a clear sign that they have no confidence they can retain a customer by just delivering an ever improving product better than the rest.

MrC
August 27, 2022

You’ve gotta do what’s best for you. Stay safe out there, @Ramst3r .

October 17, 2022

Hi,
It's Oct 17, 2022, just under 1 year since the post near the top of this thread saying better export features are coming to version 8.

CSV export still only exports a handful of passport fields with record types like Server and others not being included in the export.

The PUX export may have all data but it's unreadable by a human. I looked up one of my 'Server' records. The name of the record is in 1 part of the file and the various fields are in a different part of the file. I was only able to locate it by looking for unique key words in the record.

Is there a way to import the PUX file into Word, Excel, etc that will make it usable?

I really thought after a full year we'd have export options that were available for years in the prior version.
Other useful features are also missing that the previous versions had like the ability to drag fields to reposition them, or change a field type without deleting it and being forced to create it at the bottom of the record.

I've been using 1Password for a decade and it's painful to see features and functionality disappear.