Import Data (Excel): Not showing all the fields

  • pestinspection
    Asked on March 3, 2018 at 12:10 AM

    Hi


    I have uploaded a data from excel sheet to my form (Training Form), but after uploading its not showing all the field. Please help me to upload my data correctly.


    Regards

    Anand 

  • Adrian
    Replied on March 3, 2018 at 6:47 AM

    Is this the form that you are talking about? http://www.jotform.me/form/80261699502459

    You can download the sample import sheet for this form in the link below:
    https://drive.google.com/file/d/1QVgXHztlpN20-Op8TimMibGEHFJdMDcv/view?usp=sharing

    This sheet is generated by the Import Data application.

    I have cloned your form and tried to import data from the excel sheet and everything seems to be working properly. All the data from the sheet were added to the form's submissions page.

    1520077439import Screenshot 10

    1520077455export Screenshot 21

    When you are using the .xls template format, The top line of your .xls (.xlsx) file should be identical with the sample sheet generated in the Import Data application and the remaining lines should match the format.

    Can you please tell us which field is not showing on your submissions page after importing the data?