I created a list in SharePoint Online, I'm using the url to the list but I receive this error when trying to export from excel.
I figured it out...
Excel creates the list for you. Add the URL to the SITE where you want to create a new list.
To update, you should have the ability to select from the existing list.