I want the data which is submitted to us from the form to be in CSV format.

  • ypwitch
    Asked 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,

    Kevin

  • Kevin Support Team Lead
    Replied on June 15, 2017 at 2: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.