Text Spreadsheet

A Text Spreadsheet should be provided as part of the hymnal installation process. It should consist of the following columns, in any order:

Required columns:

  • Hymn number, the hymn number
  • Full text, the complete text of the hymn

Recommended Column:

  • Text Display Permissions, "none", "subscribers", or "all", to indicate which users should be able to view the full text based on copyright agreements

Notes

  • As with all spreadsheets, the first row will be treated as a header row and ignored.

Example

Below is what part of a Text Spreadsheet could look like. A complete example can also be downloaded here (zip file).

Hymn Number Full Text Text Display Permissions
83 Write these words in our hearts, we beseech you, O Lord. all
84 Good Christian friends, rejoice with heart and soul and voice; none

It looks like you are using an ad-blocker. Ad revenue helps keep us running. Please consider white-listing Hymnary.org or getting Hymnary Pro to eliminate ads entirely and help support Hymnary.org.