Search results
Results from the WOW.Com Content Network
Copy the table to a wiki sandbox. In Calc select the table. Copy directly from it, and then paste into the visual editor, or if that does not work, into a blank visual editor table where the first header cell has been selected. It may take up to a minute. If there is a problem, then paste into Excel2Wiki first, and copy the wikitext.
To transpose the table with a third-party spreadsheet program, copy the published table on the Wikipedia page and paste it into a new blank document in your spreadsheet program. While the pasted cells are still selected in the spreadsheet, copy them again by right-clicking and choosing "Copy" from the context menu.
Type the codes for each table cell in the next row, starting with a bar: {| |+ The table's caption |- | cell code goes here |- | next row cell code goes here | next cell code goes here |} Cells can be separated with either a new line and a single bar, or by a double bar "||" on the same line. Both produce the same output:
In the current version the export format does not contain an XML replacement of wiki markup (see Wikipedia DTD for an older proposal, or Wiki Markup Language). You only get the wikitext as you get when editing the article. (After export you can use alternative parsers to convert wikitext to other format)
Required for accessibility purposes on data tables, and placed only between the table start and the first table row. ! header cell Optional. Each header cell starts with a new line and a single exclamation mark (!), or several header cells can be placed consecutively on the same line, separated by double exclamation marks (!!). |-new row
Copy the wiki code from the text file. You can save any web page as an HTML file, and then open it in LibreOffice Writer. Edit as needed. Remove the parts you don't want. Keep only tables for example. Then export to MediaWiki. Tables can be further edited in LibreOffice Calc. See: Commons:Convert tables and charts to wiki code or image files.
To add a new, blank table, go to the Insert menu and select the "Table" option. Once you've chosen the number of rows and columns, it will be inserted into the article so that you can add in the contents for each cell. Pressing Tab ↹ will select the cell to the right. Pressing ↵ Enter will select the cell below.
Lists and tables are two different ways to format multiple, similar items on a page. Lists and HTML tables go back to Wikipedia's early days. The current wikicode tables (see the section about tables), which you can edit more easily and even sort, came later. You'll find many more lists than tables on Wikipedia.