CSV Import

CSV files are a universal format supported by almost every database and spreadsheet application. They are lightweight and ideal for transferring data to SheetsToLabels.

What is a CSV?

A CSV (Comma Separated Values) file is a plain text file where data is separated by commas.

Name,Email,Department
John Doe,[email protected],Sales
Jane Smith,[email protected],Marketing

Preparing Your CSV

1. Encoding: Save your file with UTF-8 Encoding. This is critical for displaying special characters, accents, or emojis correctly.
2. Headers: Ensure the first line contains your column names.
3. Delimiters: We strictly support comma (,) delimiters. If your region uses semicolons (;) by default (common in Europe), please check your export settings or convert the file.

Image Placeholder: [Screenshot of "Save As CSV UTF-8" dialog in Excel]

How to Import

1. Navigate to the Data Source tab in the Label Designer.
2. Click Upload.
3. Select your .csv file.

Why Use CSV?

• Compatibility: Works with data exported from Shopify, QuickBooks, Salesforce, and custom databases.
• Speed: CSV files upload faster than complex Excel workbooks.
• Simplicity: Removes formatting issues (fonts, colors, hidden columns) that might confuse importers.

Handling Special Characters

If you see weird symbols (like ) instead of your text:

• Your file is likely not UTF-8.
• Fix: Open the CSV in Notepad (Windows) or TextEdit (Mac), select "Save As", and choose "UTF-8" from the encoding dropdown.

Exporting CSV from Other Apps

• Shopify: Products -> Export -> Select "All products" -> CSV for Excel.
• Google Contacts: More -> Export -> Google CSV.
• Outlook: File -> Open & Export -> Import/Export -> Export to a file -> Comma Separated Values.