I have read the article https://support.kobotoolbox.org/pulling_data_into_excelquery.html?highlight=automatically%20download%20files however i am still a bit unsure of how to proceed.
When i use the Get csv option i can download a csv but I have two issues 1) if i give the form url with .csv into the web browser the csv downloads, however if I use a new blank excel-Data-From web-url.csv i get the error The webpage cannot be found
any advice on this is appreciated.
My second issue is that the csv option allows a mixture of data labels and data values to be downloaded rather than just data values
When I download the data manually I choose csv and XML values and headers, which gives me the desired output
How can I get the csv to download with the XML values and headers?