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

    How to export data into a prepared excel document with embedded formula

    Asked by GRIPOutreach on December 16, 2011 at 02:38 PM

    I am collecting info from mentors spending time with their mentees. Is there a way to export data into a prepared excel document (or other form) with formulas already prepared? Thus not having to add the formulas each time?

  • Profile Image
    JotForm Support

    Answered by liyam on December 17, 2011 at 04:47 AM

    Hello GRIPOutreach. I have changed the title of your question from "How to add up columns" to "How to export data into a prepared excel document with embedded formula"

    The only possible thing I could think of is have your prepared excel document that will collect data from the area which you can simply paste the copied data from the downloaded excel file.

    Example: Your Sheet 1 should have all the output and the formula for your data that will be collected from Sheet 2.  Now, download your excel file from your submissions page, open the downloaded file, copy the contents and paste it to Sheet 2 of your prepared excel file.

    But, if you're looking for a way how to download the excel file with the embedded formulas, unfortunately, this is not yet possible within JotForm's features.

    If you have other questions or concerns, please let us know.