Totally understandable, but there's a small bug in the Roster download. Hometown/State isn't enclosed in quotes, so it's treated as two separate fields in the CSV, since there's a comma in the middle.
Easiest fix would be to add a column at the top for "State", after Hometown. Or they could put the Hometown/State in quotations and it should be handled properly.
You're correct that the Roster download does not include the quotes, however it appears the recruit download does...
Bookmarks