I want to export all timesheets for all time to do some filtering and analysis. When I do that I get a CSV file that when opened in Excel it has everything in one column. Can't it be formatted to have a column for each field?
Date,Year,Month,"Freelancer Name",Username,Agency,Contract,Activity,"Activity Description",Memo,Type,"Total Hours","Manual Hours","Total Charges","Manual Charges"
Are you referring to the most recent csv file you exported? I tried to replicate the issue you are having but wasn't able to. The exported file has different columns for each field:
Ingvar, it looks like Excel isn't reading the csv correctly. What version of Excel are you using? If you're using Excel 2013, there should be an option something lke "Convert" in the Data menu, you can use that and choose "commas".