creating song book problem

[admin]

The Songbook.rtf file is in Rich Text Format.

Excel does not directly open an RTF file. Thus, you must first open it in Word or Wordpad, then export it in the format "Text only with line breaks (*.txt)"

When you open this in Excel, accept the defaults. When the file opens, move the column widths so they show the text in each field without overwriting fields to the right.

When trying to open a file in a different format than a program accepts, you will always see the "gibberish" that you saw. In a case like this, you will always need to use another program that opens the original file, and use it to export to a format the other program (Excel in this case) can open.