Spreadsheet to Form Widget: Stopped Working on All Forms Suddenly

i DID NOT MODIFY THE FILE AND IT IS AN EXCEL FILE WITH CORRECT EXTENSION.

i TRIED TO REMOVE IT BUT i CANT GET TO IT JUST A FROWNY FACE. i TRIED UPLOADING ANOTHER WIDGET AND SAME ISSUE. iT IS NOT WITH JUST ONE FORM BUT ALL OF MY FORMSS AND STARTED NOT WORKING THIS AFTERNOON. iT WORKED THIS MORNING.

hERE IS A FORM uRL YOU CAN LOOK AT

https://pci.jotform.com/form/260165517749161

Hi Denise,

Thanks for reaching out to Jotform Support. I'm an AI assistant here to assist you.

Regarding your issue with the Spreadsheet to Form widget not working on all your forms and the inability to remove or upload another widget, here’s some important information and troubleshooting steps:

The Spreadsheet to Form widget allows you to upload an Excel spreadsheet (XLS or XLSX) to automatically fill form fields based on a unique code. It is important that the file format is correct and the column names in your spreadsheet exactly match the field labels on your forms.

Since you mentioned the issue started suddenly this afternoon and affects all your forms, it could be related to the widget's configuration or a temporary issue with the widget itself.

Here’s how to troubleshoot and set up the Spreadsheet to Form widget properly:

1. Check the file format: Ensure your Excel file is in XLS or XLSX format. Other formats like CSV or Google Sheets are not supported.
2. Verify the unique code column: Make sure the unique code you use for searching is correctly set in the widget settings and matches exactly (case-sensitive) with the spreadsheet data.
3. Remove and re-add the widget: If you cannot remove the widget normally, try clearing your browser cache or use a different browser to access the form builder and remove the widget.
4. Re-upload the spreadsheet: After removing the widget, add it again and upload the spreadsheet file freshly to ensure no corruption or issues with the file.
5. Check for widget updates or issues: Sometimes widgets may have temporary issues or updates. You can try to recreate the widget or check Jotform’s status page for any ongoing issues.

If the problem persists across all your forms, it might be related to a broader issue with the widget or your account. Unfortunately, I cannot access your form directly to make changes, but these steps should help you resolve the issue.

Give it a try and let us know how it goes.

Hi Denise,

Can you explain a bit more about the issue? Is the spreadsheet to form widget no longer prefilling the fields with data from spreadsheet, even though you're entering the correct access code? If you're getting some kind of error message, you can share with us a screenshot of it so we can check. Let me show you how to post a screenshot to our Help Center:

1. On the Help Center page, scroll down to the Your Answer section and click on the Image icon.

2. Drag and drop your image into the Upload box, or click on it and select your file.

3. Then, click on the Add button in the bottom-right corner of the window.

4. To resize it, click on your screenshot and then click on one of the boxes in the corners, and drag it inward.

5. Once you're finished, click on the Post Answer button at the bottom right of the Your Answer section.

Additionally, could you share with us the excel file you're using in the widget, so we can run some tests on our end.

That's it. Once we hear back from you, we'll be able to help you with this.

AS you can see no file is working. On another computer it works fine, same browser (chrome). There was also another field not working as well. No changes were made to the form prior to working this morning and then not working this afternoon. For some clients it works fine on others it doesn't. I just know on my laptop it worked, on my desktop it didn't and on another computer at another site it worked. So I don't know why it works on some computerss and others it does not.

It globally stopped working across all my forms. Current, future to be activated, and past ones form last year and prior years. so It seems like something happened that affected the widget on all my forms and is impacting some but not all clients.

Hi Denise,

The form you shared initially seems different from the one you shared in the screenshot below:

But if you can see the Spreadsheet section on the right side, it shows as expected. I've cleared the caches for your forms. I suggest clearing the cache and cookies of the browser you use most of the time before checking the Form Builder again.

Let us know if you have any other questions.

You are seeing something totally different than I am. I see this

This is the problem It is not consistent across computers.

I have cleared the computer caches not just the form ones, cookies etc. and it makes no differnce.

Hi Denise,

We accessed your account to see if we can have the same view, but it's working as intented as shown below:


