Search code examples
excelamazon-web-servicesimportamazon-dynamodb

Is it possible to Import data in AWS DynamoDB from Excel file?

I have made an excel file with some ~200-300 rows, and I would like to import the data in DynamoDB.

To be clear, I have just created an empty table with just the Primary key & Sort key. So in all, I have only 2 fields in DynamoDB table, but 12 in my Excel file.

I want to import the excel data to the table, so all the 200-300 rows appear in my DynamoDB.
Is it possible to fill an empty DynamoDB table with an excel file?

Any help is appreciated :)
Thanks!

Solution

  • For this, you can store your excel file to S3 bucket. then create a AWS Lambda function to read your excel file from S3 bucket and create correct response format as your DynamoDB structure.