How to collect data into an excel spreadsheet

How to collect data into an excel spreadsheet

The log is collected as a text file and is saved to your PC directory (C:\Program Files\KAS) or (C:\Users \kas-support\AppData\Local\VirtualStore\Program Files\KAS) 

change "Kas-support" to your PC account name to find your PC account name click on the windows icon and hover your mouse on the account icon as shown below



Please ensure you note the name & file location when you export tit from the software.

  1. Open the text file of the collected records
  2. Select all
  3. Copy
  4. Open Excel
  5. Paste All

The steps below show how to paste comma-separated values directly into an Excel 2013 file.

This method uses a built-in feature of Excel 2013 and does not require creating a temporary CSV file.

In this example, we’ll be using the following list of comma-separated values

Sale1,$1.99,3:00pm,12/12/12
Sale2,$1.49,3:05pm,12/12/12
Sale3,$5.99,3:10pm,12/12/12
  1. Open Excel 2013
  2. Paste your comma-separated values into the document. They will automatically fill into a single column over multiple rows, .e.g.
  3. Excel2013-PastCSV1
  4. Select the row with the values (or select all the values)
  5. Open the ‘DATA’ tab then click on the ‘Text to Columns’ button
  6. Excel2013-PastCSV2
  7. A window will open with a wizard that’ll help you turn the comma-separated values into a properly formatted Excel document
  8. Excel2013-PastCSV3
  9. Click ‘Next’
  10. Under ‘Delimiters’ make sure the correct setting is selected that represents how your data is separated. If it’s correct, you’ll see lines between each row of data
  11. Excel2013-PastCSV4
  12.  Ensure you select Text
  13. Click ‘Next’ then ‘Finish’
  14. You should now have your data correctly formatted into columns
  15. Excel2013-PastCSV5

 

Source: https://www.itsupportguides.com/knowledge-base/office-2013/excel-2013-how-to-paste-comma-separated-values/