• Skip to main content
  • Skip to secondary menu
  • Skip to primary sidebar

FromThePage Blog

Crowdsourcing, transcription and indexing for libraries and archives

  • Home
  • Interviews
  • crowdsourcing
  • how-to
  • Back to FromThePage
  • Collections

Spreadsheet Controls

The spreadsheet transcription feature allows projects with structured data to be transcribed as accurately as possible. Past projects on FromThePage that used the spreadsheet transcription feature include the 1850 Missouri Slave Census and the Jeffersonville Land Office Receipts.

The following video will walk you through the process of navigating a spreadsheet transcription project and teach you the spreadsheet controls on said projects.

  • Tab: Selecting the Tab key will move the cursor to the next horizontal cell.
  • Enter: Pressing the Enter key will move the cursor to the next vertical cell.
  • Ctrl + Enter: Pressing Ctrl + Enter will add a newline/carriage return within a cell.
  • When format doesn’t match: red highlight appears (i.e. 6/12 for age)
  • Cell widths resize to fit entry/heading text
  • Resize: Drag the header to make the column narrower or wider.
  • Add row: Right-click and select either "Insert row above" or "Insert row below".
  • Ctrl + C: Pressing Ctrl + C will copy text.
  • Ctrl + V: Pressing Ctrl + V will paste text.
  • Ctrl + Z: Pressing Ctrl + Z will undo the most recent action.
  • For ditto marks: Encourage transcribers to use “copy and paste”.

Primary Sidebar

What’s Trending on The FromThePage Blog

  • Archives as an Antidote for ChatGPT
  • How Do I Read Old Handwriting?
  • Spreadsheet Transcription in FromThePage
  • Classifying the Mistakes We Make When We Transcribe
  • An Interview with Dr. Camille Westmont of Sewanee:…
  • 10 Ways to Host a Great Transcribathon

Recent Client Interviews

An Interview with NC State University Libraries

An Interview with Richard Gilreath of the Texas State Library and Archives Commission

An Interview with Julanne Neal of the Queensland State Archives

An Interview with Andrea Meyer of East Hampton Public Library

An Interview with Keith Mitchell of The National Archives (UK)

Read More

artificial intelligence crowdsourcing features fromthepage projects handwriting history iiif indexing Indianapolis Indianapolis Children's Museum interview Jennifer Noffze machine learning metadata ocr paleography podcast Ryan White spreadsheet transcription transcription transcription software
Privacy Policy | Terms & Conditions | About Us | Contact Us

Copyright © 2023 · FromThePage.com