Best way to export data as CSV or excel format?

Hi @aitor_garrido,

Thank you for your post!

Please see this video presentation from Tracker Use Academy (URL at time of explanation):

The fastest would be to use the API and you will also be able to choose whether you want JSON, CSV, xls, or even gzip! Please see the docs: Tracker - Using the API | DHIS2 Documentation

Additionally, if you have the report ready in the Events Reports app then you can get the API request from the Network tab. I explain the process in video below but here are the written instructions too.

First, before you click on ‘update’, open the browser’s developers’ tools (F12) and then click on Network. You will see the Network tab empty at first. Second, click on the Update in the Event Reports app and you will see that a couple of requests were recorded in the Network tab. Look for the request that has query in it such as (https://play.dhis2.org/2.37.3/api/29/analytics/events/query/eBAyeGv0exc.json?dimension=pe:THIS_QUARTER;LAST_QUARTER&dimension=ou:ImspTQPwCqd&stage=Zj7UnCAulEk&displayProperty=NAME&outputType=EVENT&desc=eventdate&pageSize=100&page=1) . Third, copy the url and you can choose how many items to include by changing the pageSize parameter, and you can choose whether you want XML, JSON, CSV, or XLS by changing the format that appears before the question mark (‘?’) in the URL.

chrome_M30DaOmgBl

2 Likes