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

13 Feb, 2020 03:52 AM
04 Feb, 2020 12:21 PM
18 Jan, 2020 04:14 PM
10 Jan, 2020 09:06 AM
07 Jan, 2020 12:24 PM