How do I format my juke.txt in Microsoft Excel?
- Connect external USB storage device to the PC.
- From Windows Desktop (not from MCG Manager) go into USB storage device and select song folder.
- Copy juke.txt file and paste it to anywhere in Windows Desktop or My Document.
- Open Microsoft Excel.
- Go to OPEN.
- Select “Files of type” as text files.
- Select the folder where juke.txt file was copied to.
- Select juke.txt file and open.
- Text Import Wizard should appear. Be sure to select DELIMITED then press Next to go to step 2.
- In step 2, uncheck Tab under Delimiter, and check Other: and type |. (| should be located along with \ on the keyboard)
- Change text qualifier: from “ to {none} and press NEXT.
- In step 3, highlight each column in Data Preview and select Text in Column data format.
- Press FINISH.