Help:Copy Spreadsheets into the Wiki

From FamilySearch Wiki

(Difference between revisions)
(Update instructions)
(Update tm)
Line 56: Line 56:
  
 
=== See Also  ===
 
=== See Also  ===
{{Contributor Help badge}}
+
 
 +
{{Contributor Help badge
 +
| link = https://familysearch.org/ask/
 +
| name = Get Help}}
 +
 
 
*[[Help:Adding basic tables to an article]]  
 
*[[Help:Adding basic tables to an article]]  
 
*[[Help:Tables]]  
 
*[[Help:Tables]]  
Line 62: Line 66:
 
*WikiMedia's article on [http://meta.wikimedia.org/wiki/Help:Collapsing Collapsible tables]
 
*WikiMedia's article on [http://meta.wikimedia.org/wiki/Help:Collapsing Collapsible tables]
  
{{Translation needed|es|Ayuda:Copiar hojas de cálculo en el Wiki}}
+
{{Translation needed|es|Ayuda:Copiar hojas de cálculo en el Wiki}}  
  
{{Contributor help-navbox}} {{Editing help}}
+
{{Contributor help-navbox}} {{Editing help}}  
  
 
[[Category:Help]]
 
[[Category:Help]]

Revision as of 06:10, 15 October 2013

Help-content.png This help article will guide you as you edit in the Wiki. See Contributor Help for more help articles.


Some contributors wish to import information from existing spreadsheets. This is especially helpful when trying to import tables, or keep current formatting from pre-existing or spreadsheets.

Contents

How to copy a spreadsheet table into the Wiki

1. Using your Internet browser, navigate to the Excel Converter website located at http://excel2wiki.net/.

2. (On your computer:) Open the spreadsheet or Excel file you wish to copy to the FamilySearch Wiki.

3. Select all of the contents in the spreadsheet by left-clicking in the upper left-hand corner of the table you want to copy, and while holding down the left mouse button, drag the mouse until the text or table you wish to copy is entirely highlighted.

4. Release the left mouse button, and without clicking, position your cursor over the highlighted area. Now right-click on the highlighted area, and click "Copy" (or, while the mouse is positioned over the highlighted area, copy the highlighted text by holding down the "Ctrl" key while tapping the "C" key once.)

5. Re-open the Excel Converter website, and paste the Excel table or spreadsheet into the window provided on the Excel Converter website. Click "Submit".

Excel Converter Screenshot.png

6. After clicking "Submit", the heading "Result" will appear below the "Submit" button (see image below), followed by Wiki text. Copy the Wiki text by holding down the "Ctrl" key while tapping the "A" key once, and then holding down the "Ctrl" key again while tapping the "C" key once. [NOTE: this will copy the word "Result" and "Format Heading," but these can be deleted later.] (Or, left-click and drag over all of the text, and then, with the cursor positioned over the highlighted text, hold down the "Ctrl" key while tapping the "C" key once.)

Excel Converter Results.png

7. (Online at Wiki.FamilySearch.org:) Open the page in which you wish to import the document or create a new page, and open the edit box by clicking on the "Edit" option for that page or article. This will open the editing window.

8. At the top of the editing window is a shaded bar containing several icons (see below):Image:Editor_Toolbar.png

9. Click on the "Wikitext" button on the editor toolbar, in the lefthand corner of the toolbar (see below): Image:Editor_ToolbarWT.png[Note: You do not need to do this if you have the rich text editor disabled in your preferences].

10. In the Wikitext editing window, paste the copied text in the location where you want the text or table to appear by placing your cursor in the appropriate location in the body of the text, and left clicking with your mouse to indicate where the text or table should appear. Then, while holding down the "Ctrl" button on the keyboard, tap the "V" key on the keyboard. (See the "Special Instructions" section below for additional help regarding tables.)
11. After pasting the text into the editing window, scroll down to the bottom of the screen, and click Save Page. The formatted text and/or tables will appear on the Wiki page.

Adding Borders to the Table

To add borders to the table:

1. Open the editing window

2. Right click on the table

3. Select "Table Properties." This will open the Table Properties window.

4. Add a number in the "Border size" box

5. Click "OK"

6. Scroll down below the editing window and click "Save page."

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.

See Also

Help-content.png Questions?
Visit the Get Help to receive help with contributing to the Wiki.
https://familysearch.org/learn/wiki/en/index.php?title=Help:Copy_Spreadsheets_into_the_Wiki&diff=1472359&oldid=1472358
familysearch.org
crawl=CC-MAIN-2014-23
76198
application/http; msgtype=response
sha1:7VUIVPAT7MEOZFT5QVDDYQJGO6B75TMK
<urn:uuid:59500cc8-4f82-49e4-a7f7-78b19077c29d>
2014-07-13T05:43:09Z
204.9.224.11
sha1:XEXLKY63JUTVTD5NEQQ6X6VSVZP2WKL4
<urn:uuid:ace48680-9a87-4a81-8ee3-bba5623e974f>
https://familysearch.org/learn/wiki/en/index.php?title=Help:Copy_Spreadsheets_into_the_Wiki&diff=1472359&oldid=1472358
response
<urn:uuid:2bfcf068-2ded-4f06-99ba-bf1a233489c2>
robots: classic
hostname: ip-10-180-212-248.ec2.internal
software: Nutch 1.6 (CC)/CC WarcExport 1.0
isPartOf: CC-MAIN-2014-23
operator: CommonCrawl Admin
description: Wide crawl of the web with URLs provided by Blekko for July 2014
publisher: CommonCrawl
format: WARC File Format 1.0
conformsTo: http://bibnum.bnf.fr/WARC/WARC_ISO_28500_version1_latestdraft.pdf