Export From RoboForm to KeePass

RoboForm is a fantastic program, but the fact that it doesn’t run on Linux is a major problem for me. KeePass seems like the best alternative, but it does not currently support a direct import from RoboForm. I have almost 140 passwords, many of which consist of 10-30 random characters. Typing these in manually would be a major headache, so here’s the best hack that I found.

• Download the trial version of PassCrypt
• Import your RoboForm data to PassCrypt
• Export your newly imported data from PassCrypt to a CSV file. You don’t need the headings.
• Download a CSV file editor - I recommend CSVed
• Once you’ve installed CSVed - go to Tools, Options, Double Quotes. Click the box next to “Save CSV File With Double Quotes”. If you don’t select this, your import will fail. KeePass requires that the data is between double quotes. If you try to use Excel it will strip the quotes from the file and the import will fail. Believe me on this one - I’m saving you a lot of time and trouble.
• Open the CSV file you exported from PassCrypt in CSVed to modify the file.
• Put your columns in the following order: “Account”,”Login Name”,”Password”,”Web Site”,”Comments”. You don’t need these column headings in your CSV file - you just need the columns in this order.
• If you have any ampersands (&) in you passwords - do a find and replace in CSVed to replace all instances of & with &. It appears as if PassCrypt did this during the export to CSV.
  • Update 8/6/2007: At some point the WordPress WYSIWYG mangled my post in regards to HTML special characters. The bullet point above may have problems with the display of ampersands. The idea is that during the process of moving passwords from one program to another, the ampersands in your passwords may be replaced by the html character code. This will obviously cause your passwords to not work. Thanks to skibum mark for the heads-up.
• You may notice that many of your usernames or passwords are missing from the exported file. This is because RoboForm captures these values from websites that use different terms to identify them. One may be “username” while one may be “logonid”. You’ll have to manually enter these missing values in CSVed or wait until the file is imported into KeePass.

I told you it was a hack. Someone needs to write a plugin to import passwords directly from RoboForm into KeePass. Until then - use the steps above. If there is enough interest I’ll put together a better tutorial with screenshots.

Found atchriskoester.net