@Ali_Flaming, do you mean that you’d like the export to be human-readable text instead of binary? Hitting the data set report page’s underlying API endpoint from the browser will give you a human-readable JSON representation of the data set report. For example, assuming you’re logged into the demo instance of DHIS2, opening https://play.dhis2.org/2.36.10/api/dataSetReport?filter=&ds=vc6nF5yZsPR&pe=2020SatW09&ou=ImspTQPwCqd&selectedUnitOnly=false from your browser will give you:
[
{
"title":"HIV testing and counseling HIV age",
"subtitle":"Sierra Leone W9 2020Sat 2020",
"headers":[
{
"name":"Data element",
"column":"Data element",
"type":"java.lang.String",
"hidden":false,
"meta":true
},
{
"name":"<15y",
"column":"<15y",
"type":"java.lang.String",
"hidden":false,
"meta":false
},
{
"name":"15-24y",
"column":"15-24y",
"type":"java.lang.String",
"hidden":false,
"meta":false
},
{
"name":"25-49y",
"column":"25-49y",
"type":"java.lang.String",
"hidden":false,
"meta":false
},
{
"name":">49y",
"column":">49y",
"type":"java.lang.String",
"hidden":false,
"meta":false
},
{
"name":"Total",
"column":"Total",
"type":"java.lang.String",
"hidden":false,
"meta":false
}
],
"metaData":{
},
"rows":[
[
"HIV: currently on care",
null,
null,
null,
null,
null
],
[
"HIV: new on care",
null,
null,
null,
null,
null
],
[
"HIV: testing",
null,
null,
null,
null,
null
],
[
"HIV: counseling",
null,
null,
null,
null,
null
]
],
"height":4,
"headerWidth":6,
"width":6
}
]
You can then manually feed the JSON output into a tool which turns JSON into CSV so that the data set report is compatible with Excel (e.g., JSON to CSV Converter Online).