Forum Discussion
How to transfer data from a web page to spreadsheet
Hello community,
I am still learning excel and am in need of suggestions. I am currently trying to transfer client data to a spreadsheet that will automatically refresh when I open up the sheet. However, this data come from PayPal and requires me to login w/password each time there to access the information.
Is it possible for me to still transfer this client data from PayPal to an Excel spreadsheet, and, is there a way to update it/refresh the information each day?
I've tried using the data tab in excel and clicking on the web page icon. I keep getting stuck when it tries to connect with PayPal.
Using windows 10 & Excel 365
Thank you.
I am still learning excel and am in need of suggestions. I am currently trying to transfer client data to a spreadsheet that will automatically refresh when I open up the sheet. However, this data come from PayPal and requires me to login w/password each time there to access the information.
Is it possible for me to still transfer this client data from PayPal to an Excel spreadsheet, and, is there a way to update it/refresh the information each day?
I've tried using the data tab in excel and clicking on the web page icon. I keep getting stuck when it tries to connect with PayPal.
Using windows 10 & Excel 365
Thank you.
1 Reply
- Perhaps this gets you started: https://www.myonlinetraininghub.com/connecting-to-an-oauth-api-like-paypal-with-power-query
