Skip to content

Instantly share code, notes, and snippets.

@mzheng

mzheng/venmo_csv.txt

Last active August 27, 2021 16:01
Show Gist options
  • Star 7 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mzheng/615c9fe328d416f5e8e9e6c7f5f6f6a9 to your computer and use it in GitHub Desktop.
Save mzheng/615c9fe328d416f5e8e9e6c7f5f6f6a9 to your computer and use it in GitHub Desktop.
Download ZIP
Download Venmo Transactions as CSV
Raw
venmo_csv.txt
Prerequisite
JQ: brew install jq
Chrome/Safari Inspector
Log in and open https://venmo.com/#yours
Open Chrome/Safari Inspector
Go to Network Tab and filter for 'feed'
Right click and Save "feed" as "venmo_feed.json"
Run in Terminal:
cat venmo_feed.json | jq '.data[] | {actor: .actor.name, target: .transactions[0].target.name, type: .type, message: .message, date: .created_time, amount: .transactions[0].amount}' | jq -s -r '(map(keys) | add | unique) as $cols | map(. as $row | $cols | map($row[.])) as $rows | $cols, $rows[] | @csv' > venmo_feed.csv
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment