How to Fix Unexpected Token in JSON When Importing Excel to SharePoint
Question details
The user encounters an 'Unexpected token A in JSON at position 0' error when attempting to import an Excel workbook into SharePoint.

- Product
- Microsoft Excel, SharePoint
- Device & OS
- not provided
- Scenario
- Creating a new SharePoint list from an uploaded Excel spreadsheet.
- Observed behavior
- The import process fails and displays an 'Unexpected token A in JSON at position 0' error message.
Ensure your Excel data is formatted as a standard Table and that you have the appropriate site permissions to create new lists in SharePoint.
Verify Row Limits and Simplify Excel Table Structure
SharePoint has a strict limit of 20,000 rows when creating a list from an Excel spreadsheet. Simplifying the data can help isolate the error.
The 'Unexpected token A in JSON' error often occurs due to server timeouts or parsing failures when the spreadsheet is too large or contains complex, unsupported formatting.
Open your Excel workbook and verify that the table contains fewer than 20,000 rows.
Create a new, simple Excel file with basic text columns like 'Title' and 'Name' to use as a test.
Select the test data and press Ctrl+T to format it as a standard Excel Table.
Upload this simplified test workbook to SharePoint. If it succeeds, the issue lies within the structure or size of the original file.

Seamlessly Prepare Data for SharePoint with WPS Office
If you are encountering persistent Excel errors, try WPS Office. It is a free, lightweight, and highly compatible alternative to Microsoft Office that allows you to easily format, clean, and save your spreadsheets before importing them to SharePoint.
- 1. Download WPS Office: Install WPS Office for free on your PC or Mac.
- 2. Format Data: Open your data in WPS Spreadsheet, select your range, and format it as a Table.
- 3. Save as .xlsx: Save your properly formatted file as an .xlsx document and upload it to SharePoint.

Frequently Asked Questions
What is the maximum number of rows I can import from Excel to SharePoint?
SharePoint currently supports a maximum of 20,000 rows when creating a new list directly from an uploaded Excel spreadsheet.
Why does SharePoint show an 'Unexpected token in JSON' error?
This error usually indicates a parsing failure during the upload. It often occurs if the Excel file is corrupted, contains unsupported characters, exceeds size limits, or if SharePoint experiences a temporary server-side issue.
Do I need a special format to import Excel into SharePoint?
Yes. Your data must be explicitly formatted as a Table (using the 'Insert Table' feature) in your spreadsheet before SharePoint can recognize and import the rows.




