I'm trying to extract data from a url but the site has a password. I know how to set up excel to go get the data but it's not working because of the password. Is there a workaround
It depends on how the password is transferred to authenticate with the website. You may need the Terminal app (with curl, for example) or a reverse proxy to help with the password authentication.