Table2Chart

PHP/JS tool which visualizes tables

Fork me on GitHub
This tool visualizes tables automatically by creating a structured table array. It decides which chart type is the best choice.
This is open source so everybody can improve this tool and of course use it for free (It's licensed under the MIT License).
To create charts I use Chart.js by Nick Downie.
I use leafletjs.com to draw the maps for the MapChart.
Now it's possible to visualize your own html tables here!


Line charts

Tables with a date based column are interpreted as line charts.


Required
  • one date column
  • one or more value or percentage columns
VIP birthdays
Source: en.wikipedia.org
DayNumber of birthdaysin 19th centuryin 20th century
1 January37647302
2 January22832187
3 January20736161
4 January23527199
5 January22023184
6 January25239192
7 January23029189
8 January24945188
9 January24237193
10 January29139235
11 January25640201
12 January27929228
13 January24131195
14 January24827203
15 January23840187
16 January24832202
17 January27541212
18 January23029188
19 January22621192
20 January24727202
21 January22329187
22 January26431216
23 January19828161
24 January19817161
25 January20018164
26 January21720186
27 January23833191
28 January22229176
29 January27520241
30 January19920168
31 January20916182
1 February25126208
2 February24935191
3 February22428185
4 February21625178
5 February32820291
6 February28755198
7 February20717183
8 February20625162
9 February23325190
10 February22223188
11 February23127191
12 February24629190
13 February26831226
14 February26631223
15 February24937194
16 February22630182
17 February24431199
18 February26526223
19 February24131199
20 February23120197
21 February23123194
22 February27240216
23 February20324165
24 February22523180
25 February26331215
26 February23425194
27 February27140218
28 February25228207
29 February12113103
1 March24626204
2 March22421192
3 March23138182
4 March66573567
5 March22123177
6 March21519180
7 March21521178
8 March23322195
9 March21420180
10 March21921184
11 March24824219
12 March25735206
13 March20523164
14 March22436185
15 March26538211
16 March25336199
17 March23325196
18 March28628240
19 March23327189
20 March23924203
21 March24824214
22 March22724186
23 March23429195
24 March23936190
25 March22825188
26 March22327186
27 March779125615
28 March29129244
29 March24121210
30 March21521188
31 March31821273
1 April29332249
2 April24017208
3 April27339219
4 April27827233
5 April23923200
6 April28030235
7 April22826189
8 April23022196
9 April24023201
10 April22519191
11 April22924191
12 April24825205
13 April25935205
14 April22021186
15 April25328207
16 April30233253
17 April23027187
18 April25624222
19 April22817196
20 April26135213
21 April22520193
22 April25724222
23 April22529181
24 April21815194
25 April23915207
26 April20522170
27 April22927194
28 April19618169
29 April24725212
30 April19926160
1 May27336223
2 May22627181
3 May22730185
4 May24314215
5 May21123180
6 May21927176
7 May21621180
8 May26127218
9 May21421188
10 May26332215
11 May23231191
12 May25430212
13 May25716224
14 May26522225
15 May24225207
16 May22316201
17 May23624198
18 May24023206
19 May20320174
20 May26322227
21 May22121188
22 May27433223
23 May25532209
24 May23426198
25 May24230201
26 May20616181
27 May22628186
28 May23122197
29 May22811206
30 May23731195
31 May21523179
1 June23317199
2 June22320195
3 June22125186
4 June22913205
5 June21122177
6 June24421206
7 June20523172
8 June22018193
9 June24423211
10 June25725224
11 June21220177
12 June25721227
13 June30527265
14 June20523173
15 June26014229
16 June23427193
17 June22025187
18 June23822203
19 June25123216
20 June24725196
21 June33545261
22 June23326197
23 June19511170
24 June25928206
25 June21213190
26 June23120199
27 June21223183
28 June23514207
29 June23633193
30 June22219195
1 July24122205
2 July20814182
3 July19719167
4 July24823217
5 July25033200
6 July20620174
7 July19317167
8 July17721147
9 July19618167
10 July22126181
11 July22916199
12 July22628193
13 July21317185
14 July20718176
15 July21019178
16 July21120181
17 July22217195
18 July20026164
19 July20628170
20 July21818191
21 July20421178
22 July22023182
23 July22221190
24 July22026184
25 July22120187
26 July22631189
27 July22225184
28 July19721168
29 July21328179
30 July16918145
31 July23125195
1 August28121243
2 August23633193
3 August20422177
4 August22819199
5 August23127192
6 August22025180
7 August21311188
8 August24819217
9 August21611186
10 August24228201
11 August21425180
12 August22326186
13 August22024185
14 August21623177
15 August22931186
16 August20327164
17 August20821176
18 August20422167
19 August22820193
20 August32123286
21 August21418182
22 August21126175
23 August22524190
24 August22720191
25 August22719194
26 August21021177
27 August22930189
28 August21519181
29 August20521172
30 August18920162
31 August21421183
1 September25432210
2 September19327162
3 September18718160
4 September21422180
5 September25429200
6 September22428184
7 September24235197
8 September26029207
9 September25730208
10 September21441158
11 September23332188
12 September23328195
13 September23636187
14 September23726198
15 September23635188
16 September23830194
17 September24324204
18 September24531198
19 September24817221
20 September21824184
21 September23423198
22 September25127209
23 September23222195
24 September22529181
25 September28718250
26 September22036175
27 September24326199
28 September21125178
29 September25223208
30 September22321191
1 October25722219
2 October20621176
3 October18027146
4 October21228164
5 October23425195
6 October19119156
7 October21020177
8 October21428176
9 October20126165
10 October22619196
11 October21924183
12 October21721184
13 October20318174
14 October22523183
15 October21826182
16 October20727161
17 October20214176
18 October20121163
19 October18820152
20 October21625176
21 October20813181
22 October18327146
23 October18322148
24 October32721296
25 October21227173
26 October18423144
27 October18917164
28 October19723162
29 October17420149
30 October19728159
31 October23926196
1 November22830173
2 November19724152
3 November23324194
4 November19918172
5 November22025180
6 November16119133
7 November24026204
8 November20923171
9 November20537155
10 November27030222
11 November19720160
12 November21220180
13 November18527144
14 November21822184
15 November19925155
16 November19125157
17 November21017178
18 November21920188
19 November21731173
20 November19120161
21 November21022176
22 November22729183
23 November22626184
24 November19634143
25 November21538165
26 November20022168
27 November20625168
28 November20719172
29 November21928179
30 November23225182
1 December20410181
2 December19724165
3 December21536171
4 December17619144
5 December21933172
6 December21429168
7 December18219149
8 December21926182
9 December23831190
10 December19527163
11 December21324179
12 December23121193
13 December20819176
14 December21617183
15 December17216150
16 December22221189
17 December23219199
18 December20027162
19 December20321175
20 December19121161
21 December20832166
22 December17929139
23 December19814169
24 December19936145
25 December24831193
26 December18922151
27 December19815172
28 December19814171
29 December17416154
30 December21019181
31 December21120172

Visualize it!
Save as png

Bar charts

A lot of tables can be interpreted as bar graphs or stacked bar graphs.


Required
  • one string column
  • one or more value or percentage columns
Goals WM 2010 (incl. penalties)
Source: http://en.wikipedia.org/wiki/2010_FIFA_World_Cup
Country Final Ranking Goals
Uruguay 4 12
Mexico 14 1
South Africa 20 3
France 28 1
Argentina 5 10
South Korea 15 6
Greece 25 2
Nigeria 27 3
United States 12 5
England 13 3
Slovenia 18 3
Algeria 28 0
Germany 3 16
Ghana 7 6
Australia 21 3
Serbia 23 2
Netherlands 2 12
Japan 9 7
Denmark 24 3
Cameroon 31 2
Paraguay 8 8
Slovakia 16 5
New Zealand 22 2
Italy 25 4
Brazil 6 9
Portugal 11 7
Ivory Coast 17 4
North Korea 32 1
Spain 1 8
Chile 10 3
Switzerland 19 1
Honduras 30 0

Visualize it!
Save as png

Stacked bar charts

Stacked bar charts can show 100% bar charts in a better way.


Required
  • one string column
  • percentage columns with the sum of 100%
Work day Sleeping Eating Programming Doing sth. else
Monday 30% 10% 40% 20%
Tuesday 30% 10% 45% 15%
Wednesday 40% 10% 40% 10%
Thursday 40% 10% 20% 30%
Friday 40% 10% 10% 40%

Visualize it!
Save as png

Pie charts

Pie charts are great at comparing percentage proportions.


Required
  • one string column
  • one percentage column with the sum of 100%
2012 US elections
Vote %
Barack Obama 51.06
Mitt Romney 47.21
invalid 1.73

Visualize it!
Save as png

Map charts

Map charts are great to visualize map-related data.


Required
  • one country column
  • one label or value column
Ebola Cases
Source: Wikipedia
Date 09.02.15 07.02.15 01.02.15 25.01.15 18.01.15 11.01.15 04.01.15 28.12.14 24.12.14 21.12.14 14.12.14 09.12.14 07.12.14 30.11.14 28.11.14 23.11.14 18.11.14 16.11.14 11.11.14 09.11.14 04.11.14 02.11.14 30.10.14 24.10.14 19.10.14 17.10.14 12.10.14 07.10.14 05.10.14 01.10.14 28.09.14 25.09.14 23.09.14 21.09.14 17.09.14 14.09.14 10.09.14 07.09.14 03.09.14 31.08.14 25.08.14 20.08.14 18.08.14 16.08.14 13.08.14 01.08.14 11.08.14 09.08.14 06.08.14 04.08.14
Guinea 3068 3042 2975 2917 2871 2806 2775 2707 2630 2597 2415 2339 2292 2164 2155 2134 2047 1971 1919 1878 1760 1731 1675 1598 1540 1501 1472 1350 1298 1199 1157 1103 1074 1022 965 942 899 861 823 771 648 607 579 543 519 510 506 495 495 485
Liberia 8931 8881 8745 8622 8478 8331 8171 8018 7977 7876 7819 7797 7765 7653 7635 7196 7082 7069 6878 6822 6619 6524 6485 6253 4665 4607 4249 4076 3924 3834 3696 3564 3458 3280 3022 2720 2415 2081 1863 1698 1378 1082 972 834 786 670 599 554 516 468
Sierra Leone 10958 10905 10740 10518 10340 10124 9780 9446 9203 9004 8356 8014 7897 7312 7109 6599 6190 6073 5586 5368 4821 4759 4487 4017 3706 3560 3252 2937 2789 2437 2317 2120 2021 1940 1753 1655 1509 1424 1292 1216 1026 910 907 848 810 783 730 717 691 646
Nigeria 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 21 21 22 22 22 21 19 16 15 15 12 12 13 13 9 4
Senegal 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
United States 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 3 3 2 1 1 1 1
Spain 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Mali 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 6 6 4 4 1 1 1 1
United Kingdom 1 1 1 1 1 1 1 1

Visualize it!