How can i import an .xlsx File located in S3 Bucket in my quicksight?

0

Is it possible? Because in this file it says that the only valid file formats are csv and json. https://docs.aws.amazon.com/quicksight/latest/user/supported-manifest-file-format.html But when i upload the file directly .xlsx is allowed. Please help. Thank you

質問済み 2年前4327ビュー
2回答
0

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

AWS
エキスパート
回答済み 2年前
-1

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.

AWS
回答済み 2年前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