HTML table to JSON array

This calculator extracts structured data from HTML. Copy HTML table code to Html table field and get well-formed JSON representation.
The calculator removes all leading and trailing spaces. Use Numeric data parameter to convert data in numeric form. Data compression becomes available for numeric data.

Convert HTML table to JSON

<table> <thead> <tr><th>H1</th><th>H2</th> </thead> <tbody> <tr><td>33</td><td>30</td><td>28</td><td>27</td><td>25</td><td>22</td><td>19</td></tr> <tr><td>30</td><td>29</td><td>28</td><td>26</td><td>25</td><td>24</td><td>24</td></tr> </tbody> </table>

HTML table code

Numeric dataNone In body In body and headers

Empty cell fill value

Transpose body

Row compression

Calculation precision

Digits after the decimal point: 2

Calculate

JSON

 

Compression ratio

 

Line numbers to show on graph

Comma separated string numbers or string number ranges. String number starts with 1.

Data chart

The file is very large. Browser slowdown may occur during loading and creation.

Download 

 Link  Save  Widget

Numeric table data compression algorithm

The calculator code (Licensed under CC-SA) contains an experimental algorithm for smooth function table data compression. The algorithm compresses data per row, forming an array of rows containing numbers and single-byte UTF-8 strings compatible with HTML.
I observed a maximum compression ratio of 31:1 during my experiments with big table data for Petroleum product density converter.

Due to the algorithm works on a single table row, consequent data must also be placed in rows to compress it effectively. If your table contains consequent data in columns, you should switch on the transpose option to replace rows with columns.

The compression works only with numeric data; empty cells must be replaced with some value (0 by default). You may explicitly set a placeholder value if zero does not suit you.