To load Excel file hosted on Amazon S3, if it’s publicly accessible you can load it as a remote Excel file.
Here is how you can import it.
Then select Remote tab and Excel.
Enter URL of the file.
Then click Save button.