FAQ
Copy manually into Spreadsheet
TransferDeck features conversions that export as CSV -> that can be imported into any spreadsheet program.
However there are times when you need to manually copy data into a spreadsheet
-> eg if you have character set issues where accents display weird this will be ideal
# 1 > VIEW
After logging into TransferDeck
-> Click Conversions
-> Choose either Persistent OR Date
-> Click 'VIEW' next to the report you want to copy
# 2 > COPY
You now see a white screen with all the info on this specific report
-> Simply click 'CTRL+A' (mac: Command+A) - Which will select all the text on the screen
-> Click 'CTRL+C' OR mac COMMAND+C - This will copy the entire page into your clipboard
# 3 > Open spreadsheet
We recommend "LibreOffice" https://www.libreoffice.org for opening CSV files and XLS files
-> but you can use your favourite program as well.
-> Open Calc and you will see an empty window
-> Push 'CTRL+V' OR mac: COMMAND+V OR file -> edit -> paste
-> On LibreOffice you get the prompt for option accept the default
NOTE: allow some time to pass if you copied a large amount of data
# 4 > PASTED
Your content has now been pasted into your spreadsheet program
You can now save as -> change file type to Microsoft excel (if you want to have others open with Excel only)
-> Or you can SAVE AS -> CSV which is an open format that is able to open on many programs
NOTE: Notice in our example we need to clean up the first 2 rows since they are causing issues
-> So we are going to delete the first 2 rows so the column headers are in row 1
# 5 > Clean-up
It is easy to clean up the first 2 rows which will ensure the column headers start at row 1
-> Simply use your mouse to select on the numbers to choose the first 2 rows
Notice your file now has the column headers in the first row
-> This now ensures filtering and sorting works without issues.