Difference between revisions of "ExcelConversion"
Jump to navigation
Jump to search
Line 20: | Line 20: | ||
{| {{table}} | {| {{table}} | ||
− | |||
| 1||34 | | 1||34 | ||
− | |||
|- | |- | ||
− | |||
| 2||36 | | 2||36 | ||
− | |||
|- | |- | ||
− | |||
| 4||41 | | 4||41 | ||
− | |||
|- | |- | ||
− | |||
| | | | ||
− | |||
|} | |} | ||
</PRE> | </PRE> |
Latest revision as of 13:16, 30 July 2017
Editing: | • | Help | • | Sandboxes | • | Guidelines | • | Excel Conversion | • | Maps | • | Reference | • | Templates |
Converting Excel Spreadsheets to Wikitext
Tables can be a bit fiddly to edit.
If you already have the table in Excel you can convert it to wikitext using the web page at http://184.105.142.24/cgi-bin/excel2wiki.php
You
- select the cells that you want to use in Excel - left-click on the top-left cell and (without releasing the button) drag the mouse pointer down to the bottom-right cell
- 'copy' the selected cells either (a) hit Cntrl-C or (b) select Edit ... Copy
- goto http://184.105.142.24/cgi-bin/excel2wiki.php in your web browser
- click in the white text box box and paste your data - either (a) hit Cntrl-V or (b) select Edit ... Paste
- un-select the 'header format' box
- click the 'Submit Query' button
The page will change to show some 'wikitext' below the word 'result' i.e. you will get something like this
result {| {{table}} | 1||34 |- | 2||36 |- | 4||41 |- | |}
You
- then select all this text - from the first '{|' down to the last '|}' - but not including the word 'result'.
- copy it (Cntrl-C or Edit ... Copy).
- then go to the wiki page you want to put it in
- select edit
- put the cursor where you want the table to go
- paste it in (Cntl-V or Edit ... Paste)
- click "Save Page"
If the header of the table looks strange (yellow text on a white background) - you probably forgot to un-select the 'header format' box in step 5 above.
CSV2WP
There is another converter available at http://area23.brightbyte.de/csv2wp.php - I've not yet tried this myself.