CSV TO PRODUCTION LABELS

# Your spreadsheet. Your customer’s label.

Take a works order from a CSV file to a label preview, with the customer’s product code, purchase order and batch in place.

[Download sample CSV](https://labels.smartfact.ai/examples/manufacturing.csv) [Discuss your data](https://labels.smartfact.ai/request-access?from=csv)

Using Excel? Export your sheet as CSV first. The current importer uses a defined manufacturing profile.

A customer label, resolved WORKED EXAMPLE

WORKS ORDER

**WO-12345**  

Customer: Acme Example

Internal product code: `INT-00017`

Customer product code: `AC-00017`

Quantity: 3 labels

 Customer code applied

![Rendered Acme label showing AC-00017, Outdoor bracket, purchase order PO-00981, batch B-0925 and a Code 128 barcode](https://labels.smartfact.ai/marketing/acme-example.png)

Fictional order data. Actual rendered preview. 100 × 150 mm · 203 dpi

FOLLOW THE EXAMPLE

## From INT-00017 to AC-00017.

The sample contains an order for three outdoor brackets. The product’s internal code is `INT-00017`. The configured customer mapping resolves it to `AC-00017` for Acme’s label.

The mapping is part of the saved configuration. It is not guessed from the spreadsheet.

[Open the example label PDF](https://labels.smartfact.ai/marketing/acme-example.pdf)

Selected fields from the complete sample CSV

| Field | Sample value |
| --- | --- |
| `job_reference` | WO-12345 |
| `customer_code` | ACME |
| `product_sku` | INT-00017 |
| `product_name` | Outdoor bracket |
| `quantity` | 3 |
| `purchase_order` | PO-00981 |
| `batch_code` | B-0925 |

The downloadable file contains all required columns. Every company, order and product in this example is fictional.

GET YOUR DATA READY

## Keep the important details.

- 01 
  
  ### Use the sample headings

  Match your export to the supplied manufacturing columns. Arbitrary spreadsheet column mapping and direct Excel workbook uploads are not available in this version.

- 02 
  
  ### Preserve codes as text

  Check leading zeros before exporting from Excel. A code that has already lost its zeros cannot be reconstructed reliably by the importer.

- 03 
  
  ### Review before printing

  The importer validates the complete file. Open the imported job, prepare the label and inspect the preview before accepting a print run.

A FEW PRACTICAL QUESTIONS

## Before you start.

**Can I upload an Excel file?**

Export a UTF-8 CSV from Excel first. The current importer accepts CSV using the documented manufacturing profile, rather than .xlsx files.

**Will any CSV file work?**

No. The required headings, types and identifiers must match the profile. Download the complete example and discuss your source data with us before planning an import.

**Does a CSV upload print immediately?**

No. Importing records the job data. Label preparation, preview review and acceptance are separate steps. Attended physical printing also requires a configured and checked QZ Tray workstation.

**Is this a GS1 or SSCC label generator?**

The current example uses a standard Code 128 barcode. GS1-128, SSCC allocation and regulated label workflows are outside this early-access profile.

KEEP EXPLORING

## The next part of your workflow.

### [Prepare your CSV data](https://labels.smartfact.ai/guides/prepare-csv-label-data)

Prepare a manufacturing CSV for label printing. Preserve leading zeros, check quantities and dates, and use the SmartFACT sample file as your starting point.

### [Customer-specific labels](https://labels.smartfact.ai/customer-specific-labels)

Use saved customer mappings to put the right product code on a production label. See how missing codes, label layouts and previews fit together.

### [Browser printing](https://labels.smartfact.ai/browser-label-printing)

See how SmartFACT Labels connects a browser workspace to an attended label printer through QZ Tray, with workstation setup and physical checks.

LET’S START WITH YOUR WORKFLOW

## Bring one label. We’ll start there.

Tell us about your data, customer requirements and printer. We’ll help you assess whether SmartFACT Labels fits.

 [Discuss your labels](https://labels.smartfact.ai/request-access?from=csv)