¿Puedo llevar una hoja de excel a jotform? o cómo una base de datos?

  • hlahud
    Fecha de consulta 27 de marzo de 2024, 20:23

    ¿Puedo llevar una hoja de excel a jotform? o cómo una base de datos?

  • Mary Jotform Support
    Fecha de respuesta 27 de marzo de 2024, 22:58

    Hi hlahud,

    Thanks for reaching out to Jotform Support. Unfortunately, our Spanish Support agents are busy helping other Jotform users at the moment. I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in Spanish, let us know and we can have them do that. But, keep in mind that you'd have to wait until they're available again.

    Now, let me help you with your question. Are you trying to import data into the form or in the tables? If you are trying to prefill form fields from an Excel file, this can be done by using the Spreadsheet to form widget. Let me show you how to use it:

    • Create a spreadsheet that includes your data in the structure you see below. It's important that the column names in the spreadsheet and field names on the form are the same.

    1643012753 61ee6291bccef  Screenshot 40

    • In Form Builder, click on the Add Form Element menu on the left side of the page.
    • Under the Widgets tab, search for the Spreadsheet to Form widget and add it to your form.

    ¿Puedo llevar una hoja de excel a jotform? o cómo una base de datos? Image 1 Screenshot 51

    • In the Widget Settings window that opens up, upload your data file and customize the other options. 
    • Then, click on Update Widget.

    ¿Puedo llevar una hoja de excel a jotform? o cómo una base de datos? Image 2 Screenshot 62

    • In the final stage, add the fields to view values and name them the same as on the spreadsheet.

    ¿Puedo llevar una hoja de excel a jotform? o cómo una base de datos? Image 3 Screenshot 73

    Give it a try and let us know if you need any help.