How to Fix Unexpected End of JSON Input When Creating SharePoint Lists from Excel
Question details
The user is unable to create a Microsoft Teams or SharePoint list from an Excel table due to a persistent JSON parsing error.

- Product
- SharePoint, Microsoft Teams
- Device & OS
- not provided
- Scenario
- Attempting to create a SharePoint list or Microsoft Teams list by importing data directly from an existing Excel table.
- Observed behavior
- The import process fails across all web browsers, files, and services, consistently returning an 'Unexpected end of JSON input' error message.
Ensure your Excel data is properly formatted as a Table without merged cells or unsupported special characters, and verify that you have a stable internet connection before troubleshooting network restrictions.
Test an Alternative Network and Review Firewall Rules
Isolate the issue to determine if local network security policies, firewalls, or proxy settings are interrupting the data import request.
In many corporate environments, strict network filtering, web proxies, or traffic inspection systems can unintentionally truncate web requests. When the data payload between SharePoint and your browser is cut short, the system cannot parse the incomplete data, resulting in an 'Unexpected end of JSON input' error.
Switch your device to a different network, such as a mobile hotspot or a guest Wi-Fi network, that is not restricted by your organization's primary firewall.
Log in to Microsoft Teams or SharePoint and attempt to create the list from your Excel table again. Alternatively, ask another user with appropriate permissions to try the import on their network.
If the import succeeds on the external network, the issue lies with your local network settings. Reach out to your IT team and report the findings.
Ask your IT administrators to review firewall, proxy, traffic inspection, and network filtering rules to ensure that requests to SharePoint and Microsoft Teams are fully whitelisted and not being truncated.

Use a Website Tab as a Workaround in Teams
If you cannot bypass network restrictions to import directly into Teams, you can create the list in SharePoint first and add it as a Website tab.
Try WPS Office for Seamless Spreadsheet Management
While network configurations and SharePoint server issues can disrupt your workflow, managing your local and cloud spreadsheet data doesn't have to be complicated. WPS Office is a free, lightweight, and powerful alternative that offers full compatibility with Microsoft Excel files without the heavy network overhead.
- 1. Download WPS Office: Visit the official WPS website and click the 'Download WPS Office Free' button to get the installer.
- 2. Install the Software: Run the downloaded installer and follow the simple on-screen instructions to complete the setup.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx files directly to continue working with all your formatting intact.

Frequently Asked Questions
Why do I get an 'Unexpected end of JSON input' error?
This error occurs when the data payload sent between your browser and the Microsoft servers is incomplete or truncated. The system expects a complete JSON string to build the list, but if network firewalls, proxies, or traffic inspection tools block or cut off part of the data stream, the server cannot read it, triggering the error.
Does extending my Excel table range fix the JSON error?
No, extending the table range (e.g., from A1 to I20000) will not resolve the issue. The error is typically caused by network transport interruptions rather than the size or boundaries of your Excel data range. Focusing on network and firewall settings is the most effective troubleshooting step.
Can I share my workbook to find the cause of the error?
Yes. Uploading a sample workbook containing test data to a safe online drive and sharing the link with your IT administrator or Microsoft Support can help them diagnose the issue. It allows them to verify whether the problem is specific to your file's contents or strictly related to network traffic policies.




