To export: go to your BGG collection page, click the ⋮ menu above your list, then Export Collection to CSV.