Importing Data into SheetsToLabels — Google Sheets, Excel & CSV Guide
Learn how to connect Google Sheets, upload Excel (.xlsx) files, or import CSV data into SheetsToLabels. Includes merge field syntax, data best practices, and privacy information.
SheetsToLabels is designed around spreadsheet-driven label work. Start with the data source you already have, then use merge fields and dynamic text templates to place row values into your label design.
Supported Formats
Google Sheets
Connect your Google account to access your sheets directly.
- Benefits: Live connection means if you update your Google Sheet, you can just click "Refresh" in SheetsToLabels to get the latest data without re-uploading.
Microsoft Excel (.xlsx, .xls)
The industry standard. We support multiple sheets - you will be asked to select which sheet to use after upload.
CSV (Comma Separated Values)
A universal text format. Ensure your CSV is UTF-8 encoded if it contains special characters (like accents or emojis).
Data Best Practices
1. Header Row
Make sure the first row of your file contains meaningful headers.
- Good:
First Name,Last Name,Street Address,Zip Code - Bad:
Column A,Data 1,Untitled
These headers become the column names you use in your design, such as {{First Name}}, SKU: {{sku}}, or ${{price}}.
2. Clean Data
- Remove empty rows before upload to avoid generating blank labels.
- Ensure consistent formatting (e.g., all phone numbers in the same format) for the best visual result.
3. Images in Data
If you want to customize images per label (e.g., a different photo for each ID badge), put the Image URL in a column.
- Column Content:
https://example.com/photos/employee1.jpg - In Designer: Add an Image element and bind its source to this column.
Privacy & Security
Your data is processed securely. We do not store your spreadsheet data permanently unless you explicitly save a project to your account. You have full ownership of your data.