Amazon and eBay/PayPal into Excel?
Amazon and eBay/PayPal into Excel?
Author
Discussion

paulrockliffe

Original Poster:

16,677 posts

258 months

Wednesday 29th August 2018
quotequote all
Any experts know if I can do something simple to automatically pull transactions out of Amazon/eBay/PayPal into an Excel spreadsheet?

I'm building an update to my accounting spreadsheet, as a learning thing partly, but also as a Man Maths evidence-base for future use. The basic principle is that I categorise bank transactions then build Pivot Tables. I have a few methods for categorising transactions automatically, but I always end up with a big list of stuff from Amazon etc that I can't deal with.

If I can pull the transactions directly into Excel, I can match them up to the bank statements automatically and start dropping in item descriptions and them create a lookup table and start getting those automated too.

But I don't know if it's possible, or where to start. Google keeps sending me to stuff for sellers rather than purchasers.

Thanks