Reply
cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Custom Export Timesheet to Excel..

Active Member
Ingvar G Member Since: Mar 27, 2017
1 of 4

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"

Moderator
Valeria K Moderator Member Since: Mar 6, 2014
2 of 4

Hi Ingvar,

 

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:

 

Screenshot_22.png

~ Valeria
Untitled
Active Member
Ingvar G Member Since: Mar 27, 2017
3 of 4

Thanks for responding - That is odd. This is what I get when opening the file in Excel 2010.

 

Community Guru
Jennifer D Member Since: Feb 15, 2016
4 of 4

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".

TOP SOLUTION AUTHORS
TOP KUDOED MEMBERS