How to prefill form from an excel file aside from the widget?

Have existing data in an Excel sheet, it has phone numbers and other data. If the form filler's phone number exists, it should populate all the fields with his data and allow him to edit them if he needs.
if not present, then allow him to fill in the data.

Trying to use a spreadsheet to form, it does not allow users whose phone number ( access code) is not present in the table

Any other way round to achieve this ?

https://www.jotform.com/build/251462631616454

Hi Vinod,

Thanks for reaching out to Jotform Support. Aside from the Spreadsheet to Form widget, you can import your Excel file into Jotform Table and use it to prefill your form using the Table Prefill feature. Here's how you can find this option in the Form Builder:

1. Go to the Publish tab in the Form Builder.
2. Click Prefill on the left.
3. Choose the Tables Prefill option.

Here's a guide with the complete steps that you can check.

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

But we are planning to pass a single link in the whatsapp , I see that it creates a individual link for each one with prefilled data ? Have about 50+ users data

Hi Vinod,

Unfortunately, that's the only way to prefill the form from an excel file. You can check this guide on Jotform's Prefill Options.

Let us know if you have any other questions.