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

    Can I export data into preformatted excel or word templates?

    Asked by sam  on February 03, 2015 at 05:46 PM

    We will be using forms as a way for our employees to fill out saftey manual sheets required on construction job sites. Once they submit the data, we need to be able to download it into a printable template for our records. Is this possible?

  • Profile Image
    JotForm Support

    Answered by jonathan on February 03, 2015 at 07:28 PM

    Hi Sam,

    I also recommend creating your account (for fREE!) if you haven't done so yet. You can use this link http://www.jotform.com/signup to signup using your email account.

    As to your inquiry...

    There are to ways to have an Excel formatted data from the form submissions.

    #1. -How-to-create-an-Excel-Report

    #2. -How-to-Download-Form-Submissions-as-Excel

    I understand that you already have a pre-formatted Excel file data.., you would eventually would wanted the resulting submission data to fit in to your existing Excel data format.

    You can design the form so that all the fields matches also the column of your existing Excel data. This way the resulting submission data of the form will have similar column number setup as to your existing Excel file.

    At most, the 'manual' process that you would have to do is to manually copy and paste the data to your Excel file. OR you can just create a macro script to automate the field/column mapping between the form submission Excel and your existing Excel file.

    Hope this help. Let us know if you need further assistance.