Convert a LastPass CSV export to keepassx using Go lang.

lastpass_to_keepassx.go

package main

import (
  "encoding/csv"
  "fmt"
  "io"
  "os"
  "strings"
  "html"
)

func main() {
  file, error := os.Open("lastpass.csv")
  if error != nil {
    fmt.Println("Error:", error)
    return
  }

  defer file.Close()
  reader := csv.NewReader(file)
  lineCount := 0

  fmt.Printf("<!DOCTYPE KEEPASSX_DATABASE>\n")
  fmt.Printf("<database>\n")
  fmt.Printf("  <group>\n")
  fmt.Printf("    <title>Main</title>\n")

  for {
    record, error := reader.Read()

    if error == io.EOF {
      break
    } else if error != nil {
      fmt.Println("Error:", error)
      return
    }

    // url,username,password,extra,name,grouping,fav
    url := html.EscapeString(strings.TrimSpace(record[0]))
    username := html.EscapeString(strings.TrimSpace(record[1]))
    password := html.EscapeString(record[2])
    name := html.EscapeString(record[4])
    // group := html.EscapeString(record[5])


    fmt.Printf("      <entry>\n")
    fmt.Printf("        <title>%s</title>\n", name)
    fmt.Printf("        <username>%s</username>\n", username)
    fmt.Printf("        <password>%s</password>\n", password)
    fmt.Printf("        <url>%s</url>\n", url)
    fmt.Printf("        <comment></comment>\n")
    fmt.Printf("      </entry>\n")


    lineCount += 1
  }

  fmt.Printf("  </group>\n")
  fmt.Printf("</database>\n")
}