Let me tag along on how I create an Excel Song Catalog
1) Create a text file song catalog:
a) Run TKaraoke software
b) Click "Tools" then "Generate Song Catalog"
c) Type
%number%;%song%;%singer%;%album%;%lyric% in "Enter Song Catalog Format" popup window
d) Default file name to be saved is "TKaraoke Song Catalog" make a note of the location of the file.
2) Use Notepad to open the file just created above.
3) Select "File", then "Save As" from Notepad, at the bottom select "Unicode" for encoding (This step would convert the text file to "Unicode" text file so that Vietnamese language will be displayed properly)
4) Run MS Excel, Click Open (To select the unicode file you have to change file type from "All Excel Files" to "All File") then navigate to the file you saved in step 3.
5) "Text Import Wizard" will popup. Click "Next".
6) On next screen, select Semicolon as the "Delimeters". Click "Next".
7) Click "Finish", this will create a spreadsheet for your song catalog. Using Excel you can sort each column alpha-numerically
Edited by user Sunday, September 23, 2012 3:28:43 PM(UTC)
| Reason: Not specified