Podcast Chapters

CSV Import



Thanks for your interest in Podcast Chapters. If your question isn't answered in this FAQ, feel free to reach out to me on Mastodon and I'll be sure to help you out.

← Return to Podcast Chapters


What is CSV import?

Podcast Chapters 2.6 lets you import podcast information from CSV files - text files with values separated by commas, a format supported by, for example, applications such as Excel and Numbers.

CSV import is useful if you have podcast information already entered and want to speed up getting it into Podcast Chapters.

The CSV import format lets you import not only basic chapter markers, but also URL:s, images, as well as description and other information for the podcast itself.

A common use case would be to enter the podcast information in a spreadsheet app like Excel or Numbers, then export it in CSV format and drag the file onto Podcast Chapters to set all the information at once.

What is the format?

By default, comma is used as the separator character between fields, but you can change to tab or semicolon in Podcast Chapters' preferences window.

If you need to include the separator inside a value, the value needs to be surrounded by double quotes. If there are also double quotes in the value, they need to be doubled. Most apps supporting CSV export should handle this automatically.

A note on images

For security reasons, Podcast Chapters will need your permission each time an image is read from a new folder. When this happens, a dialog will be displayed asking you to select the folder containing the image. The dialog will already have the folder selected, so just clicking "Open" is all you need to do.

Podcast Chapters remembers which folders you've already given permission for, so you should rarely see this dialog if you keep your images in one place.

Chapter rows

Only chapter title and start time is mandatory.

  • Chapter title
  • Start time - start time of the chapter, in MM:SS or HH:MM:SS format as needed
  • URL - URL the chapter links to
  • Image URL - the file system path to the chapter image
  • Hidden - true or false. Should the chapter be hidden? If left out, the chapter will not be hidden

Other rows

Other rows contain other podcast information. Each row begins with an identifier, followed by the value.

  • PODCAST - the title of the podcast
  • AUTHOR - the author of the podcast
  • TITLE - the episode tidle
  • DESCRIPTION - the episode description
  • YEAR - release year of the episode
  • ARTWORK - the file system path to the episode artwork

Example

The last three lines are chapters.

PODCASTThe Fantastic Example Podcast
AUTHORFredrik Björeman
TITLE34 - The Magic of CSV Import
DESCRIPTION"Fredrik, in the best of moods, imports podcast episode data from CSV files."
YEAR2020
ARTWORK/Users/fredrik/Desktop/massiveArtwork.png
Introduction00:00/Users/fredrik/Desktop/chapter1Image.pngfalse
Some Background05:34https://en.wikipedia.org/wiki/Comma-separated_values
Final Words01:35:14true