Commcare Data With Google Spreadsheet

Hi,

Is there a way to connect Commcare Data with Google Spreadsheet ? I did it with Excel but curious to know if I could do it with Google Spreadsheet.

Thanks in advance for your support.

Regards
Afroz Khan
Mob : +91-9415037876
[logo]

1 Like

Hi Afroz

Google sheets does have an IMPORTHTML
https://support.google.com/docs/answer/3093339?hl=en function which would
work except for the fact that it doesn’t support authentication. There may
be other tools that you could use as intermediaries like import.io but its
probably simpler to download the export from CommCare and import it into
Google Sheets.

Best regards
Simon

··· On 27 October 2015 at 13:05, Khan, Afroz wrote:

Hi,

Is there a way to connect Commcare Data with Google Spreadsheet ? I did it
with Excel but curious to know if I could do it with Google Spreadsheet.

Thanks in advance for your support.

Regards

Afroz Khan

Mob : +91-9415037876

[image: logo]

–
You received this message because you are subscribed to the Google Groups
“commcare-users” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

–
Simon Kelly
Senior Engineer | Dimagi South Africa

I think that the best way , is :-export from Commcare-import to google
ThanksJustin Bayoro

··· Le Mardi 27 octobre 2015 11h20, Simon Kelly a écrit :

Hi Afroz
Google sheets does have an IMPORTHTML function which would work except for the fact that it doesn’t support authentication. There may be other tools that you could use as intermediaries like import.io but its probably simpler to download the export from CommCare and import it into Google Sheets.
Best regardsSimon
On 27 October 2015 at 13:05, Khan, Afroz Afroz.Khan@crs.org wrote:

Hi, Is there a way to connect Commcare Data with Google Spreadsheet ? I did it with Excel but curious to know if I could do it with Google Spreadsheet. Thanks in advance for your support. RegardsAfroz KhanMob : +91-9415037876 –
You received this message because you are subscribed to the Google Groups “commcare-users” group.
To unsubscribe from this group and stop receiving emails from it, send an email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

–
Simon Kelly
Senior Engineer | Dimagi South Africa–
You received this message because you are subscribed to the Google Groups “commcare-users” group.
To unsubscribe from this group and stop receiving emails from it, send an email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Thanks for all support.

I am looking for live data connection with spreadsheet as we do in excel dashboard.

Regards
Afroz Khan
Mob : +91-9415037876
[logo]

··· From: commcare-users@googlegroups.com [mailto:commcare-users@googlegroups.com] Sent: Tuesday, October 27, 2015 7:05 PM To: commcare-users@googlegroups.com Subject: Re: Commcare Data With Google Spreadsheet

I think that the best way , is :
-export from Commcare
-import to google

Thanks
Justin Bayoro

Le Mardi 27 octobre 2015 11h20, Simon Kelly <skelly@dimagi.commailto:skelly@dimagi.com> a Ă©crit :

Hi Afroz

Google sheets does have an IMPORTHTMLhttps://support.google.com/docs/answer/3093339?hl=en function which would work except for the fact that it doesn’t support authentication. There may be other tools that you could use as intermediaries like import.iohttp://import.io/ but its probably simpler to download the export from CommCare and import it into Google Sheets.

Best regards
Simon

On 27 October 2015 at 13:05, Khan, Afroz <Afroz.Khan@crs.orgmailto:Afroz.Khan@crs.org> wrote:
Hi,

Is there a way to connect Commcare Data with Google Spreadsheet ? I did it with Excel but curious to know if I could do it with Google Spreadsheet.

Thanks in advance for your support.

Regards
Afroz Khan
Mob : +91-9415037876
[logo]

–
You received this message because you are subscribed to the Google Groups “commcare-users” group.
To unsubscribe from this group and stop receiving emails from it, send an email to commcare-users+unsubscribe@googlegroups.commailto:commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

–
Simon Kelly
Senior Engineer | Dimagi South Africa

You received this message because you are subscribed to the Google Groups “commcare-users” group.
To unsubscribe from this group and stop receiving emails from it, send an email to commcare-users+unsubscribe@googlegroups.commailto:commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

–
You received this message because you are subscribed to the Google Groups “commcare-users” group.
To unsubscribe from this group and stop receiving emails from it, send an email to commcare-users+unsubscribe@googlegroups.commailto:commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.