How to Import Excel / CVS Data
Route: Batch Barcode Generator - [ How to Import Excel / CVS Data ]Move your mouse over the [Import Excel or CSV File] button—an import button will pop up. Click it to select the Excel or CSV file you want to import. This feature supports imports of .xlsx, .xls, and .csv files. Note that for .xlsx and .xls files, the program will only read data from the first worksheet (Sheet 1).
Required Format for Imported Excel Files
Your Excel file must follow the format below to ensure successful import:
| Column Number | Purpose | Notes |
| 1st Column | Barcode Text | Mandatory (required to generate barcodes). |
| 2nd Column | Barcode Footnote | Optional—leave blank if you do not want to display a footnote. |
| 3rd Column | Barcode File Name | Optional—if left blank, the program will automatically use a serial number as the file name. |
| 4th–8th Columns | Additional Text Items | Optional—use these columns to add extra text to barcodes (up to 5 additional items total). For details: [What are Barcode Add-texts?.] |
Important Notes for Import
- Excel Scientific Notation Issue : Set the Excel cell format to [Text] to avoid incorrect numerical display. For example, the phone number "13800138000" may be shown as "1.38E+10" if the cell format is not set to Text. For instructions: [How to Set Cell Format to Text?]
- Use DoingLabel’s Templates (Recommended) : To simplify the process, use the Excel/CSV templates provided by DoingLabel. Fill in your barcode data in the template first, then import the template file.
Troubleshooting Import Errors
If the import fails, the issue may be:
- Incorrect file format (e.g., unsupported file extension).
- File size or data volume exceeding the maximum limit.
For detailed solutions to import errors: See [Unable to Import/Upload Excel Files?].
Advanced Excel Import Features
For more advanced import needs (e.g., importing Excel/CSV files while duplicating rows as required), click the [Additional methods for importing Excel] button to access additional options:
-
Option 1: Copy row data based on the count of repeats.
Specify how many times each row of data in the Excel file should be duplicated (e.g., copy each row 5 times to generate 5 identical barcodes). For details: [How to Specify Repeat Count for Each Row When Importing Excel/CSV Files]
-
Option 2: Copy row data using the split code
Split a single row of data into multiple rows using a split code (e.g., commas, semicolons) in the text. For details: [How to Split Data into Multiple Rows Using a Split Code When Importing Excel/CSV Files]
Insertion Methods for Newly Imported Data
If there is already existing data in the data list before importing new data, you can choose how to insert the new data by checking the corresponding option:
- Replace the Table
- Append to Table Start
- Append to Table End
Support for Excel Formulas
The tool supports calculations using Excel functions. For important considerations: Click to learn [Notes on Using Excel Formulas].
- Kindly refrain from reposting this article unless you have obtained permission.
- This is a translated article. Should you find any translation mistakes or content errors, please refer to the Original Article (Chinese), which takes precedence.
- Due to ongoing version iterations, the feature details and interface screenshots included in this article may not be updated in a timely manner, leading to potential discrepancies between the article content and the actual product. For the most accurate information, please refer to the features of the latest version.