Tools >

Import Sermon Metadata

In Logos 9.3 and higher, you can import a spreadsheet of sermons into the Sermon Manager tool, to serve as an archive or planning aide.
Each row in the spreadsheet creates a sermon document, tagged with the appropriate date and other metadata. It does not import the transcript of the sermon.

You can access this feature in the panel (“kebab”) menu of the Sermon Manager, in both the desktop software and app.logos.com.

How to Format your Spreadsheet

Comma Seperated Value (.csv) is the only valid file format at this time; .xlsx and other spreedsheet formats are not supported.

Metadata Fields

Each sermon metadata field is represented as a column in the spreedsheet.

  • Title is the only required field.
  • Header names must exactly match the metadata field name. (This is language-dependant; eg., if you are running the software in Spanish, use Spanish metadata names for your CSV header.)
    • Multiple occasions are a special case, which are represented by Date 2, Venue 2, Service 2, etc..
    • You can have as many additional Occasions as you want, but all Occasions must have the same fields. That is, if you want a Venue column for the first Occasion, you must have a “Venue [#]” column for all occasions.
  • Please refer to the example spreadsheet to use as a template.

References

Dates, passages, and topics will attempt to parse to a valid reference. If a reference cell cannot be parsed, the software will skip that field, and leave a warning message in the log.

Other Notes

Sermons with the same title and date as one that already exists in Sermon Manager will be treated as duplicates and skipped.
Known Issue: All dates are parsed in US date format (month, day, year). In 9.4, date parsing respects your operating system’s locale.



Logos Bible Software Wiki

Welcome, Guest! (sign in)