Search results
Results from the WOW.Com Content Network
Wiki pages can be exported in a special XML format to import into another MediaWiki installation or use it elsewise for instance for analysing the content. See also m:Syndication feeds for exporting all other information except pages, and see Help:Import on importing pages.
For simple tables, this can be done via the "transpose rows and columns" function of Copy & Paste Excel-to-Wiki, or via the "transpose" feature of a third-party spreadsheet program such as Microsoft Excel, the free web-based Google Sheets, or the free downloadable software LibreOffice Calc.
Download the Excel file. Open it in freeware LibreOffice Calc or another spreadsheet program. 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.
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.
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.
Wikipedia preprocessor (wikiprep.pl) is a Perl script that preprocesses raw XML dumps and builds link tables, category hierarchies, collects anchor text for each article etc. Wikipedia SQL dump parser is a .NET library to read MySQL dumps without the need to use MySQL database
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.
Insert a table of information Alternatively, you can copy the cells of any spreadsheet (e.g. Excel) and paste them into the editing area. Similarly, you can import an entire existing table by dragging a comma-separated value ( .csv ) file from your computer into the editing window.