Converting JSON to HTML table in Python

Question

I've been using the JSON library for Python to get data from JSON files using Python.

infoFromJson = json.loads(jsonfile)

I fully understand how to work with JSON files in Python. However, I am trying to find a way to format JSON format in a nice way.

I prefer to convert the JSON into a nested HTML table format.

I found json2html for Python, which does exactly what I just described. However, it does not actually output anything when I run the script they provide.

Has anyone had experience with this tool? Or does anyone have suggestions for alternatives?

OneCricketeer · Accepted Answer · 2022-01-17 15:19:12Z

22

Try the following:

infoFromJson = json.loads(jsonfile)
print(json2html.convert(json = infoFromJson))

The result from json2html.convert is a string.

If you don't have json2html module:

$ pip install json2html

More examples here.

edited Jan 17, 2022 at 15:19

OneCricketeer

193k20 gold badges146 silver badges276 bronze badges

answered Jun 23, 2015 at 19:00

Kyle Shrader

96211 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

OMGitzMidgar Over a year ago

This works, thank you! For some reason, if I try to combine the two lines you provided into one line, it does not print out anything (including no errors). Thanks for the help!

Kyle Shrader Over a year ago

I doubt it's a naming/scope issue, but does it work in a single line if you alias the import for json to a different name?

OMGitzMidgar Over a year ago

Sorry, can you further explain what you mean by "aliasing the import for json to a different name" ?

Kyle Shrader Over a year ago

The issue you're seeing while doing this in one line might be the fact that the json library and the json default parameter are named similarly. But i have no idea :P import json as jason; print json2html.convert(json = jason.loads(jsonfile) none the less, glad it works. ^_^

Robert Lugg Over a year ago

At least for me, it looks like import json2html and json2html.json2html.convert

|

Vedanta6 · Accepted Answer · 2018-07-24 15:42:53Z

3

Nowadays it's better to use json2table (at least for Python 3)

import json2table
import json

infoFromJson = json.loads(jsonfile)
build_direction = "LEFT_TO_RIGHT"
table_attributes = {"style": "width:100%"}
print(json2table.convert(infoFromJson, 
                         build_direction=build_direction, 
                         table_attributes=table_attributes))

answered Jul 24, 2018 at 15:42

Vedanta6

991 silver badge5 bronze badges

3 Comments

mit Over a year ago

I tried out both json2html and json2table with python 3 and had some issues with json2table using complex json structures. I am going with json2html and can't see why I shouldn't. Code looks ok and project is maintained.

Constantine Kurbatov Over a year ago

This version is good as has more flexibility in formatting.

shailesh gavathe Over a year ago

Only problem with json2html is that after you convert complex JSON into html, the final format is not readable by python FPDF.

Collectives™ on Stack Overflow

Converting JSON to HTML table in Python

2 Answers 2

7 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related