This is how I do it:
These instructions are useing Microsoft Office 2003 so other versions may be different but should give some idea.
Create your songbook, best to use the Title option, if you create it as Artist make sure you tick the box for Include Artist w/each song. Set the other options for First Name/Last Name as you prefer and the The/A as your prefer.
Set the columns to 1 then open in Microsoft Word.
Now you need to save it as Plain .txt file, to do that from the File menu select Save As, at the bottom of the dialog is a drop down for Save as Type, click the drop down and select "Plain Text(*.txt)" I would save it to your desktop for now so it's easy to find.
The next dialog has a preview at the bottom showing your lines of text just select Windows default for Windows encoding then Save.
Now open XL,
don't click on the new file and select open with XL as it seems to mess up that way.
From the Menu select Data/Import External Data, brows to your desktop and select the new .txt file. In this dialog, at the bottom for files of type choose .txt or All files. then select your new file then open, if clicking it doesn't put it in the file name window just type it in or double click it quickly that should take you to another dialog, select Delimited, you will see a preview window so you can check the progress click Next, in the next box select Semicolon, for text qulifier select(") without the brackets.
Now the preview window should show the lines of text seperated into their correct columns , check they look right before continuing, if on the last column you want the track seperate from the root id you can tick the box for "Other" and enter a (-) in the box. then press next then Finish and new worksheet.
that should be it
