Export dynamodb data as Excel files

Depending on what is your goal, I would look into 3 options:

1. If you want to just dump, a quick script in language you prefer would do the job
2. If you want to dump periodically, I would suggest to make Lambda out of it - here is a result of quick googling with working example: https://medium.com/@jrodl3r/exporting-dynamodb-data-to-excel-using-lambda-with-s3-on-aws-e6f873681c77
3. If you need to work dynamically with the given data, let`s say to slice & dice, filter, etc analyse it by users - consider using AWS Quicksight with DynamoDB as data source.

DynamoDB does not provide the ability to export the entire table to CSV, only a small sub-set.

The best way I have found is using Athena's capability to export to CSV, this is done using the

• Athena DynamoDB Conncector

The next suggestion approach is to come up with your own logic/script to export the table to CSV using Lambda and Event Bridge to periodically kick off the job. There are many tools available to assist you with converting JSON to CSV and even tools to do the entire process for you such as:

• NPM dynamodb-to-csv

And finally, if your table is really large you can use AWS Glue to run a periodic ETL job which will read from DynamoDB and export to CSV in an S3 Bucket:

• AWS Glue

Overall it depends on your specific use-case needs on which option to use.

I think the second option is the one we go with. Just dumping periodically. But this is more for sending it through email? is their a way to store it in ... a bucket?

I was planning to create a lambda with an Event bridge. And storing the file on aws S3. Should that be the best way? So we can download Excel files from the bucket or can we acces Excel in aws it self?