--- title: Opening SLGA Reports (SK Compliance Report) description: This article provides valuable guidance on handling CSV files. To preserve their original formatting, it is advisable to avoid opening them directly in Excel. Below, we outline the best practices for maintaining the formatting of CSV files. --- [Skip to content](https://knowledge.techpos.ca/en/knowledge/formatting-csv-file#main-content) [Customer portal](https://knowledge.techpos.ca/portal?hsLang=en) ![TECHPOS\_Full-Logo\_Brand-Colorsmaller](https://knowledge.techpos.ca/hs-fs/hubfs/TECHPOS_Full-Logo_Brand-Colorsmaller.png?width=500&height=125&name=TECHPOS_Full-Logo_Brand-Colorsmaller.png) Open main navigation Close main navigation - [Customer portal](https://knowledge.techpos.ca/portal) Hello. How can we help you? - There are no suggestions because the search field is empty. 1. [Knowledge Base](https://knowledge.techpos.ca/en/knowledge?hsLang=en) 2. [Reports](https://knowledge.techpos.ca/en/knowledge/reports?hsLang=en) # Opening SLGA Reports (SK Compliance Report) ## This article provides valuable guidance on handling CSV files. To preserve their original formatting, it is advisable to avoid opening them directly in Excel. Below, we outline the best practices for maintaining the formatting of CSV files. Below are the steps to open Compliance Report from SK (SLGA) Instead of opening the files in Excel, the best option is to open them in a program like Notepad.  Copy contents of the file and then paste the contents in Excel using the Text Import Wizard (accessible if you click on the arrow below the Paste button). ![](https://knowledge.techpos.ca/hs-fs/hubfs/image-png-Jul-23-2025-09-12-02-1647-PM.png?width=150&height=158&name=image-png-Jul-23-2025-09-12-02-1647-PM.png) Select ‘Delimited’ and ‘My data has headers.’ ![](https://knowledge.techpos.ca/hs-fs/hubfs/image-png-Jul-23-2025-09-12-11-6591-PM.png?width=864&height=654&name=image-png-Jul-23-2025-09-12-11-6591-PM.png)   Delimiter type selected should be ‘Comma.’ ![](https://knowledge.techpos.ca/hs-fs/hubfs/image-png-Jul-23-2025-09-12-22-8616-PM.png?width=866&height=660&name=image-png-Jul-23-2025-09-12-22-8616-PM.png)   Click on the Timestamp column and click ‘Text.’  Repeat this for the Transaction ID and GTIN columns.  Eventually these should look like this: ![](https://knowledge.techpos.ca/hs-fs/hubfs/image-png-Jul-23-2025-09-12-32-0529-PM.png?width=868&height=648&name=image-png-Jul-23-2025-09-12-32-0529-PM.png)   Click ‘Finish.’  The data should now be in Excel in the correct format.  Once you’re done editing you’ll need to save the file as a comma-delimited .csv file.  Once saved and closed you will not be able to open the file without impacting formatting.  If further edits are needed they can be made in Notepad or by following the above steps again. You can also identify any needed edits in Excel and then make any necessary edits in Notepad directly – which might be less of a headache on the formatting front.   - [Line of Products](https://knowledge.techpos.ca/en/knowledge/line-of-products?hsLang=en#main-content) - [Express Checkout](https://knowledge.techpos.ca/en/knowledge/line-of-products?hsLang=en#express-checkout) - [E-Commerce](https://knowledge.techpos.ca/en/knowledge/line-of-products?hsLang=en#e-commerce) - [Digital Signage](https://knowledge.techpos.ca/en/knowledge/line-of-products?hsLang=en#digital-signage) - [Cannabis Analytics](https://knowledge.techpos.ca/en/knowledge/line-of-products?hsLang=en#cannabis-analytics) - [Auto Tag](https://knowledge.techpos.ca/en/knowledge/line-of-products?hsLang=en#auto-tag) - [Getting Started](https://knowledge.techpos.ca/en/knowledge/getting-started?hsLang=en#main-content) - [Hardware Setup](https://knowledge.techpos.ca/en/knowledge/getting-started?hsLang=en#hardware-setup) - [Online Menu Setup](https://knowledge.techpos.ca/en/knowledge/getting-started?hsLang=en#online-menu-setup) - [Integrations](https://knowledge.techpos.ca/en/knowledge/getting-started?hsLang=en#integrations) - [Business Insights](https://knowledge.techpos.ca/en/knowledge/business-insights?hsLang=en) - [Point of Sale](https://knowledge.techpos.ca/en/knowledge/point-of-sale?hsLang=en#main-content) - [POS Sales Configuration Options](https://knowledge.techpos.ca/en/knowledge/point-of-sale?hsLang=en#pos-sales-configuration-options) - [Opening & Closing The Cash Register](https://knowledge.techpos.ca/en/knowledge/point-of-sale?hsLang=en#opening-closing-the-cash-register) - [Processing In-Store Transactions](https://knowledge.techpos.ca/en/knowledge/point-of-sale?hsLang=en#processing-in-store-transactions) - [Managing Members](https://knowledge.techpos.ca/en/knowledge/point-of-sale?hsLang=en#managing-members) - [Refunds](https://knowledge.techpos.ca/en/knowledge/point-of-sale?hsLang=en#refunds) - [Store Credit](https://knowledge.techpos.ca/en/knowledge/point-of-sale?hsLang=en#store-credit) - [Discounts](https://knowledge.techpos.ca/en/knowledge/point-of-sale?hsLang=en#discounts) - [Payment](https://knowledge.techpos.ca/en/knowledge/point-of-sale?hsLang=en#payment) - [Inventory](https://knowledge.techpos.ca/en/knowledge/inventory?hsLang=en#main-content) - [Products](https://knowledge.techpos.ca/en/knowledge/inventory?hsLang=en#products) - [Categories](https://knowledge.techpos.ca/en/knowledge/inventory?hsLang=en#categories) - [Purchase Orders](https://knowledge.techpos.ca/en/knowledge/inventory?hsLang=en#purchase-orders) - [Warehouse](https://knowledge.techpos.ca/en/knowledge/inventory?hsLang=en#warehouse) - [Bulk Transfer](https://knowledge.techpos.ca/en/knowledge/inventory?hsLang=en#bulk-transfer) - [Product Hub](https://knowledge.techpos.ca/en/knowledge/inventory?hsLang=en#product-hub) - [Inventory Audit](https://knowledge.techpos.ca/en/knowledge/inventory?hsLang=en#inventory-audit) - [Vendor](https://knowledge.techpos.ca/en/knowledge/vendor?hsLang=en) - [Users](https://knowledge.techpos.ca/en/knowledge/users?hsLang=en#main-content) - [Member](https://knowledge.techpos.ca/en/knowledge/users?hsLang=en#member) - [Employee](https://knowledge.techpos.ca/en/knowledge/users?hsLang=en#employee) - [User Role](https://knowledge.techpos.ca/en/knowledge/users?hsLang=en#user-role) - [Member Group/Tiered Membership](https://knowledge.techpos.ca/en/knowledge/users?hsLang=en#member-group-tiered-membership) - [Admin](https://knowledge.techpos.ca/en/knowledge/admin?hsLang=en#main-content) - [Cash Register](https://knowledge.techpos.ca/en/knowledge/admin?hsLang=en#cash-register) - [Safe Management](https://knowledge.techpos.ca/en/knowledge/admin?hsLang=en#safe-management) - [Shifts](https://knowledge.techpos.ca/en/knowledge/admin?hsLang=en#shifts) - [Schedules](https://knowledge.techpos.ca/en/knowledge/admin?hsLang=en#schedules) - [Orders](https://knowledge.techpos.ca/en/knowledge/admin?hsLang=en#orders) - [Marketing](https://knowledge.techpos.ca/en/knowledge/admin?hsLang=en#marketing) - [Settings](https://knowledge.techpos.ca/en/knowledge/admin?hsLang=en#settings) - [Reports](https://knowledge.techpos.ca/en/knowledge/reports?hsLang=en#main-content) - [Sales Reports](https://knowledge.techpos.ca/en/knowledge/reports?hsLang=en#sales-reports) - [Cash Management](https://knowledge.techpos.ca/en/knowledge/reports?hsLang=en#cash-management) - [Employee](https://knowledge.techpos.ca/en/knowledge/reports?hsLang=en#employee) - [Inventory](https://knowledge.techpos.ca/en/knowledge/reports?hsLang=en#inventory) - [Consolidated Reports](https://knowledge.techpos.ca/en/knowledge/reports?hsLang=en#consolidated-reports) - [Members](https://knowledge.techpos.ca/en/knowledge/reports?hsLang=en#members) - [Compliance](https://knowledge.techpos.ca/en/knowledge/reports?hsLang=en#compliance) - [Pricing](https://knowledge.techpos.ca/en/knowledge/pricing?hsLang=en#main-content) - [Tax Setting](https://knowledge.techpos.ca/en/knowledge/pricing?hsLang=en#tax-setting) - [Campaigns](https://knowledge.techpos.ca/en/knowledge/pricing?hsLang=en#campaigns) - [Combo](https://knowledge.techpos.ca/en/knowledge/pricing?hsLang=en#combo) - [Customized Discount](https://knowledge.techpos.ca/en/knowledge/pricing?hsLang=en#customized-discount) - [Bulk Price Update](https://knowledge.techpos.ca/en/knowledge/pricing?hsLang=en#bulk-price-update) - [Web Menu](https://knowledge.techpos.ca/en/knowledge/web-menu?hsLang=en#main-content) - [Store Rules List](https://knowledge.techpos.ca/en/knowledge/web-menu?hsLang=en#store-rules-list) - [Menu (Categories) List](https://knowledge.techpos.ca/en/knowledge/web-menu?hsLang=en#menu-categories-list) - [Carousel List](https://knowledge.techpos.ca/en/knowledge/web-menu?hsLang=en#carousel-list) - [UI Setting](https://knowledge.techpos.ca/en/knowledge/web-menu?hsLang=en#ui-setting) - [Integrations](https://knowledge.techpos.ca/en/knowledge/integrations?hsLang=en#main-content) - [E-Commerce](https://knowledge.techpos.ca/en/knowledge/integrations?hsLang=en#e-commerce) - [Compliance Report](https://knowledge.techpos.ca/en/knowledge/compliance-report?hsLang=en) - [FAQs](https://knowledge.techpos.ca/en/knowledge/faqs?hsLang=en) - [New Features](https://knowledge.techpos.ca/en/knowledge/new-features?hsLang=en#main-content) - [July 2025](https://knowledge.techpos.ca/en/knowledge/new-features?hsLang=en#july-2025) - [June 2025](https://knowledge.techpos.ca/en/knowledge/new-features?hsLang=en#june-2025) - [May 2025](https://knowledge.techpos.ca/en/knowledge/new-features?hsLang=en#may-2025) - [February 2026](https://knowledge.techpos.ca/en/knowledge/new-features?hsLang=en#february-2026) - [PAT](https://knowledge.techpos.ca/en/knowledge/pat?hsLang=en#main-content) - [Product Auto Tags](https://knowledge.techpos.ca/en/knowledge/pat?hsLang=en#product-auto-tags) [![Chill listening crop-3](https://knowledge.techpos.ca/hs-fs/hubfs/Logo-2021.png?width=175&height=55&name=Logo-2021.png "Chill listening crop-3")](http://techpos.ca) Knowledge Base Copyright © 2026, TechPOS International Corp.