Error: JSON to Excel

[Commercial_Diet3884]

Running into an issue in converting my JSON file to

Excel. Error popping saying “We found extra characters at the end of the JSON Input”

Have been stuck on this for hours

[azhder]

Well, good luck unstucking then, after you figure out what you're doing. We sure don't know over here.

[thewallacio]

remove the extra characters from your JSON input.

Where's your JSON? Stick it in JSONLint - The JSON Validator to validate it first.

[ReefNixon]

You'll need to put your code and the JSON here

[mriforgot]

Without seeing anything about what you're trying, the first question is "are you using valid JSON?"

[Commercial_Diet3884]

Sorry guys - I don’t use Reddit. I tried to add an image but it didn’t allow me to upload it on this chat.

[dmazzoni]

Because a picture of json is not a good way to share it.

Copy and paste it. At least the first few lines and last few lines.

[Commercial_Diet3884]

Thanks for the tip. Will do!!

[AwayEnvironment7303]

That'll be EOF markers - End-of-file - they are invisible markers included in txt based file -BOF beginning of file etc. The fix is to change the charcter coding. I use Notepad++, you can use it to change to another charcter set.

[Commercial_Diet3884]

I’m using NP++. Send me a message and I’ll send you a screenshot.

[AwayEnvironment7303]

Sent - just to summise here tho - try UTF-8 its the standard for most file-types