Download Table data as a CSV from Convex Dashboard | Convex Community | Page 1

gleaming yew Jun 20, 2024, 4:18 PM

#

Wanted to know if there is a way I can export my database table to a csv or something?
Would be nice if it was in the popover in the attached image

#

Download Table data as a CSV from Convex Dashboard

sharp sedge Jun 20, 2024, 4:35 PM

#

Hey Hosna! There are two ways to export data right now:

Select documents in the UI (with the checkbox). Then right click inside of the table and press "Copy Documents". This will copy them into your clipboard as JSON. This does not work if you have 1000s of documents.
Use a snapshot export (can be done from the dashboard or the command line) https://docs.convex.dev/database/import-export/export

#

It's common enough for developers to look for an export button in that drop-down menu. I'm filing an issue for us to at least have a link to snapshot export there 🙂

gleaming yew Jun 20, 2024, 4:41 PM

#

Awesome yes was looking for snapshot export, thank you @sharp sedge !

gleaming yew Jun 25, 2024, 4:52 PM

#

@sharp sedge is there a way to also export the items in the Files tab?

sharp sedge Jun 25, 2024, 4:53 PM

#

Absolutely! On the snapshot export page, you can click the "Include files" checkbox, and the export will include all of your files

gleaming yew Jun 25, 2024, 4:53 PM

#

oh duh 🤦‍♀️
thank you

#

one more question @sharp sedge 😅

so the included files have the name of the id in the db, is the original name of the files not preserved? I noticed when you initially uploaded the images its there under the id but when you refresh in the page they go away. and I don't see the original names of the images in the documents.jsonl file

#Download Table data as a CSV from Convex Dashboard