Import Data (Excel): Not showing all the fields

  • Profile Image
    pestinspection
    Asked on March 03, 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 

  • Profile Image
    Adrian
    Answered on March 03, 2018 at 06: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.png

    1520077455export.png

    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?