How can I separate data fields in an Excel download of data?

  • Profile Image
    JodiBaer
    Asked 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. 

     

     

  • Profile Image
    Jim_R
    Answered 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.