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 can I separate data fields in an Excel download of data?

    Asked by JodiBaer on January 23, 2017 at 11:23 AM

    I need help separating the Payer Info (First/Last Name and Email Address) and Payer Address (Address/City/State/Zip) in a form (Donation Form) when downloading to Excel. 

     

     

    Page URL:
    https://www.jotform.com/submissions/41494339279971

  • Profile Image
    JotForm Support

    Answered by Jim_R on January 23, 2017 at 01:15 PM

    I'm afraid this is only doable with the Email Notifications you receive. There's a way for you to strip and separate the payment labels for the email but not with the actual Submission Data that gets downloaded to Excel (or any other format).

    Related guide: How-to-Strip-Payment-Labels-and-Separate-Payment-Info-on-Email-Alerts 

    As a general rule of thumb, Widgets, Payment Fields, along with some Quick Fields (e.g. Full Name or Address) will be treated as a single field on your Submissions Page, even if these contain multiple fields. And that's exactly how it will be exported to Excel as well.