Help:How to Convert a Microsoft Office Document into Wiki Format

From FamilySearch Wiki
Revision as of 18:52, 2 June 2008 by RoachA (talk | contribs) (Adjusted for clarity)

Jump to: navigation, search

Some contributors wish to import information from existing documents or spreadsheets. This is especially helpful when trying to import tables, or keep current formatting from pre-existing documents or spreadsheets. To create a wiki page from a Microsoft Office document, do the following:

  1. (On your computer:) Download and install Open Office. This takes about five minutes and is free.
  2. Open one of the following Open Office programs by clicking on your Start button, then Programs/All Programs, and click on OpenOffice at the bottom of the list of programs: to import a Microsoft Office document or HTML file, open Open Office Writer; to import an Excel spreadsheet, open Open Office Calc.
  3. Open your document in the appropriate Open Office program (Writer for Word documents or HTML files, Calc for Excel spreadsheets) by clicking File, Open, and locate the your document or spreadsheet on your computer or storage device.
  4. Once the document is open in the Open Office program, click File on the menu, and then click Export.
  5. The Save window will appear. First type a name for the file. Next, in the "Files of Type" dropdown, choose MediaWiki.
  6. Choose a folder in which you want to save the file, and click Save. Remember where you saved the file.
  7. A text docment (.txt) will be created in the location you specified in step 6. Locate the document you just created. Open that document by double clicking on it. It will open in NotePad or another text editor.
  8. (Online at Open the page in which you wish to import the document or spreadsheet, or create a new page, and open the edit box by clicking on the "Edit" tab. 
  9. On the editor toolbar in the lefthand corner, click the Wikitext button (you do not need to do this if you have the rich text editor disabled in your preferences).
  10. (On your computer:) Copy the contents of the text document by highlighting all of the text.
  11. (Online at Paste the copied text into the wiki authoring window. (See the "Special Instructions" section below for additional help regarding tables.)
  12. At the bottom of the screen, click Save Page. The formatted text and/or tables will appear

Special Instructions

To format a table after pasting the text:

  1. Click edit to edit the page.
  2. Click on "Wikitext" in the lefthand corner of the editor toolbar.
  3. Search the document for each occurance of this line: {| class="prettytable"
    The line will appear once for each table that is in the document. This will widen the table and add a border.
  4. Change the line to read as follows: {| width="75%" border="1"
    Note: You can change the percentage value for "width" to make your table wider or narrower.