JSON.parse: Error - create sharepoint list from excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2108429%22%20slang%3D%22en-US%22%3EJSON.parse%3A%20Error%20-%20create%20sharepoint%20list%20from%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2108429%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3EI%20apologize%20if%20this%20topic%20has%20already%20been%20covered.%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20create%20a%20sharepoint%20list%20from%20an%20excel%20file.%20I%20am%20getting%20the%20following%20error%3C%2FP%3E%3CDIV%20class%3D%22ms-MessageBar-icon%20iconContainer-194%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22ms-MessageBar-text%20text-196%22%3E%3CSPAN%20class%3D%22ms-MessageBar-innerText%20innerText-197%22%3E%3CSPAN%3EJSON.parse%3A%20unexpected%20end%20of%20data%20at%20line%201%20column%201%20of%20the%20JSON%20data%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22ms-MessageBar-text%20text-196%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22ms-MessageBar-text%20text-196%22%3E%3CSPAN%20class%3D%22ms-MessageBar-innerText%20innerText-197%22%3EThere%20are%20approximately%201800%20records%20in%20my%20list%20and%20the%20failure%20seems%20to%20happen%20at%20around%201400%20records.%20Ive%20tried%20sorting%20the%20table%20differently%20with%20the%20same%20result.%20all%20fields%20are%20the%20same%20type%3A%20short%20text.%20%3C%2FSPAN%3E%3C%2FDIV%3E%3CP%3Eplease%20help%20-%20i%20am%20ready%20to%20go%20supernova%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2108429%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20List%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

Hello

I apologize if this topic has already been covered.

I am trying to create a sharepoint list from an excel file. I am getting the following error

 
JSON.parse: unexpected end of data at line 1 column 1 of the JSON data
 
There are approximately 1800 records in my list and the failure seems to happen at around 1400 records. Ive tried sorting the table differently with the same result. all fields are the same type: short text.

please help - i am ready to go supernova

0 Replies