We have been using the API from our account for a while now to create a link between the data in Kobo and our excel sheets.
(We followed this tutorial: http://support.kobotoolbox.org/en/articles/1559346-pulling-your-data-into-excel-power-query)
However, recently we have noticed that the data does not come in a chronological order any more.
That is, before our excel sheets where being filled by the questionnaire´s start date. This is however no longer the case and the new data is registered sometimes at the top of the excel sheet, sometimes at the bottom. And so far we haven´t figured out what logic the data is following.
As you can imagine, this renders the tracking of our data collection quite difficult.
Does anybody know how to return to the “old way” so that the data follows again the chronological order of the start date?
Is there a way to define/program this somewhere?
Any help would be appreciated!
We’re using Excel 2016 with the function “getting data from web”.