Score Reader ".csv" Formatting Tips

This only applies for versions before 1.2.

The Rock Band Score Reader is currently optimized for Excel 2007. With earlier versions of Excel it might open a raw ".csv" file (with no formatting, sorting and stats) instead of a formatted ".xls" file (even if "Excel" is selected in "Advanced Options").

If you have this issue, keep an eye on this page as a new version should be coming soon.

In the meantime, if you want to transform your ".csv" files into a readable sorted scores list, please do the following:

1. Select the first column

2. Click the "Data" menu, then "Text to Columns..."

3. Select "Delimited" and "Next"

4. Only select "Semicolon" then "Next"

5. Click "Finish"

6. Select all cells by clicking in the top left corner

7. Click the "Format" menu, then "Column" and "AutoFit Selection"

8. Click the "Data" menu, then "Sort..."

9. Select to "Sort by": "Format", "Descending"

10. Select "Then by": "Rank", "Ascending"

11. Select "Then by": "Title", "Ascending"

12. Click "OK" and you have a decent scoresheet!

Bonus: For columns with scores, you can add "1000 Separator" formatting by right-clicking on the column letter at the top and selecting "Format Cells...". Change the "Category" to "Number" and you can then put "Decimal places" to 0 and check "Use 1000 Separator (,)".