View source for Help:Table

{{Stack begin}}[[File:Enhanced editor table dialog box.png|400px|thumbnail|right|Tool for starting a table in enhanced editor]]{{Stack mid}}
{{Help Box}}{{Stack end}}
A '''table''' is an arrangement of columns and rows that organizes and positions data. Tables in [[Saintapedia]] can be created easily using the [[Help:Enhanced editor|Enhanced editor]] (see image to the right).  As a general rule, it is best to avoid using a table unless you need one. Table markup often complicates page editing.

Tables can be edited with either editor:
* It is recommended to use [[Visual editor]] when modifying tables.  See [[Help:Visual editor#Tables]] for more details
* To make changes using the [[Enhanced editor]], see the steps in the Enhanced editor sections below.

Wikipedia has {{W|Help:Introduction to tables with Wiki Markup/1|Introduction to tables}} is a good guide to getting started with tables and their comprehensive {{W|Help:Table}} has an expanded list of functionality table options.  The [[Excel converter]] is useful in bringing in non-sensitive content in from [[Microsoft Excel]].

== Visual editor ==
This information is being shown from [[Help:Visual editor#Tables]].
{{#lsth:Help:Visual editor|Tables}}

== Enhanced editor ==

===Standard table format===
To create a table manually, copy the following wikitext to your page:

{| 
|- valign="top"
|
 <nowiki>{|class="wikitable"</nowiki>
 <nowiki>|+ Title</nowiki>
 <nowiki>! Column 1 header</nowiki>
 <nowiki>! Column 2 header</nowiki>
 <nowiki>|- </nowiki>
 <nowiki>| a </nowiki>
 <nowiki>| b </nowiki>
 <nowiki>|-</nowiki>
 <nowiki>| c </nowiki>
 <nowiki>| d</nowiki>
 <nowiki>|}</nowiki>
| width="30px" |
|

{| class="wikitable"
|+ Title
! Column 1 header
! Column 2 header
|- 
| a 
| b 
|-
| c 
| d
|}
|}

=== Wiki table summary ===
{| class="wikitable" width="60%"
| style="padding: 10px;" | <big><nowiki>{|</nowiki></big>
| style="padding: 5px;" | '''table start'''
|-
| style="padding: 10px;" | <big><nowiki>|+</nowiki></big>
| style="padding: 5px;" | table '''caption,''' ''optional;'' only between '''table start''' and first '''table row'''
|-
| style="padding: 10px;" | <big><nowiki>|-</nowiki></big>
| style="padding: 5px;" | '''table row,''' ''optional on first row'' -- wiki engine assumes the first row
|-
| style="padding: 10px;" | <big><nowiki>!</nowiki></big> 
| style="padding: 5px;" | '''table header''' cell, ''optional.'' Consecutive '''table header''' cells may be added on same line separated by double marks (<code>!!</code>) or start on new lines, each with its own single mark (<code>!</code>).
|- 
| style="padding: 10px;" | <big><nowiki>|</nowiki></big>
| style="padding: 5px;" | '''table data''' cell, ''required!'' Consecutive '''table data''' cells may be added on same line separated by double marks (<code><nowiki>||</nowiki></code>) or start on new lines, each with its own single mark (<code><nowiki>|</nowiki></code>).
|-
| style="padding: 10px;" | <big><nowiki>|}</nowiki></big>
| style="padding: 5px;" | '''table end''' 
|}

===Basic table===

{| class="wikitable"
|+ <this row is used for a title>
! <column header 1>
! <column header 2>
|- <this is used as a row break >
| <row 1, column 1 info>
| <row 1, column 2 info>
|-
| <row 2, column 1 info>
| <row 2, column 2 info>
|} 

'''Copy the text below to create this table:'''

{|
|-
|
<pre>
{| class=wikitable
|+ <this row is used for a title>
! <column header 1>
! <column header 2>
|- <this is used as a row break>
| <row 1, column 1 info>
| <row 1, column 2 info>
|-
| <row 2, column 1 info>
| <row 2, column 2 info>
|} 
</pre>
|}

=== Expanding tables - Adding rows and columns ===
It's common to to want to edit an existing table by adding just one extra column or row of information.  
=== Adding a row ===
To add an extra row into a table, you'll need to insert an extra row break and the same number of new cells as are in the other rows.

The easiest way to do this in practice, is to duplicate an existing row by copy-pasting the wikitext. It's then just a matter of editing the cell contents.

{| style="width:100%"
! style="width: 50%;" |
You type
! style="width: 50%;" |
You get
|-
| style="padding: 5px;" |
<pre>
{| class=wikitable
|+ Basic table from above
! <column header 1>
! <column header 2>
|- <this is used as a row break>
| <row 1, column 1 info>
| <row 1, column 2 info>
|-
| <row 2, column 1 info>
| <row 2, column 2 info>
|} 
</pre>
| style="padding: 5px;" |
{| class="wikitable"
|+ Basic table from above
! <column header 1>
! <column header 2>
|- <this is used as a row break >
| <row 1, column 1 info>
| <row 1, column 2 info>
|-
| <row 2, column 1 info>
| <row 2, column 2 info>
|} 
|}

{| style="width:100%"
! style="width: 50%;" |
You type
! style="width: 50%;" |
You get
|-
| style="padding: 5px;" |
<pre>
{| class=wikitable
|+ Basic table with third row
! <column header 1>
! <column header 2>
|- <this is used as a row break>
| <row 1, column 1 info>
| <row 1, column 2 info>
|-
| <row 2, column 1 info>
| <row 2, column 2 info>
|-
| <row 3, column 1 info>
| <row 3, column 2 info>
|}
</pre>
| style="padding: 5px;" |
{| class="wikitable"
|+ Basic table with third row
! <column header 1>
! <column header 2>
|- <this is used as a row break >
| <row 1, column 1 info>
| <row 1, column 2 info>
|-
| <row 2, column 1 info>
| <row 2, column 2 info>
|-
| <row 3, column 1 info>
| <row 3, column 2 info>
|}
|}

==== Adding a column ====
To add an extra column to a table, you'll need to add a single extra cell in the same position to each row.  If the table has a heading, don't forget to add it as well.

{| style="width:100%"
! style="width: 50%;" |
You type
! style="width: 50%;" |
You get
|-
| style="padding: 5px;" |
<pre>
{| class=wikitable
|+ Basic table from above
! <column header 1>
! <column header 2>
|- <this is used as a row break>
| <row 1, column 1 info>
| <row 1, column 2 info>
|-
| <row 2, column 1 info>
| <row 2, column 2 info>
|} 
</pre>
| style="padding: 5px;" |
{| class="wikitable"
|+ Basic table from above
! <column header 1>
! <column header 2>
|- <this is used as a row break >
| <row 1, column 1 info>
| <row 1, column 2 info>
|-
| <row 2, column 1 info>
| <row 2, column 2 info>
|} 
|}

{| style="width:100%"
! style="width: 50%;" |
You type
! style="width: 50%;" |
You get
|-
| style="padding: 5px;" |
<pre>
{| class=wikitable
|+ Basic table with third column
! <column header 1>
! <column header 2>
! <column header 3>
|- <this is used as a row break>
| <row 1, column 1 info>
| <row 1, column 2 info>
| <row 1, column 3 info>
|-
| <row 2, column 1 info>
| <row 2, column 2 info>
| <row 2, column 3 info>
|}
</pre>
| style="padding: 5px;" |
{| class="wikitable"
|+ Basic table with third column
! <column header 1>
! <column header 2>
! <column header 3>
|- <this is used as a row break >
| <row 1, column 1 info>
| <row 1, column 2 info>
| <row 1, column 3 info>
|-
| <row 2, column 1 info>
| <row 2, column 2 info>
| <row 2, column 3 info>
|}
|}

===HTML colspan and rowspan===

You can use HTML '''colspan''' and '''rowspan''' attributes on cells for advanced layout.

{| 
! style="width: 50%;" | You type
! style="width: 50%;" | You get
|- valign="top"
| style="padding: 5px;" |
<pre>{| class="wikitable" 
|-
  ! colspan="6" | Shopping List
|-
  | rowspan="2" | Bread & Butter
  | Pie
  | Buns
  | Danish
  | colspan="2" | Croissant
|-
  | Cheese
  | colspan="2" | Ice cream
  | Butter
  | Yogurt
|}</pre>
| style="padding: 5px;" |
{| class="wikitable" 
|-
  ! colspan="6" | Shopping List
|-
  | rowspan="2" | Bread & Butter
  | Pie
  | Buns
  | Danish
  | colspan="2" | Croissant
|-
  | Cheese
  | colspan="2" | Ice cream
  | Butter
  | Yogurt
|}
|}

== class="wikitable" == 
By adding <code>class="wikitable"</code> the table gets basic styling (light gray background, borders, padding and align left).

{|
|- 
! colspan="2" | Without wikitable formatting
! width="20em" |
! colspan="2" | With wikitable formatting
|-
! You type:
! You get:
! 
! You type:
! You get:
|- valign="top"
| style="padding: 5px;" |
<pre>
{|
|+ Food complements
|-
  | Orange
  | Apple
|-
  | Bread
  | Pie
|-
  | Butter
  | Ice cream
|}</pre>
| style="padding: 5px;" |
{|
|+ Food complements
|-
  | Orange
  | Apple
|-
  | Bread
  | Pie
|-
  | Butter
  | Ice cream
|}
|
| style="padding: 5px;" |
<pre>
{| class="wikitable"
|+ Food complements
|-
  | Orange
  | Apple
|-
  | Bread
  | Pie
|-
  | Butter
  | Ice cream
|}
</pre>
| style="padding: 5px;" |
{| class="wikitable"
|+ Food complements
|-
  | Orange
  | Apple
|-
  | Bread
  | Pie
|-
  | Butter
  | Ice cream
|}
|}

==Sortable table==
{| class="sortable" width="300px" border="4" align="center"
|+ Centered Table that is sortable
! Column 1
! Column 2
|-
| 44 || Joe
|- 
| 10 || Jack
|-
| 11 || Sally
|}

'''Copy the text below to create this table:''' 

{|
|- valign="top"
|
 <nowiki>{| class="sortable" width="300px" border="4" align="center"</nowiki>
 <nowiki>|+ Centered Table that is sortable</nowiki>
 <nowiki>! Column 1</nowiki>
 <nowiki>! Column 2</nowiki>
 <nowiki>|-</nowiki>
 <nowiki>| 44 || Joe</nowiki>
 <nowiki>|- </nowiki>
 <nowiki>| 10 || Jack</nowiki>
 <nowiki>|-</nowiki>
 <nowiki>| 11 || Sally</nowiki>
 <nowiki>|}</nowiki>
| width="100%" |
|}

Note that you can specify entries for more than one column in a single line by separating the entries with two vertical pipe (||) characters, as in the example above.

===Secondary sortkey===
{{Nutshell|It is possible to sort by one column and then a second column by holding down the {{Keypress|shift}}-key when clicking on the 2nd column.}}

It is possible to sort by column A (primary sortkey), while for equal values in column A, sort by column B (secondary sortkey): first sort by A by clicking the sort button of column A once or twice, then, while holding the shift-key, click the sort button of column B once or twice.

Example:

First click on column Text and then, while holding the {{Keypress|shift}}-key, on Numbers, you'll see that the ordering is on Text (1), Numbers (2).

{| class="wikitable sortable"
!Numbers!!Text!!Dates!!Currency!!More text
|-
|4||a||01.Jan.2005||4.20||row 1
|-
|5||a||05/12/2006||7.15||row 2
|-
|1||b||02-02-2004||5.00||row 3
|-
|1||a||02-02-2004||5.00||row 4
|-
|2||x||13-apr-2005||||row 5
|-
|2||a||13-apr-2005||||row 6
|-
|3||a||17.aug.2006||6.50||row 7
|-
|3||z||25.aug.2006||2.30||row 8
|-
|3||z||28.aug.2006||5.50||row 9
|-
|3||z||31.aug.2006||3.77||row 10
|-
|3||z||01.sep.2006||1.50||row 11
|-
!Bottom!!!!!!!!
|-
|}

== Advanced formatting ==
In general, it is recommended that tables simply use Wikipedia's default formatting. In some circumstances, however, you may need to apply some more complicated formatting using HTML. The appearance of each cell can be controlled by adding <code><nowiki>style=" " |</nowiki></code> before the cell's contents. HTML formatting is added to headings and captions in the same way.

Any HTML attributes can be added in the <code><nowiki>style=" " |</nowiki></code>. 

{{col-begin}}
{{col-break|width=49%}}
====For cell contents====
<pre>
| style="" | R1C1
| style="" | R1C2
| style="" | R1C3
</pre>

{{col-break|width=2%}}
{{col-break|width=49%}}
====For headings====
<pre>
! style="" | Header C1
! style="" | Header C2
! style="" | Header C3
</pre>

{{col-end}}

{| class="wikitable"
|+ Most commonly used attributes
! Property
! Meaning
! Example
|-
! background   
| back ground fill || <code>background:yellow</code>
|-
! color        
| text colour || <code>color:blue</code>
|-
! width        
| cell width || <code>width:100px</code>
|-
! border-width 
| border width || <code>border-width:3px</code>
|-
! text-align   
| Text alignment within cell || <code>text-align:center</code>
|}

As an example, here's an example with some varied formatting added to specific cells

<pre style="width:70%">
{| class="wikitable"
|+ Caption: some cells yellow.
|-
! Header1
! Header2
! Header3
|-
| style="background: yellow" | R1C1
| R1C2
| style="background: yellow" | R1C3
|-
| R2C1
| style="background: yellow" | R2C2
| R2C3
|}
</pre>

Then it would produce this:

{| class="wikitable"
|+ Caption: some cells yellow.
|-
! Header1
! Header2
! Header3
|-
| style="background: yellow" | R1C1
| R1C2
| style="background: yellow" | R1C3
|-
| R2C1
| style="background: yellow" | R2C2
| R2C3
|}

HTML attributes can be added to the whole table by editing the first line of the table using <code><nowiki>{| style=" "</nowiki></code> in the first line. Similarly, attributes can be added to a row using <code><nowiki>|- style=" "</nowiki></code> The example below would fill the ''whole'' table yellow.

<pre style="width:70%">
{| class="wikitable" style="background: yellow"
</pre>

All of these formatting options should be used sparingly. Tables in crazy colors are hard to read and affect the [[Accessibility]] of the Saintapedia page.

===Hidden comments===

In complicated tables, sometimes hidden comments can be useful to explain formatting. These hidden comments are only visible when editing the page, not when reading it normally. Comments can be added by placing them between <code><nowiki><!--</nowiki></code> and <code><nowiki>--></nowiki></code>.

<code><nowiki>| R1C1 || R1C2 ||R1C3 <!-- Hidden comment to explain this row --></nowiki></code>

<nowiki>}}</nowiki>

=== Alignment ===
==== Horizontal ====
There are three variations of horizontal alignment:

Left aligned (default):
<pre>style="text-align: left;"</pre>

Center aligned:
<pre>style="text-align: center;"</pre>

Right aligned:
<pre>style="text-align: right;"</pre>

==== Vertical ====
There are three variations of vertical alignment:

Top alignment (default):
<pre>style="vertical-align: top;"</pre>

Middle alignment:
<pre>style="vertical-align: middle;"</pre>

Bottom alignment:
<pre>style="vertical-align: bottom;"</pre>

==== Example of both ====

<pre>
{| class="wikitable" style="width: 60%;"
|-
| style="text-align: left;" | Left aligned (default) 
| style="text-align: center;" | Center aligned
| style="text-align: right;" | Right aligned
|-
| style="vertical-align: top;" | A longer piece of text with top alignment. 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.
| style="vertical-align: middle;" | Middle alignment
| style="vertical-align: bottom;" | Bottom alignment
|}
</pre>

{| class="wikitable" style="width: 60%;"
|-
| style="text-align: left;" | Left aligned (default) 
| style="text-align: center;" | Center aligned
| style="text-align: right;" | Right aligned
|-
| style="vertical-align: top; width: 60%;" | A longer piece of text with top alignment. 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.
| style="vertical-align: middle;" | Middle alignment
| style="vertical-align: bottom;" | Bottom alignment
|}

=== Centering tables ===
<code>align="center"</code> is [[Wikipedia:HTML 5|deprecated in HTML5]], and does not work well in Mediawiki software. For example; it will not override the left alignment of tables via <code>class=wikitable</code>.

Centered tables can be achieved, but they don't "float"; that is to say, no text appears to either side. The trick is<br>
<code><nowiki>{| style="margin-left: auto; margin-right: auto; border: none;"</nowiki></code>
<ref group=note>''border: none;'' avoids an unsightly empty column in tables narrower than the browser window on Android Chrome.</ref>

<div style="border: 2px solid lime; padding: 2px;">
'''Wiki text'''
<syntaxhighlight lang="wikitext">
Text before table...
{| class="wikitable" style="margin-left: auto; margin-right: auto; border: none;"
|+ Cells left-aligned, table centered
|-
! scope="col" | Duis
! scope="col" | aute
! scope="col" | irure
|-
| dolor || in reprehenderit || in voluptate velit
|-
| esse cillum dolore || eu fugiat nulla || pariatur.
|}
...text after table
</syntaxhighlight>
</div>

As it appears in a browser:
<div style="border: 2px solid lime; padding: 2px;">
Text before table...
{| class="wikitable" style="margin-left: auto; margin-right: auto; border: none;"
|+ Cells left-aligned, table centered
|-
! scope="col" | Duis
! scope="col" | aute
! scope="col" | irure
|-
| dolor || in reprehenderit || in voluptate velit
|-
| esse cillum dolore || eu fugiat nulla || pariatur.
|}
...text after table.
</div>

==Making a collapsible table==
Use the "mw-collapsible" class command. There must be a header row. The following is the simplest possible table with one header and one data row. 

{|
|- valign="top"
|
 <nowiki>{|class="mw-collapsible"</nowiki>
 <nowiki>!Header</nowiki>
 <nowiki>|-</nowiki>
 <nowiki>|test</nowiki>
 <nowiki>|}</nowiki>
| width="30px" |
|

{| class="mw-collapsible"
!Header
|-
|test
|}
|}

===Advanced nesting of tables can create collapsible lists===
{|
|- valign="top"
|
<pre>
{|
|- valign=top
|

{|class="mw-collapsible mw-collapsed wikitable" width=200px 
!Courses
|-
|Science
|-
|Technology
|-
|Engineering
|-
|Math
|}

|

{|class="mw-collapsible wikitable" width=200px
!Institution
|-
|
Northern University of the Arts

Eastern Medical University

Southern Junior College
|}

|

{|class="mw-collapsible mw-collapsed wikitable" width=200px
!About us
|-
|
* History
* Staff
* Organization charts
|}

|

{|class="mw-collapsible wikitable" width=200px
!Contact Us
|-
|
President<br />
Vice President<br />
Treasurer<br />
|}

|}
</pre>

| width="30px" |
| 

{|
|- valign="top"
|

{| class="mw-collapsible mw-collapsed wikitable" width="200px" 
!Courses
|-
|Science
|-
|Technology
|-
|Engineering
|-
|Math
|}

|

{| class="mw-collapsible wikitable" width="200px"
!Institution
|-
|
Northern University of the Arts

Eastern Medical University

Southern Junior College
|}

|

{| class="mw-collapsible mw-collapsed wikitable" width="200px"
!About us
|-
|
* History
* Staff
* Organization charts
|}

|

{| class="mw-collapsible wikitable" width="200px"
!Contact Us
|-
|
President<br />
Vice President<br />
Treasurer<br />
|}

|}
|}

== Color templates ==
There is a series of colors that can be added to a table with whatever text you desire.  The [[Help:Enhanced editor|Enhanced editor]] needs to be used to add these template.  Please always consider [[Saintapedia:Accessibility]] when using colors.  See {{W|article=Template:Yes}} for even more color options.

=== Green, yellow, and red ===

==== Templates used ====
{| class="wikitable"
! Name !! Description !! Example || Code
|- 
| Yes || The [[Template:Yes|Yes]] [[template]] has a light green background. || {{yes|Required}} ||{{tlx|yes|Required}}
|-
| Partial || The [[Template:Partial|Partial]] template has a yellow background. || {{partial|Recommended}} ||{{tlx|partial|Recommended}}
|-
| Okay || The [[Template:Okay|Okay]] template  has a light yellow background. || {{Okay|Optional}} ||{{tlx|Okay|Optional}}
|-
| No2 || The [[Template:No2|No2]] template has a light pink background. || {{no2|Not Recommended}}  ||{{tlx|no2|Not Recommended}}
|- 
| No || The [[Template:No|No]] template has a light red background. || {{no|Must Not Implement}} ||{{tlx|no|Must Not Implement}}
|}

====Templates used together====
{| class="wikitable"
|-
!Field
!Option 1
!Option 2
|-
|1|| {{no|Must Not Implement}} || {{no|Must Not Implement}}
|-
| 3|| {{no|Must Not Implement}} || {{no|Must Not Implement}}
|-
|5|| {{no2|Not Recommended}}   || {{yes|Required}}
|-
| 6|| {{no|Must Not Implement}} || {{no|Must Not Implement}}
|-
|7|| {{no2|Not Recommended}}   || {{yes|Required}}
|-
|8|| {{yes|Required}}          || {{yes|Required}}
|-
|10|| {{no2|Not Recommended}}   || {{yes|Required}}
|-
|12 || {{no|Must Not Implement}} || {{Okay|Optional}}
|-
| 13|| {{yes|Required}}          || {{yes|Required}}
|-
|14|| {{Okay|Optional}}         || {{partial|Recommended}}
|-
| 15|| {{partial|Recommended}}   || {{partial|Recommended}}
|-
|16 || {{Okay|Optional}}         || {{partial|Recommended}}
|}

=== Blue and white family ===
==== Blue and white templates ====
{| class="wikitable"
! Name !! Description !! Example || Code
|- 
| Blue white cell || The [[Template:Blue white cell|Blue white cell]] [[template]] has a dark blue background with white text.|| {{Blue white cell|Dark blue}} ||{{tlx|Blue white cell|Dark blue}}
|-
| Blue cell || The [[Template:Blue cell|Blue cell]] [[template]] has a light blue background.|| {{Blue cell|Light blue}} ||{{tlx|Blue cell|Light blue}}
|}

====Blue and white example====
{| class="wikitable"
|-
!{{Blue white cell|Field}}
!{{Blue white cell|Option 1}}
!{{Blue white cell|Option 2}}
|-
|{{Blue cell|1}}|| {{Blue cell|Must Not Implement}} || {{Blue cell|Must Not Implement}}
|-
| 3|| Must Not Implement || Must Not Implement
|-
|{{Blue cell|5}}|| {{Blue cell|Not Recommended}}   || {{Blue cell|Required}}
|-
| 6|| Must Not Implement || Must Not Implement
|-
|{{Blue cell|7}}|| {{Blue cell|Not Recommended}}   || {{Blue cell|Required}}
|-
|8|| Required          || Required
|-
|{{Blue cell|10}}|| {{Blue cell|Not Recommended}}   || {{Blue cell|Required}}
|-
|12 || Must Not Implement || Optional
|}

== Importing and exporting tables==
=== Wiki table editor ===
At http://wikitable.eu5.org/, there is a wiki table editor where you can paste your table code into the box at the top, and see the results underneath, and then you can click in any of the cells in the table underneath to edit the contents of those cells, and the changes will be reflected in your code at the top. When you are done, you can copy the code from the top back into Saintapedia. 

Notes: 
* Table coding is reformatted
** Cell content lines (starting with {{code|{{!}}}}) are indented underneath the new row {{code|{{!}}-}} lines
** Where multiple cells are specified on the same line (separated by {{code|{{!}}{{!}}}}), they will be moved to separate lines
* A new row {{code|{{!}}-}} line is '''''required''''' before the first row in the table, even though it is optional in Saintapedia 
** If the initial new row line is missing, the contents of the first row will generally be lost when the wiki table editor reformats the code
* The site does not understand table caption {{code|{{!}}+}} lines

=== Exporting to Microsoft Office ===
Wiki tables can be exported to Microsoft Word and Excel by direct cutting-and-pasting. 
* [[External hyperlinks]] will be preserved
* [[Internal hyperlinks]] (to Saintapedia) will also be preserved. To remove them, see [http://office.microsoft.com/en-us/excel-help/remove-a-hyperlink-HP005199697.aspx this guidance from Microsoft].

=== Importing from Microsoft Excel ===
It is possible to import a table from [[Microsoft Excel]] using the [http://excel2wiki.net/ Copy and Paste Excel-to-Wiki Converter]. This simple tool to converts excel information to wiki text. Once you copy the wiki text from the tool, you can paste it into Saintapedia in edit mode. Some formatting may need to be done after the conversion.

== External Links ==
* [http://excel2wiki.net/ Copy and Paste Excel-to-Wiki Converter]
* [http://www.tablesgenerator.com/mediawiki_tables MediaWiki Tables Generator]

=== Advanced table formatting ===
* {{W|Help:Tables|Wikipedia's Tables page}}
* {{Mw|Table|MediaWiki's Table page}}

== References ==
[[Category:Help]][[Category:Help under review]]
<references group="note" />{{Purge box}}