Support Exporting D1 Data in JSON & CSV Formats with Encoding Options

[dev-itzarun]

Describe the solution

Currently, wrangler d1 export supports exporting schema and data in SQL format only.
It would be very helpful if wrangler could support alternative export formats such as JSON and CSV, with encoding options like UTF-8.

This would simplify integration with analytics tools, data migration pipelines, and applications that require structured data without the need for additional SQL parsing.

---

✅ New Proposed Options

Export full D1 database in JSON

npx wrangler d1 export <database_name> --remote --format=json --output=./database.json

Export single table in JSON

npx wrangler d1 export <database_name> --remote --table=<table_name> --format=json --output=./table.json

Export full D1 database in CSV (UTF-8 encoding)

npx wrangler d1 export <database_name> --remote --format=csv --encoding=utf-8 --output=./database.csv

Export single table in CSV (UTF-8 encoding)

npx wrangler d1 export <database_name> --remote --table=<table_name> --format=csv --encoding=utf-8 --output=./table.csv

---

Benefits

• Interoperability: Makes it easier to use D1 data with BI tools, data warehouses, or other databases.
• Flexibility: Users can choose the format best suited for their workflows.
• Ease of migration: JSON/CSV exports are widely supported in data pipelines.
• Encoding control: UTF-8 ensures proper handling of multilingual and special characters.

---

👉 This feature would bring first-class data portability to Cloudflare D1 and save developers from building custom export utilities.

---

[dev-itzarun]

Any Updates Regarding this ?

[dev-itzarun]

Any Updates Regarding this ?