Home

Windows

• Password File: %APPDATA%\cocoon-password-manager\passwords.json

Password Manager JSON Conversion Prompt

Task

Convert the password data from my Excel file into a structured JSON format suitable for a password manager application.

Required JSON Structure

Generate a JSON object with the following structure:

• Root object containing an "entries" array and a "next_id" field
• Each entry should have: id, title, username, password, url, notes, created_at
• Use incremental IDs starting from 1
• Set created_at to current timestamp in ISO 8601 format with timezone
• Set url and notes to null if not provided in the source data

Input Data Format

My Excel file contains password information in key-value pairs with columns like:

• Service/Title
• Username/Email
• Password
• URL (optional)
• Notes (optional)

Expected Output Format

{
  "entries": [
    {
      "id": 1,
      "title": "service_name",
      "username": "username_or_email",
      "password": "actual_password",
      "url": "https://example.com" or null,
      "notes": "any_notes" or null,
      "created_at": "2025-06-24T10:30:00.000000000+00:00"
    }
  ],
  "next_id": 2
}

Instructions

1. Read through all the password entries in my Excel data
2. Convert each row into the JSON entry format above
3. Auto-increment the ID for each entry
4. Use the current date/time for created_at timestamps
5. Set next_id to be one higher than the last entry ID
6. Preserve all original passwords exactly as they appear
7. If title is empty or missing, use the username value as the title
8. If other fields are empty or missing, set them to null

Please process my Excel data and return the complete JSON structure.