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

    Is it possible to email out a CSV of your forms results?

    Asked by worknetcs on July 26, 2012 at 04:59 PM

    Hi

    We use your service to great effect and are very happy with it. I was wondering if it was possible to configure a form to email out a CSV file containing the results of form entry rather than having to log into the site and running an export that seems to gather all submissions?

     

    Many thank

     

    Simon Whittington

    simonwhittington@wknet.co.uk

    email CSV Submissions form to email
  • Profile Image
    JotForm Support

    Answered by jonathan on July 26, 2012 at 06:44 PM

    Hi Simon,

    You can setup the email Notification to plain text mode, and add commas in between the labels and fields like this..

    I cloned your form and tested the email result with csv data here.

    Please inform us if you have further inquiry.

    Thanks.

  • Profile Image

    Answered by barq on September 17, 2012 at 07:30 AM

    Hi,

     

    I'm wondering if there is a way to do this, without manually having to create e-mail youself? (Which would be very useful if you have a 100+ field form with lots of dynamic fields.

    Simply something like, mail notification as csv/excel?

  • Profile Image

    Answered by pinoytech on September 17, 2012 at 09:19 AM

    Hi,

    I have now submitted a ticket to our development team regarding on this request but unfortunately, we can't give you ETA to when this be implemented.

    Thank you!

  • Profile Image
    JotForm Founder

    Answered by aytekin on September 17, 2012 at 09:25 AM

    Another possible solution is to just create a CSV report and bookmark it or link to it from your email. Here is a tutorial on how to do that:

    http://www.jotform.com/help/103-Create-a-CSV-Report

  • Profile Image

    Answered by worknetcs on May 21, 2013 at 06:59 PM

    Hi

     

    I wonder if there had been any progress towards being able to being able to email out a CSV file containing form answers?

     

    We use your form site (which we think is excellent) for obtaining details on how to set up new users on our system. Currently I manually transcribe the details into a CSV file which is then picked up by a Powershell script which provisions AD accounts and mailbox settings etc.

     

    Obviously if I could get the details straight into a CSV file it would save time. Our perfect scenario might also to be able to upload a CSV into a Dropbox account which our Powershell scripts could automatically poll every hour and set up the accounts without human involvement.

     

    Many thanks

     

    Simon Whittington

  • Profile Image
    JotForm Support

    Answered by Welvin on May 21, 2013 at 07:42 PM

    Hi Simon,

    Unfortunately, the ticket has been cancelled. You may consider exporting the CSV Report instead: Generate CSV Report.

    Or, how about creating a Grid Listing Report or HTML Listing Report?

    Create Grid Listing Report

    Create HTML Table Listing Report

    Is your system cannot automate this one?

     

    Thank you!

  • Profile Image

    Answered by worknetcs on May 22, 2013 at 07:20 AM

    Unfortunately creating reports means that we have to log in to go through the process whenever someone completes a form. This would actually increase the work rather than minimise it.

     

    Thanks anyway.

     

    Regards,

    Simon

  • Profile Image
    JotForm Support

    Answered by Welvin on May 22, 2013 at 09:47 AM

    Hi Simon,

    No, you do not need to login again to generate a new report to bring all the recent or new submissions. Just save the link or bookmark the link. Whenever there's new submissions, you can pull them out using the existing report link.

    Thank you!