🐈
» Forums » Clients » Re: Custom Export Timesheet to Excel..
Page options
Ingvar's avatar
Ingvar G Community Member

Custom Export Timesheet to Excel..

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"

12 REPLIES 12
Valeria's avatar
Valeria K Community Member

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
Upwork
Uni's avatar
Uni C Community Member

it looks like Excel isn't reading the csv correctly

unicorn coloring pages

Ingvar's avatar
Ingvar G Community Member

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

 

**Edited for Community Guidelines**

Jennifer's avatar
Jennifer D Community Member

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

Bill's avatar
Bill P Community Member

This feature now costs $600 a year!  When you went to the pro version you took away features that were free before?????

 

Please tell me this isn't true

Aleksandar's avatar
Aleksandar D Community Manager

Hi Bill,

 

Thanks for reaching out to us. One of our team members will reach out to you directly to assist you further.

 

Thank you.

~ Aleksandar
Upwork
Safari's avatar
Safari I Community Member

Are they still charging for the feature? 

Chin's avatar
Chin W Community Member

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

i agree, Hope you will have the answer

World's avatar
World C Community Member

Thank you very much for your sharing!

 

nature coloring pages
Bollywood's avatar
Bollywood R Community Member

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". word counter i agree, Hope you will have the answer. Instagram Video Downloader. 

Kim's avatar
Kim C Community Member

I'm so excited and looking forward to it

 

resize image

Nayan's avatar
Nayan W Community Member

Now it's easy to import telltims