Using a S3 bucket (containing 1 .xlsx) as Data Source

Good afternoon! I uploaded a .XLSX into a S3 bucket and would like to use the bucket as a data source for Q.

Can a manifest file specify a .xlsx for import? Here is my manifest json. How does it look?

{
    "fileLocations": [
        {
            "URIs": [
                "s3://linzin8001/xls_AIRBNB_2021_all_months.xlsx"
            ]
        }
    ],
    "globalUploadSettings": {
        "format": "XLSX",
        "containsHeader": "true"
    }
}

Thanks in advance! :slight_smile:

Hi Lin,

Welcome to Amazon QuickSight Community!

Please refer to the below link for supported file formats. The documentation also provides samples for the s3 manifest files.
supported-manifest-file-format

Alternatively, you can also upload your .XLSX file directly using the “Upload a File” option while creating a new dataset.

2 Likes

You might have to change it to be csv. I wrote a blog long time ago to auto change it: Ingest Excel data automatically into Amazon QuickSight | AWS Big Data Blog

2 Likes

so xlsx as a format is not supported via a manifest file, correct ?

I would like to request this to be a new feature to be supported.