User:Ccsmith/sandbox/wiki2

Creating tables in the Wiki can be a little confusing to patrons. Some find the coding a bit strange and difficult to work with. However, if you are comfortable with spreadsheets such as Excel, you could create your tables in Excel and then import them into the Wiki. In addition, there may already exist a spreadsheet that you want to place in an article. In either case, here is how to place a spreadsheet in to the Wiki

How to copy a spreadsheet table into the Wiki

 * 1) Open the spreadsheet.
 * 2) Resave the spreadsheet with a csv extention. It would be better to save under a different name as well so you don't think it the regular spreadsheet coding.
 * 3) Highlight the cells you want to import and copy with the right click of the mouse or CTRL+C.
 * 4) Open the website, CSV to Wikitext Converter.
 * 5) Paste the data you copied into the left box. The cvs program will automatically convert the file to wikitext coding in the right box.
 * 6) Highlight the coding in the right box and save.
 * 7) Open the Wiki and click "Edit source" on the page where you want to place the table and paste it to the location on the page where you want it. Be ware you cannot use the Visual Editor to paste this coding.

7. If your table has a row of titles at the top, click on the box located at the top of the webpage, "The first row is the header"

8. On the left side of page, click in the box so the cursor shows. Then paste the information you copied from the CSV spreadsheet by doing a right-click on the mouse and chosing paste. (You can also hold down the "Ctrl" key and the "V" key once to paste the information.)  Note: Sometimes it takes several tries before it recognizes your cursor to paste your information. Just keep playing with it.



9. Information you will need to paste into the Wiki should automatically appear in the right box. If it doesn't, try pressing "enter".

10. A preview of your table will appear below the two boxes. You can ignore this information.

11. Copy the wikitext found in the right box by double clicking on the box, then hold down the "Ctrl" key and the "C" key once. (Or, left-click on the mouse and select, "Copy")

12. Return to the Wiki page you wish to put this Excel table and click on the tab, "Edit the source." Then, paste the information into the page. (Use the instructions above for pasting the information.)

13. Save the page so the information will remain on the page. The table will now appear but the table will need to be formatted. Use the instructions below to format the table.

Adding Borders to the Table
To add borders to the table:

1. Click on the tab, "Edit source" and locate at the top of the table, "{|". Add the following code to create borders around each cell: class="wikitable"

The wikitext on the line should look like this: {| class="wikitable"

2. Save the page and you will now see borders around each cell.

3. If you would like to add more formatting to the table, use the Wiki University lesson on Tables to learn how.