Problem downloading my billing timesheets

Jeffery's Avatar

Jeffery

02 Jun, 2016 09:04 AM

When downloading my billing timesheets all my data appears in one column on the spreadsheet… this makes it really difficult to sort. Help!

  1. Support Staff 1 Posted by Sue on 02 Jun, 2016 09:11 AM

    Sue's Avatar

    Hi Jeffery

    I can certainly give you some advice with this.

    Your data might appear in one column if the application you're importing it into doesn’t split based on the comma (ie uses another “delimiter”).

    You can usually choose the delimiter when loading in Excel. This article might help http://www.ehow.com/how_8578397_do-comma-delimited-files-excel.html

    Other spreadsheets such as LibreOffice usually give fewer problems!

    Let us know how you get on.

    Sue

  2. 2 Posted by Jeffery on 02 Jun, 2016 11:29 AM

    Jeffery's Avatar

    Thanks Sue that article made it clear.

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac

Recent Discussions

20 Aug, 2019 04:40 PM
12 Aug, 2019 09:02 PM
05 Aug, 2019 08:24 AM
23 May, 2019 05:47 PM
28 Mar, 2019 10:53 AM