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

    Missing columns in downloaded Excel file

    Asked by VailClub50 on January 26, 2015 at 07:42 PM

    Every month, I download the Submissions for one of our forms to Excel, then create a report.  Normally, the downloaded Excel file has columns A through BA.  Today, the downloaded Excel file only has columns A through AA, meaning about half the data is missing.

    I looked through the Submissions settings (gear icon) for the form, and all the desired fields are checked.  I can see all the desired fields in the Submissions data that's displayed on my screen.

    Any idea why some fields aren't in the Excel file?

    Page URL:
    https://secure.jotformpro.com/form/41604082701949

    excel excel file Submissions settings icon
  • Profile Image
    JotForm Support

    Answered by Charlie on January 26, 2015 at 11:17 PM

    Hi,

    For testing purposes, I've checked your form and downloaded an excel format of the submissions. The last column is "Payment with Paypal or Credit Card: Payer Address" which is actually the last part of the form field "Payment with Paypal or Credit Card", so I'm assuming the the first field up to the last field are captured?

    It seems that everything on the form field is fetched and in the excel spreadsheet. Can you please check if the information are all in there?

    The columns might have been adjusted when you edited your form. We'll wait for your response.

    Thank you.