downloading billing timesheets
Issue with downloading my billing timesheets.
Data appears in one column on spreadsheet making
it difficult to sort. Please help
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
Support Staff 1 Posted by John on 25 Jan, 2019 11:09 AM
Hi Graham
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
Different spreadsheets such as LibreOffice give fewer problems
Thanks
Sue