If you're thinking of finally switching over to KeePassX, don't sweat the export out of LastPass. Be aware the import into KeePassX can be finicky if you don't know how to format it correctly.

So why would you want to do this? Have you noticed that LastPass now has a phone recovery option that was never intended by the original company who created the service? That's a little spooky considering the original LastPass creators always swore they had zero ability to correlate you vs. your last pass master key data.

LastPass provides several password list export methods, least of all directly from your account. They also provide multiple specific applications that will also export a .csv file for you. Unfortunately, KeePassX will require some very specific settings to import that password list file. Here's how to do it with just two tools: LibreOffice and KeyPassX itself.

Create a new csv file in LibreCalc. You MUST include the five heading titles as indicated in the KeePass documentation that include (from left to right):

Group (optional)
Login Name
Web Site

Copy your exported data from LastPass into the appropriate columns in the new file with the KeePass headers (don't include the extra content from LastPass). At this point you're ready to format the .csv file.

Keep in mind that your data must include a single set of quotations around each entry, aka #"#, and a delineating comma, aka #,# between each set of quoted items in the new file. FYI: the pound/number sign used here is simply for illustrative purposes since "'" is extremely difficult to read and copy.

In LibreOffice Calc:

  1. Double check you have 5 columns as described above.

  2. Select everything, right-click and select 'Format Cells'.

  3. In the dialog, choose Text as category. Click [OK].

  4. Go 'File' -> 'Save As...', choose a location and the 'Text CSV' file type, and make sure that the check box 'Edit Filter Settings' is enabled. Click the 'Save' button.

  5. Choose 'Unicode (UTF-8)' as character set.

  6. The field separator must be set to a comma.

  7. The text separator must be quotation.

  8. Mark 'Quote all text cells' option.

  9. Ensure 'Fixed column width' option is not checked. Click [OK].

  10. Save the new file. Don't overwrite the existing.

If you need help managing your passwords or migrating from less-than-secure online password services and are interested in your own secure local or NextCloud database, contact us; we love to help!



About the Writer
Chris Lessley
Author: Chris Lessley
A server admin, dev ops warrior and website designer since 2002, Chris is a lover of all things Linux and open-source! Each blog topic has been tested by fire in the real world and shared with the hope to help others. Need more help? Hire me! Chris' other interests include fine art and the humanities in the classical tradition and can be found writing for our friends over at gripfastart.works. If you like this content, kindly consider donating to keep this website free to all, without ads.

Comments powered by CComment

Member of The Internet Defense LeagueOpen Source Initiative