Mar 27, 2017 08:48:41 AM by Ingvar G
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"
Mar 27, 2017 11:19:59 AM by Valeria K
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:
Mar 27, 2017 11:27:02 AM Edited Aug 29, 2021 07:14:53 AM by Aleksandar D
Thanks for responding - That is odd. This is what I get when opening the file in Excel 2010.
**Edited for Community Guidelines**
Mar 27, 2017 04:08:29 PM by Jennifer D
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".
Feb 16, 2020 07:09:48 AM Edited Feb 16, 2020 07:10:31 AM by Bill P
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
Feb 16, 2020 08:44:16 AM by Aleksandar D
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.
Jun 29, 2020 12:28:01 AM Edited Jun 29, 2020 12:28:38 AM by Chin W
by Jennifer D
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
May 29, 2021 12:20:39 AM by Bollywood R
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.