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

    Web import in Excel: Error Messages

    Asked by Kailash108 on January 18, 2015 at 08:05 AM

    I tried to import a Grid Report and a Table Report into Excel, but both generate an error message.

    Somehow it works anyway, but I'm not sure what consequences the errors have.

    I tried with 3 different forms (which have different content), but the errors comes with all.

     

     

    excel message JotForm grid report uploads
  • Profile Image
    JotForm Support

    Answered by Welvin on January 18, 2015 at 09:01 AM

    Hi,

    Why you would you do the import process if you can generate an Excel file our from your form submissions? Did you do it for a purpose? If not, generate and excel report instead:

    http://www.jotform.com/help/44-How-to-Export-Form-Data-to-Excel

    or, you can also have one as CSV: http://www.jotform.com/help/103-How-to-create-a-CSV-Report.

    Thanks

  • Profile Image

    Answered by Kailash108 on January 18, 2015 at 09:17 AM

    I did it because it is very easy to update it. Just one click and new submissions are loaded.

    If I download the excel file, I have to copy and paste it to the working file (where I process the form registrations).

    So this way is extreme smooth.

  • Profile Image
    JotForm Support

    Answered by Welvin on January 18, 2015 at 09:44 AM

    I'm not sure of the real cause, but allow me to forward this thread to our developers. I have just tried it here and saw the same error.

    For now, you may consider the following options:

    a. Use our Reports to Cloud App: http://apps.jotform.com/app/reports_to_cloud. This is forwarding your excel report to your Dropbox folder.

    b. Integrating your form to Google Spreadsheet: http://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet and process your form registrations there.

     

    Thanks