Microsoft 365 Error Codes

How to Fix Unexpected End of JSON Input When Creating SharePoint Lists from Excel

Anum MushtaqAnum Mushtaq Oct 29, 2026 869 views

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.

How to Fix the 'Unexpected End of JSON Input' Error When Creating SharePoint Lists
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.
Before you start

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.

Solution 1Recommended

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.

1
Connect to an external network

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.

2
Test the import process

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.

3
Contact your IT department

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.

4
Review security rules

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.

Test an Alternative Network and Review Firewall Rules
Network Interruptions: Security software performing deep packet inspection is a common culprit for truncating JSON responses during large data imports.
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS website and click the 'Download WPS Office Free' button to get the installer.
  2. 2. Install the Software: Run the downloaded installer and follow the simple on-screen instructions to complete the setup.
  3. 3. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx files directly to continue working with all your formatting intact.
100% format compatibility with Microsoft Excel (.xlsx, .xls, .csv) to ensure no data is lost.Lightweight installation with a familiar, easy-to-use interface that requires no learning curve.Built-in cloud sync for easy collaboration and data sharing across devices without complex setups.Completely free to use for daily spreadsheet creation, editing, and data analysis.
microsoft office alternative - wps office

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.