How to load JSON in Excel

Download the .json file on Internet Explorer

1. Click on the following:
   • For Error Logs: http://bargeex.com:8080/api/errorlogs
   • For Sent Logs: http://bargeex.com:8080/api/sentlogs
2. Click 'Download' on the bottom

View the .json file

1. Open Microsoft Excel
2. Click the Data tab, and select 'Get Data> From File > From JSON'
   
   
   
   
3. Choose the file you downloaded
   
   
   
   
4. Click 'To Table' in the top left and select OK
   
   
   
   
   
5. At the top of the first row it'll say "Column1". Click the expand arrows next to 'Column1' and unselect 'Use original column names as prefix' and hit OK
   
   
   
   
   
6. Select 'Close & Load' in the top left. The json data should now show up as a table
   
   
   
   

Results

You should get the following: