I am Monitoring Officer in a no-profit organization.
I started using ODK Collect and Aggregate to survey some beneficiaries of
different training courses.
I can easily use all ODK tools, but I have some troubles in exporting data
from ODK Aggregate to an Excel form. ODK Aggregate did easily convert the
data but actually the Excel file that comes out is not useful, becasue all
the data are into one single cell...
Please find attached the Excel form exported from Aggregate.
How can I better export the data in Excel Form?
Do i need another programme?
You can open the CSV file using excel. Open Excel, go to the Data Tab,
Under "Get External Data", select "From Text", navigate to your file
and follow the wizard. The delimiter in this case is "comma". Note: If you have some text responses that have comma's in them, this
might throw off some rows.
You can also ge CSV data into other analytical tools in a similar fashion.
Kind regards,
···
On Monday, 3 October 2016 19:30:42 UTC+2, Francesco De Bonis wrote:
>
> Hello everybody,
>
> I am Monitoring Officer in a no-profit organization.
>
> I started using ODK Collect and Aggregate to survey some beneficiaries of
> different training courses.
>
> I can easily use all ODK tools, but I have some troubles in exporting data
> from ODK Aggregate to an Excel form. ODK Aggregate did easily convert the
> data but actually the Excel file that comes out is not useful, becasue all
> the data are into one single cell...
>
> Please find attached the Excel form exported from Aggregate.
>
> How can I better export the data in Excel Form?
> Do i need another programme?
>
> Thank you in advance for any advices, help, ecc..
>
> Best Regards
>
> Francesco De Bonis
>
···
On Tue, Oct 4, 2016 at 8:18 AM, Sam Phiri wrote:
Hi Francesco,
You can open the CSV file using excel. Open Excel, go to the Data Tab,
Under "Get External Data", select "From Text", navigate to your file
and follow the wizard. The delimiter in this case is "comma". Note: If you have some text responses that have comma's in them, this
might throw off some rows.
You can also ge CSV data into other analytical tools in a similar fashion.
Kind regards,
On Monday, 3 October 2016 19:30:42 UTC+2, Francesco De Bonis wrote:
Hello everybody,
I am Monitoring Officer in a no-profit organization.
I started using ODK Collect and Aggregate to survey some beneficiaries of
different training courses.
I can easily use all ODK tools, but I have some troubles in exporting
data from ODK Aggregate to an Excel form. ODK Aggregate did easily convert
the data but actually the Excel file that comes out is not useful, becasue
all the data are into one single cell...
Please find attached the Excel form exported from Aggregate.
How can I better export the data in Excel Form?
Do i need another programme?