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/


    • Related Articles

    • LMS Software - How To Upload Data To Your Mobile Programmer

                  1)  Plug Programmer into the computer using the USB-encoder's cable.       2)  Open LMS Software       3)  Select Upload Data (top left of page)       4)  Select Download Lock Data       5)  Wait for confirmation message       6)  Once ...

    • LMS Software - How To Upload Data To Your Mobile Programmer

            1)       Plug Programmer into the computer using the USB-encoder’s cable.       2)      Open LMS Software       3)      Select Upload Data (top left of page)       4)      Select Download Lock Data       5)      Wait for confirmation message ...

    • LMS Software - "Data is half-baked incept" Error Message

      Experiencing Fault Data is half-baked incept when trying to upload the data How to resolve Close the software Disconnected the encoder and mobile programmer Reconnect the encoder ONLY Open the software and log in Issue any card Read this card. *You ...

    • How to create Security Audit Query Unlocking Record

      Audit Card An audit card will retrieve the last 424 entry records from the lock. If you have 2 card, you can collect the last 848 in total. Max 2 cards The Security Audit Query Card must be encoded (created) before using it on the lock From the Adel ...

    • Reading Error Code with Mobile Programmer V1

      Collect the data Take the mobile programmer to the lock you wish to collect the records from 1) Press FUN x 2 *The programmer will display collect recorders 2) Press RUN 3) Hold to lock induction area, you might have to adjust the position of the ...