- ypwitchAsked on June 15, 2017 at 12:42 PM
If we're asking five questions and we receive those answers I want to plot them in Google maps via an excel or Google Sheets spreadsheet, but the data when cut and pasted is in the wrong format. I would prefer to integrate the output of the jot forms to a comma delimited format, and send that to my cloud drive. The goal is to take advantage of a neat little Google Maps trick where you can use a spreadsheet to plot points on the map and have an accompanying tool-tip with a blurb. Right now I have to cut and paste each field into the spreadsheet (Google Sheets) as it doesn't automatically format them across the rows when I use basic cut-paste to buffer, and while the formatted paste offers a delimiter selection, none of them are a basic carriage return, which is the real delimiter we need, and should be default.
Thanks in advance,
- JotForm SupportKevin_GAnswered on June 15, 2017 at 02:33 PM
We do have an integration with Google Spreadsheet, you could add the integration to your form and receive submissions automatically on your spreadsheet without manual process involved.
Here is a guide that will help you integrating with Google Spreadsheets: https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet
You could also generate a CSV report that is updated with the submissions on your form, this guide will provide you with more details as well as the steps to implemente it: https://www.jotform.com/help/103-How-to-Create-a-CSV-Report
If you have any question, let us know.