Help:Table

This page gives you information about syntax to build wiki-tables in MediaWiki.

Spreadsheet to wiki table formatEdit

To convert from spreadsheets such as Gnumeric, MS Excel or OpenOffice.org Calc, see http://tools.wmflabs.org/excel2wiki/ .

Using the toolbarEdit

You can use the Mediawiki edit toolbar to create tables on Wikipedia, and some Wikimedia projects. It is helpful to generate the necessary codings. However, on many MediaWiki wikis (and by default) the table tool is not available.

Use the first button on the right of the toolbar to insert a table when editing a page.

By default, it includes the following text:

code

result

{| class="wikitable"
|-
! header 1
! header 2
! header 3
|-
| row 1, cell 1
| row 1, cell 2
| row 1, cell 3
|-
| row 2, cell 1
| row 2, cell 2
| row 2, cell 3
|}

header 1	header 2	header 3
row 1, cell 1	row 1, cell 2	row 1, cell 3
row 2, cell 1	row 2, cell 2	row 2, cell 3

Pipe syntax tutorialEdit

Column heading 1	Column heading 2	Column heading 3
Row heading 1	Cell 2	Cell 100
Row heading A	Cell B	Cell C

Although HTML table syntax also works, special MediaWiki code can be used as a shortcut to create a table. Formatting codes function the same as in HTML table markup. The shortcuts are as follows:

The entire table is encased with curly brackets and a vertical bar character (a pipe). So use {| to begin a table, and |} to end it. Each one needs to be on its own line:

{|
  table code goes here
|}

An optional table caption is included with a line starting with a vertical bar and plus sign "|+" and the caption after it:

{|
|+ caption
  table code goes here
|}

To start a new table row, type a vertical bar and a hyphen on its own line: "|-". The codes for the cells in that row will start on the next line.

{|
|+ The table's caption
|-
  cell code goes here (first row)
|-
  cell code goes here (second row)
|}

Type the codes for each table cell in the next row, starting with a bar:

{|
|+ The table's caption
|-
| cell codes go here
|-
| cells in the next row go here
| more cells in the same row here
|}

Cells can be separated with either a new line and new bar, or by a double bar "||" on the same line. Both produce the same output:

{|
|+ The table's caption
|-
|Cell 1 || Cell 2 || Cell 3
|-
|Cell A 
|Cell B
|Cell C
|}

If you use single bars, then what might appear to be the first cell is in fact a format modifier applied to the cell, and the rest of your "cells" will be merged into one:

{| border="1"
|-
|format modifier (not displayed)|These all |(including the pipes)|go into |the first cell
|-
|}

which is probably not what you want:

These all |(including the pipes)|go into |the first cell

However, the format modifier is useful:

{| border="1"
|-
|Cell 1 (no modifier - not aligned)
|-
|align="right" |Cell 2 (right aligned)
|-
|}

Cell 1 (no modifier - not aligned)

Cell 2 (right aligned)

Just remember: no more than 2 single pipes on a line!

a row of column headings is identified by using "!" instead of "|", and using "!!" instead of "||". Header cells typically render differently from regular cells, depending on the browser. They are often rendered in a bold font and centered.

{|
|+ The table's caption
! Column heading 1 !! Column heading 2 !! Column heading 3
|-
|Cell 1 || Cell 2 || Cell 3
|-
|Cell A
|Cell B
|Cell C
|}

the first cell of a row is identified as row heading by starting the line with "!" instead of "|", and starting subsequent data cells on a new line.

{|
|+ The table's caption
! Column heading 1 !! Column heading 2 !! Column heading 3
|-
! Row heading 1 
| Cell 2 || Cell 3
|-
! Row heading A 
|Cell B
|Cell C
|}

Optional parameters can modify the behavior of cells, rows, or the entire table. For instance, a border could be added to the table:

{| border="1"
|+ The table's caption
! Column heading 1 !! Column heading 2 !! Column heading 3
|-
! Row heading 1
| Cell 2 || Cell 3
|-
! Row heading A
|Cell B
|Cell C
|}

The final table would display like this:

The table's caption
Column heading 1 Column heading 2 Column heading 3
Row heading 1 Cell 2 Cell 3
Row heading A Cell B Cell C

The table parameters and cell parameters are the same as in HTML, see [1] and Table (HTML). However, the thead, tbody, tfoot, colgroup, and col elements are currently not supported in MediaWiki.

A table can be useful even if none of the cells have content. For example, the background colors of cells can be changed with cell parameters, making the table into a diagram, like Template talk:Square 8x8 pentomino example. An "image" in the form of a table is much more convenient to edit than an uploaded image.

Each row must have the same number of cells as the other rows, so that the number of columns in the table remains consistent. For empty cells, use the non-breaking space   as content to ensure that the cells are displayed. To show a visible pipe in a cell, use <nowiki>|</nowiki> or |.

With colspan and rowspan cells can span several columns or rows, see the Mélange example below.

ExamplesEdit

Simple exampleEdit

Both of these generate the same output. Choose a style based on the number of cells in each row and the total text inside each cell.

Wiki markup

{| 
| A 
| B
|- 
| C
| D
|}

{| 
| A || B
|- 
| C || D 
|}

What it looks like in your browser

A B
C D

Multiplication tableEdit

Wiki markup

{| class="wikitable" style="text-align:center"
|+Multiplication table
|-
! &times; !! 1 !! 2 !! 3
|-
! 1
| 1 || 2 || 3
|-
! 2
| 2 || 4 || 6
|-
! 3
| 3 || 6 || 9
|-
! 4
| 4 || 8 || 12
|-
! 5
| 5 || 10 || 15
|}

What it looks like in your browser (see: Help:User_style)

