You need to extract the bz2 file.
I think megarain once wrote a detailed post on how to open Json files in SQL in a betfair data thread.
I use excel myself so never had any need to open Json files
You can import json into excel but alot is dependant on your version of excel, just look on youtube they'll be lots of tutorials how to imort json files into your version of excel. There are even plenty of online or standalone convertors for json -> csv files out there too. No idea how big the files are and it may well be that you'd be better off using Access or some SQL database to query them
Who is online
Users browsing this forum: No registered users and 2 guests