How to transfer data from a web page to spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2542658%22%20slang%3D%22en-US%22%3EHow%20to%20transfer%20data%20from%20a%20web%20page%20to%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2542658%22%20slang%3D%22en-US%22%3EHello%20community%2C%3CBR%20%2F%3EI%20am%20still%20learning%20excel%20and%20am%20in%20need%20of%20suggestions.%20I%20am%20currently%20trying%20to%20transfer%20client%20data%20to%20a%20spreadsheet%20that%20will%20automatically%20refresh%20when%20I%20open%20up%20the%20sheet.%20However%2C%20this%20data%20come%20from%20PayPal%20and%20requires%20me%20to%20login%20w%2Fpassword%20each%20time%20there%20to%20access%20the%20information.%3CBR%20%2F%3EIs%20it%20possible%20for%20me%20to%20still%20transfer%20this%20client%20data%20from%20PayPal%20to%20an%20Excel%20spreadsheet%2C%20and%2C%20is%20there%20a%20way%20to%20update%20it%2Frefresh%20the%20information%20each%20day%3F%3CBR%20%2F%3EI've%20tried%20using%20the%20data%20tab%20in%20excel%20and%20clicking%20on%20the%20web%20page%20icon.%20I%20keep%20getting%20stuck%20when%20it%20tries%20to%20connect%20with%20PayPal.%3CBR%20%2F%3EUsing%20windows%2010%20%26amp%3B%20Excel%20365%3CBR%20%2F%3EThank%20you.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2542658%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2542787%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20transfer%20data%20from%20a%20web%20page%20to%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2542787%22%20slang%3D%22en-US%22%3EPerhaps%20this%20gets%20you%20started%3A%20%3CA%20href%3D%22https%3A%2F%2Fwww.myonlinetraininghub.com%2Fconnecting-to-an-oauth-api-like-paypal-with-power-query%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.myonlinetraininghub.com%2Fconnecting-to-an-oauth-api-like-paypal-with-power-query%3C%2FA%3E%3C%2FLINGO-BODY%3E
Visitor
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.
1 Reply