# Download all dashboard data to csv?

**URL:** <https://forum.beeminder.com/t/download-all-dashboard-data-to-csv/9687>\
**Category:** Tech\
**Created:** [September 6, 2021, 4:59pm UTC](https://forum.beeminder.com/t/download-all-dashboard-data-to-csv/9687 "2021-09-06T16:59:01Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![coolhandlouis](https://avatars.discourse-cdn.com/v4/letter/c/c2a13f/32.png) [@coolhandlouis](https://forum.beeminder.com/u/coolhandlouis)\
**Post date:** [September 6, 2021, 4:59pm UTC](https://forum.beeminder.com/t/download-all-dashboard-data-to-csv/9687/1 "2021-09-06T16:59:01Z")

</div>

What would be the best or easiest way to download the dashboard info to a csv? I’d like to have: beeminder goal slug, goal units, short description, amount due, date-time due, pledge due.

This would help me in a number of ways. One thing that I have difficulty with is the relative importance of beeminders in terms of the amount due. So on any given day, I’d like to have these highlighted for me, which I can do in a spreadsheet. Also, it can be nice to work off a piece of paper or directly from a spreadsheet.

Also nice to have in the export would be the pledge cap from settings. Because derailing on a $5 goal with a $90 pledge cap is a higher priority than derailing on a $5 goal with a $5 pledge cap. And to be clear, I take all my goals seriously, but I might pay extra attention to getting the higher priority goal done earlier in the day.

---

<div class="post-metadata">

**Author:** ![adamwolf](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.beeminder.com/adamwolf/32/484_2.png) [@adamwolf](https://forum.beeminder.com/u/adamwolf)\
**Post date:** [September 6, 2021, 6:05pm UTC](https://forum.beeminder.com/t/download-all-dashboard-data-to-csv/9687/2 "2021-09-06T18:05:46Z")

</div>

I have a Google Sheets script that imports this stuff into a Google Sheet periodically, and has a refresh button. Lemme dig it up and see if it’s sharable.

---

<div class="post-metadata">

**Author:** ![lancemcdoogal](https://avatars.discourse-cdn.com/v4/letter/l/ed8c4c/32.png) [@lancemcdoogal](https://forum.beeminder.com/u/lancemcdoogal)\
**Post date:** [September 12, 2021, 9:20pm UTC](https://forum.beeminder.com/t/download-all-dashboard-data-to-csv/9687/3 "2021-09-12T21:20:51Z")

</div>

Have you linked the google sheet to the API? I would love to see how that’s done, if you’re willing to share it.

---

<div class="post-metadata">

**Author:** ![narthur](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.beeminder.com/narthur/32/5113_2.png) [@narthur](https://forum.beeminder.com/u/narthur)\
**Post date:** [September 18, 2021, 7:45pm UTC](https://forum.beeminder.com/t/download-all-dashboard-data-to-csv/9687/4 "2021-09-18T19:45:46Z")

</div>

This might get you started:

> [@Google Apps Script to import goals into spreadsheet](https://forum.beeminder.com/t/google-apps-script-to-import-goals-into-spreadsheet/7439):
>
> Just wrote some App Script code to import my Beeminder goals into a spreadsheet. To use: Open a sheet in a Google Sheets spreadsheet you want to overwrite (it will overwrite!). Click “Tools \> Script editor” Paste in the below code. On line 3 replace placeholders with your username and auth token. Click the run button in the toolbar. If asked, grant the requested permissions. The permissions requested allow the script to query Beeminder’s API and write to your spreadsheet. That’s it! function…