Hi,

Currently you can import .xlsx files only from a local or a network shared drive, not from S3.

If you have excel files in S3 and you want to still create a dataset from them you could look at a solution like the one described in this blog post.

hope this helps

There are two ways to do this, the easy way and the scalable way.

The Easy Way

Save your XLS as a CSV. Go into QuickSight datasets, click add data, click upload file. Done.

The Scalable Way

Convert your XLS to CSV. Put it into a designated S3 bucket. Run a Glue crawler on that bucket to create a table in Athena. Go into QuickSight, give it permissions to read from that bucket, click add data, add a datasource for Athena, find your table, and click save.