Data Import & Export

How to Fix Unexpected Token in JSON When Importing Excel to SharePoint

Muhammad TalhaMuhammad Talha Nov 2, 2026 869 views

Question details

The user encounters an 'Unexpected token A in JSON at position 0' error when attempting to import an Excel workbook into SharePoint.

How to Fix Unexpected Token in JSON When Importing Excel to 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.
Before you start

Ensure your Excel data is formatted as a standard Table and that you have the appropriate site permissions to create new lists in SharePoint.

Solution 1Recommended

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.

1
Check Row Count

Open your Excel workbook and verify that the table contains fewer than 20,000 rows.

2
Create a Test Workbook

Create a new, simple Excel file with basic text columns like 'Title' and 'Name' to use as a test.

3
Format as Table

Select the test data and press Ctrl+T to format it as a standard Excel Table.

4
Test the Import

Upload this simplified test workbook to SharePoint. If it succeeds, the issue lies within the structure or size of the original file.

Verify Row Limits and Simplify Excel Table Structure
Row Limit Restriction: If your original data exceeds 20,000 rows, you will need to split the Excel file into multiple smaller workbooks before importing.
Free Microsoft Office alternative

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. 1. Download WPS Office: Install WPS Office for free on your PC or Mac.
  2. 2. Format Data: Open your data in WPS Spreadsheet, select your range, and format it as a Table.
  3. 3. Save as .xlsx: Save your properly formatted file as an .xlsx document and upload it to SharePoint.
Fully compatible with Microsoft Excel (.xlsx) formatsEasily manage and split large datasets exceeding 20,000 rowsLightweight, fast, and completely free to downloadFamiliar user interface with zero learning curve
microsoft office alternative - wps office

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.