Survey Data in Excel

To learn more about how survey data looks in Excel from survey using Google Forms, here is an excel file from a beverage study. Survey data in spreadsheet from survey using Microsoft Forms is slightly different on multiple answer questions (discussed on previous post).

Comments Off on Survey Data in Excel

Survey Menggunakan Microsoft Forms

Untuk survey menggunakan Microsoft Forms format data di spreadsheet untuk pertanyaan multiple answer sedikit berbeda dengan format data Google Forms. Lebih lanjut di sini.

Comments Off on Survey Menggunakan Microsoft Forms

Survey Using Microsoft Forms

For survey using Microsoft Forms the data format in the spreadsheet for multiple answer question is slightly different with that of Google Forms. Find out more here.

Comments Off on Survey Using Microsoft Forms

Web-scraping Using Google Sheet

Here is an example of web-scraping using Google sheet for a property listing website in Indonesia. View the Google sheet here.

Comments Off on Web-scraping Using Google Sheet

Cara Mengirim Lokasi di Google Forms

Masukkan nama Anda di Google Forms di sini, lalu klik link yang muncul setelah submit. Anda bisa melihat lokasi Anda di spreadsheet di sini.

Lokasi berisi informasi Latitude, Longitude dan Alamat: Nama Jalan dan Nomor, Kota, Provinsi, Kode Pos, Negara

Tutorial bisa Anda download di sini.

PENTING : Alasan yang sering ditemukan ketika tidak berjalan :

  1. Membuka akun google lebih dari satu di device yang sama (umumnya terjadi ketika testing : satu untuk form, satu untuk mengirim lokasi) – keluar seluruh akun lalu masuk dengan satu akun yang akan dipakai untuk mengirim lokasi.
  2. VPN dimatikan jika hidup.
  3. Jika menggunakan satu device untuk mengirim beberapa lokasi, screen harus ditutup setelah submit lokasi dan tidak dalam posisi terbuka agar data lokasi dapat terkirim dengan benar.
Comments Off on Cara Mengirim Lokasi di Google Forms

How to Send Location in Google Forms

For demo, just type your name in Google Forms here and click the link that shows after submit. You can see your location in spreadsheet here.

Location : Latitude, Longitude and Address (Street Name and Number, City, State, ZIP Code, Country)

The tutorial can be downloaded here.

IMPORTANT : Common reasons for not working :

  1. To open multiple google accounts on the same device (usually during testing – open one for form, another one for sending out location) – log off all accounts first then use one account to send location.
  2. VPN is on – turn off
  3. If using same device to send successions of locations, screen needs to be closed after each submit and not stay open for the new data to come through correctly
Comments Off on How to Send Location in Google Forms