Can you take a screenshot of the Console Log while you are on the page? We have this guide on How to Get a Console Report from Most Common Browsers.

Once you get back to us, we can take the next step toward solving this.

Hi Denise,

I've checked your form and can see that the Spreadsheet to Form widget is working as expected.

The console log error indicates that the browser blocked a request due to a security restriction known as the Same Origin Policy. Because the source frame is considered an error page, the browser blocks any attempt to load content from a different domain. This results in the Unsafe attempt to load URL message in the console.

Since this behavior is only occurring on a specific device, the issue is most likely related to a device level factor rather than the form or widget itself. Common causes include browser extensions such as ad blockers or privacy tools, network or firewall restrictions, cached browser data, or outdated browser versions. To resolve this issue, try the following steps on the affected device:

• Open the form in an Incognito or Private browsing window
• Disable browser extensions, particularly ad blockers or privacy extensions
• Clear the browser cache and cookies
• Try using a different browser (such as Firefox, or Edge)
• Ensure the browser is updated to the latest version
• If using a corporate or restricted network, try switching to a different network

If the Spreadsheet to Form widget loads correctly after these steps, it would confirm that the issue is caused by a device specific browser or network restriction rather than a problem with the widget itself.

Give it a try and reach out again if you have any other questions.

Ok lets try this again

The form and spreadsheet to form widget along with another field that does not show worked on every browser, every machine (desktop, laptop, phone) yesterday morning. In the afternoon some not all machines regardless of browser regardless of desktop, laptop, phone the form did not work and a field wouldn't show and the spreadsheet to form widget wont load on every one of my forms including ones from 2 years ago at least. So it is not device specific. It works on my work laptop hooked up to same network as I work from home, it worked on my school classroom machine. It does not work on my desktop upstairs nor my daughters laptop downstairs. It works for some of my clients and doesn't work for some across all browsers, and devices.

Thus I believe it is on your end somehow. How does is stop working when I wasn't even here to change anything and it effects every one of my forms but not just for myself but others on other machines, networks etc. And if it was my form and or file for the spreadhseet it wouldn't work anywhere and it works for others.

So forget the clear caches, forget the reboots, this is happening across state locations, networks, etc. it is not device specific with ad blockers etc.

This has worked for the last three years and it is imperative to get it fixed as I cannot run my business if the forms work intermittingly.

Also to add to the confusion my terms & conditions widget isn't working now either but all other widgets are. So spreadsheet to form and terms & conditions isn't working.

Hi drmarketing89,

Considering that the issue is occurring on multiple devices, networks, states, and browsers, I'll escalate this issue to our Developers. Although we don't know exactly when it'll be fixed, we’ll circle back to this thread when we have an update. 

Thank you. I checked some of my old inactive forms and it is on those as well.

Hi drmarketing89,

I included in the ticket that the issue is related to all forms. We’ll let you know as soon as there’s an update for our developers.

Another update. Everything worked fine yesterday at noon EST. Nothing changed so not sure why it doesn't work now.

MORE IMPORTANTLY, my clients are not happy they have to enter everything by hand. I have 2 major events opening up next TUESDAY. this needs to be fixed by then or my business will suffer both for me and the clients that hire me.

Hi drmarketing89,

The issue has been escalated and already assigned to a developer's team. We already informed them about the latest updates you shared. We'll be back to you as soon as we receive an update from the team.

We appreciate your patience while we work on a solution.

I need a status please as it is critical it gets fixed b MOnday AM . I need this for my business otherwise I may need to look at other options.

Quick update Everything works fine on mY work laptop and school computers.

Work laptop is Windows 11 Enterprise And it uses microsoft edge. School is also Windows 11 enterprise

Hi drmarketing89,

Unfortunately, we don't have a timeline yet, but our Developers are on the case and doing their best to get this sorted quickly. We’ll update you as soon as we can.

Seems to be related to my network. It works once if I switch between networks. Then it doesnt work again. Rebooted router twice. works with wifi off on all phones. Does the same with wifi on for all phones.

Hi drmarketing89,

Thank you for that information. I've added that to the escalation report, so our Developers can look into that as well. We’ll let you know as soon as there’s an update.