Amazon S3 or Amazon Simple Storage Service is a service offered by Amazon Web Services that provides object storage through a web service interface. Amazon S3 uses the same scalable storage infrastructure that Amazon.com uses to run its global e-commerce network.

To create a dataset using a Microsoft Excel file data source, upload a .xlsx file on AWS S3 from a local or networked drive.

1. Create a bucket on AWS S3.

upload a .xlsx file under a bucket and click on the upload.

Add a file or you can create a folder also.

The file has been uploaded on S3.

Now, you can choose any editor to fetch data from this s3. you can install Jupyter Notebook and libraries(boto3, pandas, Openpyxl).

1. Connect with S3 using boto3.

Fetch specific files from AWS S3 that you uploaded on S3.

Note — you can find the Access key ID and secret Access ID from the AWS console.

.