• User Guide For DoingLabel
• How to Choose the Right Label-Making Tool in DoingLabel?
• Label Generator
  • What Is the Label Generator?
  • Import Data
    • Overview of the [Import Data]
    • Import Excel / CVS Data
    • Create Blank Data in Bulk
    • Quickly Duplicate Row Data
    • Copy Row Data by Repeat Count
    • Copy Row Data by Split Code
    • Create the Running Number
    • Add Custom Text to the Start or End of Existing Text
    • Insert Text at a Specified Position
    • How to Sort the Data Table
    • Replace All of Specific Text
    • Find and Delete Duplicate Rows
    • Preview Individually or Automatically
    • Search Data in the Table
    • Specify Which Data Rows to Export
    • Extract Barcode Data from PDF
    • Extract QR Code Data from PDF
  • Edit Label
    • Overview of the [Edit Label]
    • Modify Label Size
    • Modify Label Properties
    • Component: Text(one line)
    • Component: Text(multi-line)
    • Component: Image
    • Component: Barcode
    • Component: Barcode (Simplified)
    • Component: Barcode (Deprecated)
    • Component: QR Code
    • Component: PDF417
    • Component：DataMatrix
    • Component：Line
    • Component：Icon
    • Component：UDI
    • Use Full-Screen Mode
    • Quickly Print the Label Preview
    • Copy the Label Preview
    • Use Label Templates
    • Adjust Barcode Size
    • Display Unique Images on Each Label
  • Export Labels
    • Overview of the [Export Labels]
    • Select Labels Export Method
    • View All Labels
    • Batch Print Labels (One label per page)
    • Double-Sided Printing for Each Label
    • Merge and Print Labels (Multiple labels on one page, fast layout)
    • Merge and Print Labels (Multiple labels on one page with a balanced grid layout)
    • Merge and Print Labels (Multiple labels on one page with adjustable size settings)
    • Export as a ZIP (One label per file)
    • Merge and Export as PDF (One label per page)
    • Merge and Export Labels (Multiple labels on one page with a balanced grid layout)
    • Merge and Export Labels (Multiple labels on one page with adjustable size settings)
    • Print the Label Preview
    • Download the Label Preview
    • Export the Label Table Data
• Batch Barcode Generator
  • What Is the Batch Barcode Generator
  • Import Data
    • Overview of the [Import Data]
    • Import Excel / CVS Data
    • Use Multi-Text to Import Data
    • Create Blank Data in Bulk
    • Copy the Barcode Text Column
    • Quickly Duplicate Row Data
    • Create the Running Number
    • Add Custom Text to the Start or End of Existing Text
    • Insert Text at a Specified Position
    • How to Sort the Data Table
    • Replace All of Specific Text
    • Find and Delete Duplicate Rows
    • Preview Barcodes Individually or Automatically
    • Correct Barcode Check Digits
    • Search for Data in the Table
    • Specify Which Data Rows to Export
  • Edit Barcode
    • Overview of the [Edit Barcode]
    • What Is the Barcode Footnote
    • What are the Barcode Add-texts
    • Edit a Barcode
    • Set Barcode Background to Transparent
    • Set Text Position: Footnote & Add-texts
    • Add-text Text Auto Wrap
    • Use FNC Function Codes
    • Set Font for Barcode Text
  • Export Barcodes
    • Overview of the [Export Barcodes]
    • Select Barcodes Export Method
    • View All Barcodes
    • Batch Print Barcodes (One barcode per page)
    • Merge and Print Barcodes (Multiple barcodes on one page, fast layout)
    • Merge and Print Barcodes (Multiple barcodes on one page with a balanced grid layout)
    • Merge and Print Barcodes (Multiple barcodes on one page with adjustable size settings)
    • Export as a ZIP (One barcode per file)
    • Merge and Export as PDF (One barcode per page)
    • Merge and Export Barcodes (Multiple barcodes on one page with a balanced grid layout)
    • Merge and Export Barcodes (Multiple barcodes on one page with adjustable size settings)
    • Batch Export Barcode Check Digits
    • Export Data from Import Data as Excel
