special-[date].csv and the files in the civicrm.zip use an extra semicolon in some fields. Make sure your spreadsheet program _only_ uses a comma as separator when opening these files, otherwise the data would be misrepresented.