Print labels from CSV Files on iPhone, iPad, or Mac
Barcode & Label is an app for designing labels, creating barcodes, and printing mailing addresses and envelopes. It allows you to print labels with data extracted from a CSV (Comma Separated Values) file easily. The screenshot below shows a sample.csv file in the expected format. It contains five rows of data plus a header row that defines the column names.
After importing the CSV file into the Barcode & Label app, we can easily print labels with data from any of the columns of the CSV file. The screenshot below illustrates the printing of the first few columns of the CSV file.
Mac
iPhone
The label design process involves first importing a CSV File followed by inserting columns from the CSV file into the label. This is described in detail below:
How to print labels from a CSV (Comma Separated Values) File? - Video Guide
Mac
iPhone/iPad
How to print labels with data from a CSV (Comma Separated Values) file? - Tutorial
1. Launch the Barcode & Label app on your iPhone or Mac and import a CSV file using the Data Source option. On Mac, tap the Drawer icon next to Settings. On iPhone, tap the Page button at the top-left corner of the screen, then select Data Source -> CSV -> Select to import a CSV file (e.g., the provided sample.csv).
2. To preview the imported CSV file, tap Data Source -> CSV -> View. This will display sample columns and rows from the file.
Mac
iPhone
3. Next, let us insert columns from the CSV file onto our label design. Tap on the "+" button at the bottom of the screen and add a Text object to the label.
- On Mac, simply tap on the Text object to select the obect and bring up its properties.
- On iPhone, tap on the "i" button and change the Text Type to "CSV Column: 01".
The first column in the CSV file is our Product ID. Tap the “+” button to add a second Text object to the label. Set its Text Type to CSV Column: 02. This will display the second column from the CSV file, which contains the Product Name.
Mac
iPhone
5. Tap the Preview button in the top-right corner to see how your labels will look. The preview will display data from the first few columns of your CSV file, showing how it will appear on the printed labels.
Mac
iPhone
When you save your label design, the associated CSV data is saved along with it. The next time you open the label, the data will be automatically available for printing.
If you need to update the data, tap Data Source → CSV → Select to choose a new CSV file. To remove the current CSV data, go to Data Source → CSV → View → Clear.
CSV File Format
The following provides an overview of the CSV File Format supported by Barcode & Label.
CSV File Format Notes
- Column Headers in the First Row.
- Up to 10 columns supported.
- Up to 500 rows supported (50 rows in the Free version).
- Comma (",") as column delimiters.
- Use quotes ("") to wrap columns with commas.
