What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

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

    Asked by ypwitch 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

  • Profile Image
    JotForm Support

    Answered by Kevin_G 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.