Multiplication table
× 1 2 3
1 1 2 3
2 2 4 6
3 3 6 9
4 4 8 12
5 5 10 15

Color; scope of parametersEdit

See also: Wiki color formatting help

Two ways of specifying color of text and background for a single cell are as follows. The first form is preferred:

Wiki markup

{| 
| style="background:red; color:white" | abc
| def
| bgcolor="red" | <span style="color:white"> ghi </span>
| jkl
|}

What it looks like in your browser

abc def ghi jkl

Note: The bgcolor is deprecated.

Like other parameters, colors can also be specified for a whole row or the whole table; parameters for a row override the value for the table, and those for a cell override those for a row:

Wiki markup

{| style="background:yellow; color:green"
|- 
| abc || def || ghi
|- style="background:red; color:white"
| jkl || mno || pqr
|-
| stu || style="background:#C1C1C1" | vwx || yz
|}

What it looks like in your browser

abc def ghi
jkl mno pqr
stu vwx yz

To make the table blend in with the background, use style="background:none" or style="background:transparent". (Note that style="background:inherit" didn't work with old browsers like IE6)

See : style, background, list of colors, web colors

Width, heightEdit

The width and height of the whole table can be specified, as well as the height of a row. To specify the width of a column one can specify the width of an arbitrary cell in it. If the width is not specified for all columns, and/or the height is not specified for all rows, then there is some ambiguity, and the result depends on the browser.

Wiki markup

{| style="width:75%; height:200px" border="1"
|- 
| abc || def || ghi
|- style="height:100px" 
| jkl || style="width:200px" |mno || pqr
|-
| stu || vwx || yz
|}

What it looks like in your browser

abc def ghi
jkl mno pqr
stu vwx yz

Note that style="inline CSS" used to have no effect with some old browsers. Nowadays you don't have to worry about it but in the past if compatibility was important, equivalent older constructs like width="75%" were used since they worked on more browsers.

Setting your column widthsEdit

If you wish to force column widths to your own requirements, rather than accepting the width of the widest text element in a column's cells, then follow this example. Note that wrap-around of text is forced.

{| border="1" cellpadding="2"
!width="50"|Name
!width="225"|Effect
!width="225"|Games Found In
|-
|Poké Ball || Regular Poké Ball || All Versions
|-
|Great Ball || Better than a Poké Ball || All Versions
|}

Name Effect Games Found In
Poké Ball Regular Poké Ball All Versions
Great Ball Better than a Poké Ball All Versions

To set column widths in a table without headers, specify the width in the first cell for each column, like this:

{| border="1" cellpadding="2"
|-
|width="100pt"|This column is 100 points wide
|width="200pt"|This column is 200 points wide
|width="300pt"|This column is 300 points wide
|-
|blah || blah || blah
|}

This column is 100 points wide This column is 200 points wide This column is 300 points wide
blah blah blah

One application of setting the widths is aligning columns of consecutive tables:

Country	Capital
The Netherlands	Amsterdam

Country	Capital
France	Paris

Vertical alignmentEdit

By default data in tables is vertically centrally aligned, which results in odd-looking layouts like this:

Row heading A longer piece of text. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. A shorter piece of text.
Row heading A longer piece of text.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. A shorter piece of text.

To fix this, apply the valign="top" attribute to the rows. In HTML5 valign attribute is deprecated so use style="vertical-align:top;" instead. (Unfortunately it seems to be necessary to apply this individually to every single row. That's why you can try class="toptextcells" or class="wikitable sortable toptextcells".) For example:

{| border="1" cellpadding="2"
|- valign="top"
|width="10%"|'''Row heading'''
|width="70%"|A longer piece of text. Lorem ipsum...
|width="20%"|A shorter piece of text.
|- style="vertical-align:top;"
|'''Row heading'''
|A longer piece of text. Lorem ipsum... 
|A shorter piece of text.
|}

Row heading A longer piece of text. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. A shorter piece of text.
Row heading A longer piece of text.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. A shorter piece of text.

PositioningEdit

One can position the table itself, and all contents in a row, and contents in a cell, but not with a single parameter for all contents in the table, see m:Template talk:Table demo.

MélangeEdit

Here's a more advanced example, showing some more options available for making up tables.

You can play with these settings in your own table to see what effect they have. Not all of these techniques may be appropriate in all cases; just because you can add colored backgrounds, for example, doesn't mean it's always a good idea. Try to keep the markup in your tables relatively simple -- remember, other people are going to be editing the article too! This example should give you an idea of what is possible, though.

Wiki markup

{| border="1" cellpadding="5" cellspacing="0" align="center"
|+'''An example table'''
|-
! style="background:#efefef;" | First header
! colspan="2" style="background:#ffdead;" | Second header
|-
| upper left
| upper middle
| rowspan=2 style="border-bottom:3px solid gray;" valign="top" |right side
|-
| style="border-bottom:3px solid gray;" | lower left
| style="border-bottom:3px solid gray;" | lower middle
|-
| colspan="3" align="center" |
{| border="0"
|+''A table in a table''
|-
| align="center" width="150px" | [[Image:Wiki.png]]
| align="center" width="150px" | [[Image:Wiki.png]]
|-
| align="center" colspan="2" style="border-top:1px solid #FF0000; border-right:1px solid red; border-bottom:2px solid red; border-left:1px solid red;" |
Two Wikimedia logos
|}
|}

What it looks like in your browser

An example table
First header Second header
upper left upper middle right side
lower left lower middle

A table in a table

Two Wikimedia logos

Floating tableEdit

Wiki markup

This paragraph is before the table.  Lorem ipsum dolor sit
amet, consectetur adipisicing elit, sed do eiusmod tempor
incididunt ut labore et dolore magna aliqua. Ut enim ad
minim veniam, quis nostrud exercitation...

{| align="right" border="1"
| Col 1, row 1 
|rowspan="2"| Col 2, row 1 (and 2) 
| Col 3, row 1 
|- 
| Col 1, row 2 
| Col 3, row 2 
|}

Note the floating table to the right.   

This paragraph is after the table.  Lorem ipsum dolor sit
amet, consectetur adipisicing elit, sed do eiusmod tempor
incididunt ut labore et dolore magna aliqua. Ut enim ad
minim veniam, quis nostrud exercitation...

What it looks like in your browser

This paragraph is before the table. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation...

Col 1, row 1 Col 2, row 1 (and 2) Col 3, row 1
Col 1, row 2 Col 3, row 2
Note the floating table to the right.
This paragraph is after the table. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation...

Non-floating tablesEdit

Wiki markup

This paragraph is before the tables.  Lorem ipsum dolor sit
amet, consectetur adipisicing elit, sed do eiusmod tempor
incididunt ut labore et dolore magna aliqua. Ut enim ad
minim veniam, quis nostrud exercitation...

{| border="1"
|+Left Aligned Table
| Col 1, row 1 
|rowspan="2"| Col 2, row 1 (and 2) 
| Col 3, row 1 
|- 
| Col 1, row 2 
| Col 3, row 2 
|}

<br style="clear:both;">

This paragraph is between the tables. Lorem ipsum dolor sit
amet, consectetur adipisicing elit, sed do eiusmod tempor
incididunt ut labore et dolore magna aliqua. Ut enim ad
minim veniam, quis nostrud exercitation...

{| border="1" align="center"
|+Centered Table
| Col 1, row 1 
|rowspan="2"| Col 2, row 1 (and 2) 
| Col 3, row 1 
|- 
| Col 1, row 2 
| Col 3, row 2 
|}

<br style="clear:both;">

This paragraph is after the tables.  Lorem ipsum dolor sit
amet, consectetur adipisicing elit, sed do eiusmod tempor
incididunt ut labore et dolore magna aliqua. Ut enim ad
minim veniam, quis nostrud exercitation...

What it looks like in your browser

This paragraph is before the tables. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation...

Left Aligned Table
Col 1, row 1 Col 2, row 1 (and 2) Col 3, row 1
Col 1, row 2 Col 3, row 2

This paragraph is between the tables. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation...

Centered Table
Col 1, row 1 Col 2, row 1 (and 2) Col 3, row 1
Col 1, row 2 Col 3, row 2

This paragraph is after the tables. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation...

Nested tablesEdit

Five different (blue) tables are shown nested inside the cells of a table. Automatically the two tables |A| and |B|B| are vertically aligned instead of the usual side by side of text characters in a cell. "float" is used to fix each of tables |C| and |D| to their own position within one cell of the table. This may be used for charts and schemes. Nested tables must start on a new line.

Wiki markup

 1 {| border="1"
 2 | &alpha;
 3 | align="center" | cell2
 4 {| border="2" style="background:#ffffcc" <!-- The nested table must be on a new line -->
 5 | NESTED
 6 |-
 7 | TABLE
 8 |}
 9 | valign="bottom" | the original table again
10 | style="width:100px" |
11 {| border="2" style="background:#ffffcc"
12 | A
13 |}
14 {| border="2" style="background:#ffffcc"
15 | B || B
16 |}
17 | style="width:50px" |
18 {| border="2" style="background:#ffffcc; float:left"
19 | C
20 |}
21 {| border="2" style="background:#ffffcc; float:right"
22 | D
23 |}
24 |}

As it appears in a browser:

α

cell2

NESTED

TABLE

the original table again

A

B

C

D

Combined use of COLSPAN and ROWSPANEdit

Wiki markup

{| border="1" cellpadding="5" cellspacing="0"
|-
| Column 1 || Column 2 || Column 3
|-
| rowspan="2"| A
| colspan="2" align="center"| B
|-
| C <!-- column 1 occupied by cell A -->
| D 
|-
| E
| rowspan="2" colspan="2" align="center"| F
|- 
| G <!-- column 2+3 occupied by cell F -->
|- 
| colspan="3" align="center"| H
|}

What it looks like in your browser

Column 1 Column 2 Column 3
A B
C D
E F
G
H

Note that using rowspan="2" for cell G combined with rowspan="3" for cell F to get another row below G and F won't work, because all (implicit) cells would be empty. Likewise complete columns are not displayed if all their cells are empty. Borders between non-empty and empty cells might be also not displayed (depending on the browser), use   to fill an empty cell with dummy content.

Centering tablesEdit

Centered tables can be achieved, but they will not "float"; that is to say, no text will appear to either side. The trick is {| style="margin: 1em auto 1em auto"

Wiki markup

{| class="wikitable" style="margin: 1em auto 1em auto"
|+ '''Cells left-aligned, table centered'''
! Duis || aute || irure
|-
| dolor  || in reprehenderit || in voluptate velit
|-
| esse cillum dolore || eu fugiat nulla || pariatur.
|}

What it looks like in your browser

Cells left-aligned, table centered
Duis aute irure
dolor in reprehenderit in voluptate velit
esse cillum dolore eu fugiat nulla pariatur.

Setting parametersEdit

At the start of a cell, add your parameter followed by a single pipe. For example width="300"| will set that cell to a width of 300 pixels. To set more than one parameter, leave a space between each one.

Wiki markup

{| style="color:white"
|-
| style="background:red"|cell1 || width="300" style="background:blue"|cell2 || style="background:green"|cell3
|}

What it looks like in your browser

cell1 cell2 cell3

Decimal point alignmentEdit

A simple and reliable way to achieve decimal point alignment is to use Template:0, assuming it has been defined along the following lines:

<span style="visibility:hidden;color:transparent;">{{{1|0}}}</span>

See wikipedia:Template:0 for further details.

Another method to get columns of numbers aligned at the decimal point is as follows:

Wiki markup

{| cellpadding="0" cellspacing="0"
|align="right"| 432 || .1
|-
|align="right"| 43 || .21
|-
|align="right"| 4 || .321
|}

What it looks like in your browser

432 .1
43 .21
4 .321

If the column of numbers appears in a table with cell padding or cell spacing, one can still align the decimal points without an unsightly gap in the middle. Embed a table in each number's cell and specify its column widths. Make the embedded tables' column widths the same for each cell in the column. (If decimal points are still misaligned using this method, the main table's column may be too narrow. Add a parameter to increase the column's width.)

Wiki markup

{|border="1" cellpadding="4" cellspacing="2" width="50%"
|
{|cellpadding="0" cellspacing="0" width="100%"
|align="right" width="50%"| 432 ||width="50%"| .1
|}
|-
|
{|cellpadding="0" cellspacing="0" width="100%"
|align="right" width="50%"| 43 ||width="50%"| .21
|}
|-
|
{|cellpadding="0" cellspacing="0" width="100%"
|align="right" width="50%"| 4 ||width="50%"| .321
|}
|}

What it looks like in your browser

432 .1

43 .21

4 .321

In simple cases one can dispense with the table feature and simply start the lines with a space, and put spaces to position the numbers:

432.1
 43.21
  4.321

Style classesEdit

See also Help:User style.

In the first line of table code, after the "{|", instead of specifying a style directly one can also specify a CSS class. The style for this class can be specified in various ways:

in the software itself, per skin (for example the class sortable, used at wikibits.js)
collectively for all users of one wiki in MediaWiki:Common.css (for example, on this and some other projects there is the class wikitable)
separately per skin in MediaWiki:Monobook.css etc.
individually on one wiki in a user subpage
individually, but jointly for tables of the class concerned on all web pages, on the local computer of the user.

Instead of remembering table parameters, you just include an appropriate style class after the {|. This helps keep table formatting consistent, and can allow a single change to the class to fix a problem or enhance the look of all the tables that are using it at once. For instance, this:

Wiki markup

What it looks like in your browser

{| border="1" cellpadding="2"
|+Multiplication table
|-
! &times; !! 1 !! 2 !! 3
|-
! 1
| 1 || 2 || 3
|-
! 2
| 2 || 4 || 6
|-
! 3
| 3 || 6 || 9
|-
! 4
| 4 || 8 || 12
|-
! 5
| 5 || 10 || 15
|}

Multiplication table
× 1 2 3
1 1 2 3
2 2 4 6
3 3 6 9
4 4 8 12
5 5 10 15

becomes with wikitable this:

{| class="wikitable"
|+Multiplication table
|-
! &times; !! 1 !! 2 !! 3
|-
! 1
| 1 || 2 || 3
|-
! 2
| 2 || 4 || 6
|-
! 3
| 3 || 6 || 9
|-
! 4
| 4 || 8 || 12
|-
! 5
| 5 || 10 || 15
|}

Multiplication table
× 1 2 3
1 1 2 3
2 2 4 6
3 3 6 9
4 4 8 12
5 5 10 15

simply by replacing inline CSS for the table by class="wikitable". This is because the wikitable class in MediaWiki:Common.css and the "../skins/common/shared.css" file contain a number of table.wikitable CSS style rules. These are all applied at once when you mark a table with the class. You can then add additional style rules if desired. These override the class's rules, allowing you to use the class style as a base and build up on it:

Wiki markup

What it looks like in your browser

{| class="wikitable" style="font-style:italic; 
font-size:120%; border:3px dashed red;"
|+Multiplication table
|-
! &times; !! 1 !! 2 !! 3
|-
! 1
| 1 || 2 || 3
|-
! 2
| 2 || 4 || 6
|-
! 3
| 3 || 6 || 9
|-
! 4
| 4 || 8 || 12
|-
! 5
| 5 || 10 || 15
|}

Multiplication table
× 1 2 3
1 1 2 3
2 2 4 6
3 3 6 9
4 4 8 12
5 5 10 15

Notice that the table retains the gray background of the wikitable class, and the headers are still bold and centered. But now the text formatting has been overridden by the local style statement; all of the text in the table has been made italic and 120% normal size, and the wikitable border has been replaced by the red dashed border.

Of course this works only for browsers supporting inline CSS, if it's important use XHTML markup like <big> instead of "font-size:120%", or Wiki markup like ''text'' instead of "font-style:italic".

SortingEdit

Tables can be made sortable by adding class="sortable"; for details see Help:Sorting. Since this can be very useful, it is wise to keep the possibilities and limitations of this feature in mind when designing a table. For example:

Do not divide a table into sections by subheaders spanning several rows. Instead, an extra column can be made showing the content of these headers on each row, in a short form.
Do not have elements spanning several columns; instead, again, repeat the content on each row, in a short form.
In a column of numbers, do not put text such as "ca." in front of a number—it will sort like zero. Do not put text after the number, and do not put a range of numbers (it does not affect the sorting position for numeric sorting mode, and in the case of a range, the first number determines the position, but if, possibly after sorting this or another column, the element is at the top, it will induce alphabetic sorting mode). Instead, put these texts in a separate column. Alternatively, for the greatest flexibility, alphabetic sorting mode with hidden sortkeys can be used.

A long form of abbreviated content can be put as legend outside the table.

Wiki markup

{| class="wikitable sortable"
|+Sortable table
|-
! Alphabetic !! Numeric !! Date !! class="unsortable" | Unsortable
|-
| d || 2 || 2008-11-24 || This
|-
| b || 8 || 2004-03-01 || column
|-
| a || 6 || 1979-07-23 || cannot
|-
| c || 4 || 1492-12-08 || be
|-
| e || 0 || 1601-08-13 || sorted.
|}

What it looks like in your browser

Sortable table
Alphabetic Numeric Date Unsortable
d 2 2008-11-24 This
b 8 2004-03-01 column
a 6 1979-07-23 cannot
c 4 1492-12-08 be
e 0 1601-08-13 sorted.

Sortable except final rowEdit

If the last row of the table should not be sorted (for example, if it contains the sum of figures in the preceding rows) use class="sortbottom" before the last row, as the following:

Wiki markup

{| class="wikitable sortable" 
|-
!Class!!Female!!Male
|-
|1||22||65
|-
|2||33||87
|-
|3||15||45
|-
|4||70||95
|-
|5||65||110
|- class="sortbottom"
|Sum||205||402
|}

What it looks like in your browser

Class Female Male
1 22 65
2 33 87
3 15 45
4 70 95
5 65 110
Sum 205 402

Note that formatting the last row as "footer" cells (i.e., using ! and !! instead of | and ||) has the same effect. See Help:Sorting § Excluding the last row from sorting.

Row templateEdit

Regardless of whether wikitable format or HTML is used, the wikitext of the rows within a table, and sometimes even within a collection of tables, has much in common, e.g.:

the basic code for a table row
code for color, alignment, and sorting mode
fixed texts such as units
special formats for sorting

In that case it can be useful to create a template that produces the syntax for a table row, with the data as parameters. This can have many advantages:

easily changing the order of columns, or removing a column
easily adding a new column if many elements of the new column are left blank (if the column is inserted and the existing fields are unnamed, use a named parameter for the new field to avoid adding blank parameter values to many template calls)
computing fields from other fields, e.g. population density from population and area
duplicating content and providing span tags with "display:none" for the purpose of having one format for sorting and another for display
easy specification of a format for a whole column, such as color and alignment

Example:

Using Help:table/example row template

{| class="wikitable sortable"
|-
! a
! b
! a/b
{{help:table/example row template|  50|200}}
{{help:table/example row template|   8| 11}}
{{help:table/example row template|1000| 81}}
|}

gives:

a	b	a/b
50	200	0.25
8	11	0.72727272727273
1000	81	12.345679012346

Producing table syntax using templates and/or parser functionsEdit

When producing table syntax using templates and/or parser functions, a pipe character in a parameter has to be coded {{!}}, which uses Template:!, to avoid being interpreted as parameter separator for the template or parser function. see Template:Table example with optional row.

In the case of a conditional table row we typically need code of the form "{{!}}-newline{{!}}.. newline" as then- or else-part of an if-construct. To avoid trimming, use a branching template (in this example Template:Ifnotempty) that preserves the newline:

{| class=wikitable
{{ifnotempty|x|{{!}}-
{{!}}a
}}{{ifnotempty||{{!}}-
{{!}}b
}}{{ifnotempty||{{!}}-
{{!}}c
}}{{ifnotempty||{{!}}-
{{!}}d
}}{{ifnotempty|x|{{!}}-
{{!}}e
}}
|}

gives

a
e

Alternatively, XHTML table syntax can be used. It is not sensitive to line breaks and lets you avoid branching templates, {{=}} and extra {{!}} hacks.

Other table syntaxEdit

Other types of table syntax that MediaWiki supports:

XHTML
HTML & wiki-<td> syntax (Do not use)

All three are supported by MediaWiki and create (currently) valid HTML output, but the pipe syntax is the simplest. Also, HTML & wiki-<td> syntax (i.e., unclosed <td> and <tr> tags) will not necessarily remain browser-supported in the upcoming future, especially on handheld internet-accessible devices.

Tables using HTML syntax can have pieces in templates only if the variable $wgUseTidy has been set, as is the case in most Wikimedia projects.

See also Table (HTML), HTML element#Tables. Note however that the thead, tbody, tfoot, colgroup, and col elements are currently not supported in MediaWiki.

XHTML HTML & Wiki-td Wiki-pipe

Table

<table></table>

{|
|}

Caption

<caption>caption</caption>

|+ caption

Row

<tr></tr>

<tr>

|-

Data cell

<td>cell1</td>

<td>cell2</td>

<td>cell1

<td>cell2

| cell1
| cell2

Data cell

<td>cell1</td> <td>cell2</td> <td>cell3</td>

<td>cell1 <td>cell2 <td>cell3

| cell1 || cell2 || cell3

Header cell

<th>heading</th>

<th>heading

! heading

Sample table

1	2
3	4

<table>
   <tr>
      <td>1</td>
      <td>2</td>
   </tr> 
   <tr>
      <td>3</td> 
      <td>4</td> 
   </tr>
</table>

<table>
   <tr>
      <td> 1 <td> 2
   <tr>
      <td> 3 <td> 4
</table>

{| 
| 1 || 2
|- 
| 3 || 4
|}

Sample table

1	2
3	4
5	6

<table>
   <tr>
      <td>1</td>
      <td>2</td>
   </tr> 
   <tr>
      <td>3</td>
      <td>4</td>
   </tr>
   <tr>
      <td>5</td>
      <td>6</td>
   </tr>
</table>

<table>
   <tr>
      <td> 1 <td> 2
   <tr>
      <td> 3 <td> 4
   <tr>
      <td> 5 <td> 6
</table>

{| 
| 1 || 2 
|- 
| 3 || 4 
|- 
| 5 || 6 
|}

Pros

Can be previewed/debugged with any XHTML editor
Can be formatted for easier reading
Well-known
Newlines not needed, but to some extent allowed
No characters like "|" which can collide with template and parser function syntax
Harder to shoot yourself in the foot with than HTML, since proper nesting and tag closure are enforced

Can be previewed/debugged with any HTML editor
Can be formatted for easier reading
Well-known
Takes less space than XHTML
Newlines not needed, but to some extent allowed
No characters like "|" which can collide with template and parser function syntax

Easy to write
Easy to read
Takes little space

Cons

Tedious
Takes a lot of space
Difficult to read quickly

May not have browser support in future

Unfamiliar syntax
Rigid structure
Cannot be indented
Text (as in HTML tags) may be easier for some people to read than series of pipes, plus signs, exclamation marks, etc.
Is nothing more than a shortcut for HTML-style tags. Not easily understood by those unfamiliar with HTML table concepts
Assigning to a template parameter a value containing "|" requires Template:!
Sensitive to newlines; since these are automatically stripped from templates and parameters in some cases, special techniques are sometimes needed to avoid this, see Help:Newlines and spaces

XHTML HTML & Wiki-td Wiki-pipe

Pipe syntax in terms of the HTML producedEdit

The pipe syntax, developed by Magnus Manske, substitutes pipes (|) for HTML. There is an on-line script which converts html tables to pipe syntax tables.

The pipes must start at the beginning of a new line, except when separating parameters from content or when using || to separate cells on a single line. The parameters are optional.

TablesEdit

A table is defined by {| ''params'' |} which equals <table ''params''>Insert non-formatted text here </table>

RowsEdit

<tr> tags will be generated automatically for the first row. To start a new row, use

|-

which results in

<tr>

Parameters can be added like this:

|- params

which results in

<tr params>

Note:

<tr> tags will be automatically opened at the first <td> equivalent
<tr> tags will be automatically closed at <tr> and </table> equivalents

CellsEdit

Cells are generated either like this:

|cell1
|cell2
|cell3

or like this:

|cell1||cell2||cell3

which both equal

<td>cell1</td><td>cell2</td><td>cell3</td>

so "||" equals "newline" + "|"

Parameters in cells can be used like this:

|params|cell1||params|cell2||params|cell3

which will result in

<td params>cell1</td>
<td params>cell2</td>
<td params>cell3</td>

HeadersEdit

Functions the same way as TD, except "!" is used instead of the opening "|". "!!" can be used instead of "||". Parameters still use "|", though! Example:

!params|cell1

CaptionsEdit

A <caption> tag is created by

|+ Caption

which generates

<caption>Caption</caption>

You can also use parameters:

|+ params|Caption

which will generate

<caption params>Caption</caption>

Displaying the table code which generates a tableEdit

The code for a simple wiki markup table inside a Code box can be seen below.

{| border="5" cellspacing="10" cellpadding="2"
| style="text-align: center;" | [[Image:gnome-system.png]]
|-
! Computer
|-
| Processor Speed: 1.8 GHz
|}

Above code produces/displays the table below:

Computer

Processor Speed: 1.8 GHz

Below code, generated and displayed the above table's Code box code itself, on the screen and web page, inside a blue colored dashed bordered rectangular box.

<pre>
{| border="5" cellspacing="5" cellpadding="2"
| style="text-align: center;" | [[Image:gnome-system.png]]
|-
! Computer
|-
| Processor Speed: 1.8 GHz
|}
</pre>

Note that, HTML tag <pre> was used to achieve displaying the above codes and the Code box.

Other alternatives to display table codeEdit

In most cases, when a code line is longer than the web browser window's width, then a scrolling bar appears at bottom, to let the viewer slide to the right side (and also left side) to see the rest of the codes, because, the use of <pre> tag causes the code line to remain intact, unless an EOL (CR/LF) hidden character is reached in that text line. But having to slide or scroll to the right or left for viewing the full codes is often not comfortable to many readers. To solve such problem, using the , <tt> and   HTML tags, are better than using the <pre> tag, as those will limit the length of a line of code according the available space in the web browser's window and therefore will not result in the need to move the scroll-bar right (or left) for viewing. By placing the codes inside the <tt>...</tt> HTML tags, codes are displayed with a fixed width text/font, (like the <pre> tag uses) for easier reading. HTML tag   is used to display (or bring) next line of codes, starting from the next line. HTML tag  along with its CSS style properties, is used to create the blue colored dashed bordered rectangular box (Code box) around the codes, (like the HTML <pre> tag, which gets these properties from the main.css stylesheet file).

An example of table code with a long line is:

{| border="5" cellspacing="5" cellpadding="2" | style="text-align: center;" | [[Image:gnome-system.png]] |- ! Computer |- | style="color: yellow; background-color: green;" | Processor Speed: 1.8 GHz |}

producing the below table:

Computer

Processor Speed: 1.8 GHz

Code box above the table has the auto line wrapping feature enabled. Note the long line (the sixth line from top) inside the codes, which is wrapped inside the Code box. This Code box and the codes, can be displayed by using below codes in the edit box.

<tt> <nowiki>{|</nowiki> border="5" cellspacing="5" cellpadding="2" | style="text-align: center;" | <nowiki>[[</nowiki>Image:gnome-system.png]] |- ! Computer |- | style="color: yellow; background-color: green;" | Processor Speed: <nowiki></nowiki> 1.8 GHz <nowiki></nowiki> <nowiki>|}</nowiki> </tt>

See the above codes, note that, <nowiki>...</nowiki> tags were used to disable wiki markup codes for beginning a table ({|), ending a table (|}), start of an image displaying ([[), or a hyperlink, etc. All wiki & HTML markup codes need to be disabled by enclosing them inside the <nowiki>...</nowiki> tags. If these codes were to be displayed inside another table, then, each | (pipe) & ! (Exclamation mark) symbol also needed to be enclosed inside the <nowiki> tags. Note that, the longer line is automatically wrapped according to the width of the web browser's window, inside the Code box.

Alternatively, we can replace each | (pipe symbol) character with | (HTML decimal entity code), replace each ! (exclamation mark) with ! code, replace { (beginning curly/second bracket) with { and we may replace } (closing curly/second bracket) with } code. Also replace the < (less than sign, or beginning angle bracket) with < numeric entity code or, replace it with < (HTML symbol entity code). For more on HTML decimal or hexadecimal numeric entity codes, please see w:Windows Alt codes. To display the wiki image markup code, we should replace the [ (beginning square/third bracket) with [ and we may replace ] (closing square/third bracket) with ]. When we are replacing characters with their numeric enitity codes, we are actually disabling their normal functionality, so we can display them on the web page(s).

By using the numeric entity codes, mentioned in the above paragraph, below codes can display the above Code box in another alternative (better) way. Note that, the longer line is automatically wrapped, without exceeding the browser window's width, inside the below Code box.

Computer

Processor Speed: 1.8 GHz

 <tt> {| border="5" cellspacing="5" cellpadding="2" | style="text-align: center;" | [[Image:gnome-system.png]] |- ! Computer |- | style="color: yellow; background-color: green;" | Processor Speed: 1.8 GHz |} </tt> 

Another alternative is to display the source code within a <source code="html5">...</source> element (with the additional benefit of keeping HTML comments visible, and coloring the HTML compatible syntax, even if the wiki-specific syntax itself is not colorized where it uses specific delimiters, like [paired brackets] for links, {paired braces} for templates transclusion or parameters and tables, pipes between template parameters, pipes and exclamation marks between table cells in the same row, __MAGIC__ keywords, and the specially recognized punctuation at start of lines for lists, indented blocks; preformated text and section headings ; it also preserves source code indentation with whitespaces).

In that case you can easily format the source code for reasonnably short lines, simply by manually inserting newlines and reasonnable indentation, without modifying the source wiki code inserted directly in the source element. Embedding wiki code in a source element is then interesting to use instead of embedding it in a pre element, whose rendering is more difficult to read for complex wiki code. That way the source code will render as follows:

{| border="5" cellspacing="5" cellpadding="2"
| style="text-align: center;" | [[Image:gnome-system.png]]
|-
! Computer
|-
| style="color: yellow; background-color: green;" | Processor Speed: <span
    style="color: white;"> 1.8&nbsp;GHz </span><!-- this is a long wiki code
    line that has been manually wrapped and slightly indented. -->
|}

Note also that HTML named or numeric character entities (such as   or  ) that are present in the embedded source code will not be substituted by the character they represent, but will be rendered verbatim (and colorized specifically).

But note that opening and closing includeonly/noinclude/includeonly tags that are present within the source code embedded in a <source code="html5">...</source> element are still recognized by MediaWiki, and may cause parts of the code not being rendered; the only way to escape these tags is to alter them in the source by inserting some control (such as a zero-width space or word joiner) before or in the middle of their tag name.

Square monitorsEdit

To format for a square monitor or window, use a tape measure. Determine the height of your rectangular screen. Using that figure measure under the screen to determine the width your monitor’s screen would be if it were square. Mark that location using ink or tape under the screen. Drag the side of your browser’s window to that location so the window is square based on accurate measurements. Square monitors and reading windows are not able to contain tables and galleries made for rectangular and wide screens. When a table or gallery is wider than the monitor, it makes every line of text wider than the screen as well. The px amounts of the following gallery were determined after measuring the window to make sure it was square:

Type this:

<center>
{| border="0" style="background:transparent;" 
|-
|
[[Image:Some_window_blinds.JPG|192x155px|thumb|left|Various window shades]]
||
[[Image:Vert-blinds-2145-rs.jpg|192x170px|thumb|left|Vertical blinds]] 
||
[[Image:2008-08-24 Carpet array.jpg|192x155px|thumb|left|This is not a blind]]
|}
</center>

<center>
{| border="0" style="background:transparent;"
|-
|
[[Image:Vorhang.jpg|192x155px|thumb|left|Solid shade]]
||
[[Image:Jalousie-1.jpg|328x155px|thumb|left|Horizonal blinds]]
|}
</center>

<center>
{| border="0" style="background:transparent;"
|-
|
[[Image:Some_window_blinds.JPG|225px|thumb|left|Shade, shutters; vertical & horizontal blinds.]]
||
[[Image:Miniblinds detail of mechanism.jpg|418px|thumb|left|Detail of turning rod (blind stick) attachment on miniblinds]]
|}
</center>

For this:

Various window shades

Vertical blinds

This is not a blind

Solid shade

Horizonal blinds

Shade, shutters; vertical & horizontal blinds.

Detail of turning rod (blind stick) attachment on miniblinds

Viewing tables in email and web pages outside WikipediaEdit

Tables are an essential part of presenting information in an easily understandable way. Everything on Wikipedia can be copied elsewhere, and it is encouraged. But Wikipedia tables oftentimes lose their borders when pasted into web pages, blogs, or email.

The Wikipedia table button produces this:

header 1	header 2	header 3
row 1, cell 1	row 1, cell 2	row 1, cell 3
row 2, cell 1	row 2, cell 2	row 2, cell 3

Note the borders around all the cells, and the whole table. Copy and paste the table into your email, and the borders disappear. This makes the table look something like this below. It is much less understandable.

  header 1      header 2      header 3
row 1, cell 1 row 1, cell 2 row 1, cell 3
row 2, cell 1 row 2, cell 2 row 2, cell 3

This is easily fixed. If you want and expect your table to be passed around in email, blogs, and other web pages, then add

border="1"

somewhere in the first line of your chart wikicode. For example;

{| class="wikitable" border="1"
|-
! header 1
! header 2
! header 3
|-
| row 1, cell 1
| row 1, cell 2
| row 1, cell 3
|-
| row 2, cell 1
| row 2, cell 2
| row 2, cell 3
|}

The table will look the same on the Wikipedia page, but it will now also have borders when copied into email, blogs, and other web pages. Bloggers and webmasters will not have to add CSS code in order to see the chart in a format with basic borders.

External linksEdit

de:Wikipedia:Helferlein/VBA-Macro for EXCEL tableconversion published in German-Wikipediaproject (english instructions included)
HTML tables to wiki converter at cnic.org
csv2wp - converts comma-separated values (CSV) format to pipe syntax. You may use this to import tables from Excel etc. (more information)
pywikipediabot (can convert HTML tables to wiki)
HTML-WikiConverter. Various versions and languages.
csv2other. Takes in input an xls or a csv and outputs a file with wiki table format. Sources available. Still Alfa.

Links to other help pagesEdit

Help contents: Meta · Wikinews · Wikipedia · Wikiquote · Wiktionary · Commons: · Wikidata · MediaWiki · Wikibooks · Wikisource · MediaWiki: Manual · Google
Versions of this help page (for other languages see further): What links here on Meta or from Meta · Wikipedia · MediaWiki
Reading: Go · Search · Stop words · Namespace · Page name · Section · Backlinks · Redirect · Category · Image page · Special pages · Printable version
Tracking changes: Recent changes (enhanced) | Related changes · Watching pages · Diff · Page history · Edit summary · User contributions · Minor edit · Patrolled edit
Logging in and preferences: Logging in · Preferences · User style
Editing: Starting a new page · Advanced editing · Editing FAQ · Edit toolbar · Export · Import · Shortcuts · Edit conflict · Page size
Referencing: Links · URL · Piped links · Interwiki linking · Footnotes
Style and formatting: Wikitext examples · CSS · Reference card · HTML in wikitext · Formula · List · Table · Sorting · Colors · Images and file uploads
Fixing mistakes: Show preview · Testing · Reverting edits
Advanced functioning: Expansion · Template · Advanced templates · Parser function · Parameter default · Variable · System message · Substitution · Array · Calculation · Embed page
Others: Special characters · Renaming (moving) a page · Preparing a page for translation · Talk page · Signatures · Sandbox · Legal issues for editors

Languages:	English · العربية · български · dansk · Deutsch · Esperanto · español · euskara · suomi · français · galego · italiano · 日本語 · Nederlands · polski · русский · shqip · Tiếng Việt · 中文

Meta ^β

Help:Table

Spreadsheet to wiki table formatEdit

Using the toolbarEdit

Pipe syntax tutorialEdit

ExamplesEdit

Simple exampleEdit

Multiplication tableEdit

Color; scope of parametersEdit

Width, heightEdit

Setting your column widthsEdit

Vertical alignmentEdit

PositioningEdit

MélangeEdit

Floating tableEdit

Non-floating tablesEdit

Nested tablesEdit

Combined use of COLSPAN and ROWSPANEdit

Centering tablesEdit

Setting parametersEdit

Decimal point alignmentEdit

Style classesEdit

SortingEdit

Sortable except final rowEdit

Row templateEdit

Producing table syntax using templates and/or parser functionsEdit

Other table syntaxEdit

Pipe syntax in terms of the HTML producedEdit

TablesEdit

RowsEdit

CellsEdit

HeadersEdit

CaptionsEdit

Displaying the table code which generates a tableEdit

Other alternatives to display table codeEdit

Square monitorsEdit

Viewing tables in email and web pages outside WikipediaEdit

See alsoEdit

External linksEdit

Links to other help pagesEdit

Name	Effect	Games Found In
Poké Ball	Regular Poké Ball	All Versions
Great Ball	Better than a Poké Ball	All Versions

This column is 100 points wide	This column is 200 points wide	This column is 300 points wide
blah	blah	blah

Row heading	A longer piece of text. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.	A shorter piece of text.
Row heading	A longer piece of text.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.	A shorter piece of text.

Col 1, row 1	Col 2, row 1 (and 2)	Col 3, row 1
Col 1, row 2	Col 2, row 1 (and 2)	Col 3, row 2

Duis	aute	irure
dolor	in reprehenderit	in voluptate velit
esse cillum dolore	eu fugiat nulla	pariatur.

Alphabetic	Numeric	Date	Unsortable
d	2	2008-11-24	This
b	8	2004-03-01	column
a	6	1979-07-23	cannot
c	4	1492-12-08	be
e	0	1601-08-13	sorted.

Meta β

Help:Table

Spreadsheet to wiki table formatEdit

Using the toolbarEdit

Pipe syntax tutorialEdit

ExamplesEdit

Simple exampleEdit

Multiplication tableEdit

Color; scope of parametersEdit

Width, heightEdit

Setting your column widthsEdit

Vertical alignmentEdit

PositioningEdit

MélangeEdit

Floating tableEdit

Non-floating tablesEdit

Nested tablesEdit

Combined use of COLSPAN and ROWSPANEdit

Centering tablesEdit

Setting parametersEdit

Decimal point alignmentEdit

Style classesEdit

SortingEdit

Sortable except final rowEdit

Row templateEdit

Producing table syntax using templates and/or parser functionsEdit

Other table syntaxEdit

Pipe syntax in terms of the HTML producedEdit

TablesEdit

RowsEdit

CellsEdit

HeadersEdit

CaptionsEdit

Displaying the table code which generates a tableEdit

Other alternatives to display table codeEdit

Square monitorsEdit

Viewing tables in email and web pages outside WikipediaEdit

See alsoEdit

External linksEdit

Links to other help pagesEdit

Meta ^β