You help make Hymnary.org possible. More than 10 million people from 200+ countries found hymns, liturgical resources and encouragement on Hymnary.org in 2025, including you. Every visit affirms the global impact of this ministry.

If Hymnary has been meaningful to you this year, would you take a moment today to help sustain it? A gift of any size—paired with a note of encouragement if you wish—directly supports the server costs, research work and curation that keep this resource freely available to the world.

Give securely online today, or mail a check to:
Hymnary.org
Calvin University
3201 Burton Street SE
Grand Rapids, MI 49546

Thank you for your partnership, and may the hope of Advent fill your heart.

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.