Search results
Results From The WOW.Com Content Network
Currently, there does not seem to be a way to copy those tables to a wiki and keep styling such as colors (background or text color). It is possible to convert PDF tables to Excel and keep the colors. Or to HTML tables and keep the colors. But there does not seem to be a way to copy any of those colored tables (PDF, Excel, HTML, etc.) to a wiki.
There are several advanced table formatting techniques to improve the display or editing of wikitables in Wikipedia. Most of the tips involve use of standard text-editors. While some special software packages exist, to allow customized editing, they are typically not available when travelling to other computers for wiki-editin
Category:Wikipedia tables: lists even more table help pages. Help:Introduction to tables with Wiki Markup. Wikipedia:Manual of Style/Tables: the Manual of Style indicates best practices for tables. Wikipedia:Table dos and don'ts: a quick guide to the Manual of Style for tables. mw:Help:Tables; User:Dcljr/Tables: table tutorials.
A very simple Copy & Paste Excel-to-Wiki Converter; A free open source tool to convert from CSV and Excel files to wiki table format: csv2other; Spreadsheet-to-MediaWiki-table-Converter This class constructs a MediaWiki-format table from an Excel/GoogleDoc copy & paste. It provides a variety of methods to modify the style.
To re-arrange the table using pivot tables, copy and paste the table into a spreadsheet program such as freeware LibreOffice Calc. In LibreOffice Calc, first make sure the headers are in the top row, and that they are not sticky (frozen). Then select all from the view menu. Then click on the "Pivot Table" command from the Insert menu.
MediaWiki Table Utility or this updated version This class constructs a MediaWiki-format table from an Excel/GoogleDoc copy&paste. It provides a variety of methods to modify the style. It provides a variety of methods to modify the style.
Wikipedia:Manual of Style/Tables, the Manual of Style for best practices for tables Wikipedia:Table dos and don'ts, a quick guide to the Manual of Style for tables; Wikipedia:Advanced table formatting, some advanced techniques
If you just want one table from a long Excel page, you can select that table from the Calc page. Then copy the table to a new page in Calc. Edit and move columns and rows in Calc. To drag a column first select it by clicking its header number. Then press and hold the ALT key. Then click a data cell, and drag the column to a new location.