When exporting data from Formshare, for each of the variables, there are additional empty columns with the previous variable name + the suffix ‘-desc’ even if you select codes only during download. Although one could drop these empty columns during cleaning since they are empty, but ideally for the sake of the team, this unnecessary columns should not be added unless one generates an Excel report with codes and labels for categorical variables. Currently, there is no option during export to exclude these columns.
I have included a sample of the exported file below, in which I highlighted few of those columns in grey.
infrastructure_20230910.xlsx
When exporting data from Formshare, for each of the variables, there are additional empty columns with the previous variable name + the suffix ‘-desc’ even if you select codes only during download. Although one could drop these empty columns during cleaning since they are empty, but ideally for the sake of the team, this unnecessary columns should not be added unless one generates an Excel report with codes and labels for categorical variables. Currently, there is no option during export to exclude these columns.
I have included a sample of the exported file below, in which I highlighted few of those columns in grey. infrastructure_20230910.xlsx