Skip to content

Instantly share code, notes, and snippets.

Last active August 27, 2021 16:01
  • Star 7 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
What would you like to do?
Download Venmo Transactions as CSV
JQ: brew install jq
Chrome/Safari Inspector
Log in and open
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:, target: .transactions[0], 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