Excel import

  • Profile Image
    yj000018
    Asked on April 05, 2013 at 10:30 AM

    1. Can I create a form by importing an Excel sheet?

     

    If not I would create the form manually and then:

     

    2. Can I import entries/submissions from the Excel sheet?

     

    I see the integration with Google Doc: I can export/visualize submissions in google docs, but can not import/update from there, right?

     

    How to do that?

    Thanks

  • Profile Image
    sidharth_kch
    Answered on April 05, 2013 at 11:35 AM

    @yj000018

    JotForm can only import HTML form.

    Yes you can export/import date from/to to google spreadsheet. If you want you can directly edit the data in google spreadsheet. 

    Please let us know if this answers your query or let us know if you meant to ask something else.

    Thanks,

    Sidharth

  • Profile Image
    yj000018
    Answered on April 05, 2013 at 08:03 PM
    thx but edited data in google will not be updated in jot form... I need to
    batch edit data or to copy data from an excel table to upadte jotform
    submissions/db... possible??
    Merci et bonne journ
    Yannick Jolliet
  • Profile Image
    EltonCris
    Answered on April 05, 2013 at 09:57 PM

    @Yannick

    Sorry but that's not possible. Google Integration means submissions submitted to the form from JotForm will be forwarded to Google Spreadsheet. It does not mean you can edit the google spreadsheet data to update the data on the JotForm side. 

    You may however access your form submissions page and manually edit each submissions submitted to your form. Here's how:

    1. Go to your My Forms page
    2. Select the form and click on Submissions button above it
    3. While on the submissions page, just select a submissions that you'd like to update on the data grid below and click Edit button above.
    4. Submit the form to save the changes.

    Thanks!
  • Profile Image
    yj000018
    Answered on October 16, 2014 at 11:01 PM
    Hi,
    I'd like to add you to my professional network on LinkedIn.
    - Yannick
    Accept: http://www.linkedin.com/blink?simpleRedirect=3gUdjANe3oOczsRdPwMdPwOejkZh4BKrSBQonhFtCVF9B1OtSlgu3lEfnBBiShBsC5EsOpQsSlRpRZBt6BSrCAZqSkConhzbmlQqnpKqiRQsSlRpORIrmkZpSVFqSdxsDgCpnhFtCV9pSlipn9Mfm4CcjcJcT9Iu7xzcmAJoStDsT9TbjRBfP9SbSkLrmZzbCVFp6lHrCBIbDtTtOYLeDdMt7hE&msgID=I8155473021_1&markAsRead=
    You received an invitation to connect. LinkedIn will use your email address to make suggestions to our members in features like People You May Know. Unsubscribe here: http://www.linkedin.com/blink?simpleRedirect=cjcJcT9Iu7xzcmAJoStDsT9TbjRAqmkCtP5KhQdemCBvuklntkAMrT91lj5vmjtzgQFpcntgmjAQjCxPk3xlrQF6blhWoSB5ozhoeiRQm3cJpBtcc4R3kkwMtzp5lB8Me65Mkm52oSJlgk51gkZbd7pScztgk5p5kk4Zp6BLr2pQsSlRpRZBt6BSrCAZqSkCkjoPp4l7q5p6sCR6kk4ZrClHrRhAqmQCrDlIfngCcjcJcT9Iu7xzcmAJoStDsT9TbjRBfP9SbSkLrmZzbCVFp6lHrCBIbDtTtOYLeDdMt7hE&msgID=I8155473021_1&markAsRead= Learn why we included this at the following link: http://www.linkedin.com/blink?simpleRedirect=e3wTd3RAimlIoSBQsC4Ct7dBtmtvpnhFtCVFfmJB9CNOlmlzqnpOpldOpmRLt7dRoPRx9z4PbjdOr7xUoP5FbmdDpTdOtOQZpjYOtyZBbSRLoOVKqmhBqSVFr2VTtTsLbPFMt7hE&msgID=I8155473021_1&markAsRead=
    © 2014, LinkedIn Corporation. 2029 Stierlin Ct. Mountain View, CA 94043, USA
    ...