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 full name field in Excel to separate columns?

    Asked by tonycrowther on November 30, 2016 at 01:16 PM
    Also, when I view the form submissions list, the first and last names have been joined into one single field, whereas I want to export them as separate, thus ending with an excel file which has three fields (first name, last name, email address) but to exclude those who ticked the 'anonanimity' tickbox.
  • Profile Image
    JotForm Support

    Answered by olivia on November 30, 2016 at 02:41 PM


    I have tried to export form submissions with a full name form field and I didn't replicated your issue when I export to Excel. 

    In other words, even first name and last name are in a single column in Submissions page in JotForm, when you export these submissions to Excel, first name and last name come in separate columns.

    Please have a look at the following video:

    As you can see in above video, full name form field is exported to Excel in separate columns by default. You can edit these exported data in Excel and remove unwanted fields in the Excel easily.

    Please have a look at the following guide, too: How-to-Export-Form-Data-to-Excel

    If you need any further details, please feel free to let us know.

    Thank you.