• Batch QRCode Generator
  • What Is the Batch QR Code Generator
  • Import Data
    • Overview of the [Import Data]
    • Import Excel / CVS Data
    • Batch Import Data via Text
    • Create Blank Data in Bulk
    • Copy the QRCode Text Column
    • Quickly Duplicate Row Data
    • Create the Running Number
    • Add Custom Text to the Start or End of Existing Text
    • Insert Text at a Specified Position
    • How to Sort the Data Table
    • Replace All of Specific Text
    • Find and Delete Duplicate Rows
    • Preview QR Codes Individually or Automatically
    • Search for QR Code Data in the Table
    • Specify Which Data Rows to Export
  • Edit QR Code
    • What Is a QR Code Footnote
    • What Is a QR Code Center Logo
    • Set Transparent Background for QR Codes
    • Footnote Text Auto Wrap
    • Text Font for a QR Code
  • Export QR Codes
    • Overview of the [Export QR Codes]
    • Select QR Codes Export Method
    • View All QR Codes
    • Batch Print QR codes (One QR code per page)
    • Merge and Print QR codes (Multiple QR codes on one page, fast layout)
    • Merge and Print QR codes (Multiple QR codes on one page with a balanced grid layout)
    • Merge and Print QR codes (Multiple QR codes on one page with adjustable size settings)
    • Export as a ZIP (One qrcode per file)
    • Merge and Export as PDF (One qrcode per page)
    • Merge and Export QR Codes (Multiple qrcodes on one page with a balanced grid layout)
    • Merge and Export QR Codes (Multiple qr codes on one page with adjustable size settings)
    • Export the Table Data for QR Codes
• Single Barcode Generator
  • What Is the Single Barcode Generator
  • Select a Barcode Type
  • Set the Export Size
  • Set the Export Resolution
  • Set a Transparent Background
  • Enable FNC Functions
  • Export EAN/UPC SC-Size Barcode
  • Export a Vector PDF Document
• Single QRCcde Generator
  • What Is the Single QR Code Generator
  • Set the Export Size
  • Set the Export Resolution
  • Set the QR Code Center Logo
  • Set a Transparent Background
  • Rotate a QR Code
  • Export a Vector PDF
• Usage Tips
  • Label Generator
    • Specify File Names for Each Exported Label
  • Batch Barcode Generator
    • Barcode Text vs. Footnote: Displaying Different Text
    • Export or Print Barcodes in Reverse Order
    • Export Barcodes to Multi-Level Folders
  • Batch QRCode Generator
    • Export QR Codes to Multi-Level Folders
  • Split Large Volumes of Data into Batches for Label Export or Printing
  • How to Generate Running Numbers
• FAQ
  • Barcode
    • Barcode Unscannable? How to Fix It
    • What Does "Barcode type not match content" Mean?
    • How to Add FNC Function Codes to a Barcode?
    • Why Is the EAN-13 Check Digit Incorrect?
    • How to Resolve the Issue of Ink Spread on Barcodes During Printing?
  • Printing
    • How to Set Up Printing in Browsers?
    • How to Print with a Label Printer?
    • How to Fix Issues Like "Incomplete Printing" or "Misaligned Printing"?
    • How to Fix the Skipping Page Issue with Label Printer?
    • Why Can’t I Print? How to Fix It?
    • Content Truncated Around the Edges of Printed Paper? How to Fix It?
    • How to Hide Header(Title) & Footers(URL) for Web Printing?
    • How to Print/Export Labels in "Duplicate Multiple Copies"?
  • License Code
    • How DoingLabel Calculates Usage Volume
    • Why Isn’t the License Code Working?
    • How to Retrieve a License Code?
    • How Many Users or Devices Can Use One License Code?
    • Why Haven’t I Received the License Code Email?
  • Download Failed? Unable to Export?
  • Why Do Some Browsers Show No Response When "Download" Is Clicked?
  • Unable to Import or Upload Excel Files?
  • How to Convert an Excel File to CSV?
  • How to Set Excel Cell Format to "Text"?
  • How to Export Vector PDF Files?
  • Can Labels Created with DoingLabel Be Used for Commercial Purposes?
  • Font Copyright Notes
  • How to Use the Data Archiving Function?
  • How to Set the Save Path for Exported Files?
  • What are the five export file formats: Print, PNG, PDF, Vector PDF, and SVG?

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 only reads the first worksheet (Sheet 1).

If an import error occurs, it may be due to an incorrect file format or the file exceeding the maximum data limit. For details on how to resolve import errors, click Here to learn more.

Excel formula calculations are supported. Click to learn more about the notes and precautions.

• 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.