How to Download Codes in Excel?
Step-by-Step Guide to Download Codes in Excel
1. Access ‘Batches’
- From the dashboard, click on ‘Tags’.
- Then, select ‘Batches’ from the menu.
2. Select the Batch ID
- Choose the ‘Batch ID’ for the batch from which you want to download the file.
3. Download the CSV File
- A new page will open.
- In the top-right corner, click on the ‘Download CSV’ button.
- The file will be downloaded to your device.
Conclusion
"That’s it! You’ve successfully downloaded the codes in CSV format. You can now manage and analyze your data in Excel for better tracking and reporting.
FAQ
1. In which format are the codes downloaded?
Codes are downloaded in CSV format, which can be easily opened and edited in Excel or other spreadsheet tools.
2. Do I need any special software to open the downloaded file?
No. CSV files can be opened in Microsoft Excel, Google Sheets, or any spreadsheet application.
3. Can I download multiple batches at once?
No. You can only download one batch at a time by selecting its specific Batch ID.
4. Why can’t I see the ‘Download CSV’ button?
Possible reasons include:
-
You may not have the required role-based permissions.
-
The batch may not contain any generated tags.
-
Your screen resolution may hide the button; try scrolling right or zooming out.
5. Will the CSV file include QR codes?
No. CSV files contain serial numbers and tag details, but not the actual QR images.
6. Can I download QR images instead of a CSV file?
Yes, if your portal has the Download QR Images feature enabled. If not, you’ll need to request access from the admin.
7. What information is included in the CSV file?
Typically, the CSV contains:
-
Serial numbers
-
Batch ID
-
Product details
-
Manufacturing and expiry details (if applicable)
-
Other tag-related metadata
8. What should I do if the CSV file does not open correctly in Excel?
Try the following:
-
Open Excel → Data → Import CSV.
-
Ensure your system supports UTF-8 character encoding.
-
Try opening the file in Google Sheets.
9. Does downloading a batch affect its status or usage?
No. Downloading is a read-only action and does not affect the batch or its serial numbers.
10. Can I regenerate or re-download the CSV file later?
Yes. You can download the CSV file anytime from the same Batch ID.
Need Assistance?
If you require Dyrect to assist you with an integration, you can do so by following these steps:
- Create a support ticket by submitting a form here or email us at support@dyrect.co
- A support will reach out to you to request access to your Shopify store.
Schedule a Personalize Demo
Related Articles
Guidelines for printing QR codes effectively
Challenges in QR Code Printing Many businesses face challenges when it comes to printing QR codes. This guide will help you understand how to print QR codes efficiently. QR Code Printing Options In-house Printing In-house printing involves businesses ...What are Serialized Codes?
In Dyrect, serialized codes refer to unique identifiers assigned to individual products or items in a sequential manner. These codes are used to track and trace each item throughout its lifecycle. Serialized codes serve several purposes within ...How to generate Serialized Codes?
In Dyrect, serialized codes are unique identifiers such as numbers or QR codes assigned to each product. These codes enable tracking and managing product details. Customers can scan QR codes to verify product authenticity, earn loyalty points, and ...Printing Guide
1. Overview This document outlines the complete process of creating, downloading, and printing QR codes using the Dyrect Portal. It also highlights recommended best practices to ensure QR codes are durable, scannable, and suitable for long-term use ...How to Track History of Codes?
Tracking tag history in Dyrect allows you to monitor the activity and status of each tag, providing valuable insights into product authentication, warranty activation, and customer interactions. By following a few easy steps, you can view detailed ...