# Unable to load json through APOC JsonParseException

**URL:** <https://community.neo4j.com/t/unable-to-load-json-through-apoc-jsonparseexception/37747>\
**Category:** Neo4j Graph Platform\
**Tags:** apoc, import, json\
**Created:** [May 3, 2021, 4:45am UTC](https://community.neo4j.com/t/unable-to-load-json-through-apoc-jsonparseexception/37747 "2021-05-03T04:45:16Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![e0508081](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/e0508081/32/17986_2.png) [@e0508081](https://community.neo4j.com/u/e0508081)\
**Post date:** [May 3, 2021, 4:45am UTC](https://community.neo4j.com/t/unable-to-load-json-through-apoc-jsonparseexception/37747/1 "2021-05-03T04:45:16Z")

</div>

Hello,

Some details on Config:  
Neo4j Browser version: [4.2.6]

Neo4j Server version: [4.2.1]

Question:

I am trying to upload a json file into neo4j browser. However, the following error is throwing up.

 ![Screenshot 2021-05-03 at 12.36.22 PM](https://us1.discourse-cdn.com/flex021/uploads/neo4jcommunity/original/3X/c/c/cc97024e3c47a2d71bde5f4438655b1537cf52b0.png)

Also, the file that I am trying to upload is this subset\_1.txt (converted from json to txt format for uploading on the discussion forum): [subset\_1.txt](https://community.neo4j.com/uploads/short-url/vB9x1Jom0azuS13sUUluzQF55Qq.txt) (1.0 MB)

Any idea on why this json while is not getting loaded and what this error means? do I need to reformat my json file to upload on Neo4j

---

<div class="post-metadata">

**Author:** ![Cobra](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/cobra/32/35243_2.png) [@Cobra](https://community.neo4j.com/u/Cobra)\
**Post date:** [May 3, 2021, 7:33am UTC](https://community.neo4j.com/t/unable-to-load-json-through-apoc-jsonparseexception/37747/2 "2021-05-03T07:33:53Z")

</div>

Hello @e0508081 🙂

There is an error in your JSON that's why APOC can't parse it. Your JSON is not valid, you need to find the character that breaks the file.

You can use [this tool](https://jsonformatter.curiousconcept.com/) to help you.

Regards,  
Cobra

---

<div class="post-metadata">

**Author:** ![clem](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/clem/32/4364_2.png) [@clem](https://community.neo4j.com/u/clem)\
**Post date:** [May 4, 2021, 6:25pm UTC](https://community.neo4j.com/t/unable-to-load-json-through-apoc-jsonparseexception/37747/3 "2021-05-04T18:25:11Z")

</div>

Alternatively, if you use python:

```auto
import json
json.loads(myJSONasString)

```

will report the line and column number where it is having trouble.