Proton Pass json export file -> KeePassXC import CSV

protonpass_to_keepassxc.js

#!/usr/bin/env node
const fs = require('fs');

function convertProtonPassToJson(protonPassJson) {
    // Parse the JSON input
    const data = JSON.parse(protonPassJson);

    // Define an array to hold CSV lines
    let csvLines = [];

    // CSV header line
    csvLines.push("Group,Title,Username,Password,URL,Notes,TOTP,Icon,Last Modified,Created");

    // Process each vault
    Object.values(data.vaults).forEach(vault => {
        // Skip the vault if its name is "Recycle Bin"
        if (vault.name === "Recycle Bin") {
            return;
        }

        // Process each item in the vault
        vault.items?.forEach(item => {
            const itemData = item.data.content;
            const modifiedTime = item.modifyTime ? new Date(item.modifyTime * 1000).toISOString() : '';
            const createdTime = item.createTime ? new Date(item.createTime * 1000).toISOString() : '';

            // Escaping newlines in notes
            const notesEscaped = item.data.metadata?.note.replace(/\n/g, '\\n').replace(/"/g, '\\"');
            const passwordEscaped = itemData?.password?.replace(/\\/g, '\\\\').replace(/"/g, '\\"');

            const line = [
                `"${vault.name}"`,
                `"${item.data.metadata?.name}"`,
                `"${itemData?.username}"`,
                `"${passwordEscaped}"`, // Using escaped password here
                `"${itemData?.urls?.join(', ')}"`,
                `"${notesEscaped}"`,
                `"${itemData?.totpUri || ''}"`,
                `"${modifiedTime}"`,
                `"${createdTime}"`
            ].join(',');

            csvLines.push(line);
        });
    });

    // Join all lines to create CSV text
    return csvLines.join('\n');
}

// Get the file path from command line arguments
const inputFilePath = process.argv[2];
const outputFilePath = process.argv[3];
if (!inputFilePath || !outputFilePath) {
    console.error("Please provide an input file path and an output file path.");
    process.exit(1);
}

const protonPassJson = fs.readFileSync(inputFilePath, 'utf8');
const csvData = convertProtonPassToJson(protonPassJson);
fs.writeFileSync(outputFilePath, csvData);
console.log(`CSV data written to ${outputFilePath}`);

@nikspyratos Installed node and npm from Ubuntu repo's today. node -v returns 12.22.9

@swdrumm That's definitely not the latest. Long story short Ubuntu usually pegs some or other stable-but-not-modern version of things. Look at nvm and installing latest node.

For ref, my node -v returns 18.16.0

@nikspyratos OK, thanks. I'll upgrade node.js to a version that supports optional chaining.

@nikspyratos Works great with the latest version of node.js
I didn't realize the Ubuntu repo version was that old. Thanks for the help!

@nikspyratos
I made a fork of this script that fixes a bug with how Proton Pass uses their JSON tags.
fork: https://gist.github.com/TheMeaner0/cb54486fc5748734a829a3181fa6e0bf

Also these scripts might be useless soon, because I also told KeePassXC team about fixing the soon to come proton-pass importing feature.

Good stuff @TheMeaner0!

This script is pretty unsupported now from my side.