Heeeey lemlister! 👋
Want to nail your CSV imports and streamline your email campaigns? With this step-by-step guide, you'll learn how to format your files, import leads seamlessly, and troubleshoot common issues. Let’s get started! 🚀
What You’ll Learn
👉 How to format your CSV for lemlist
👉 How to import leads from a CSV file
👉 How to fix CSV import problems
✅ How to Format Your CSV File
Formatting your CSV correctly is the first step to a successful import. Here’s what to do:
Your file can include as many columns as you want.
The first row must contain column names (e.g.,
email,firstname,city).Avoid spaces in column names, especially for URLs.
💡 Pro Tip: Download this CSV template to use as a guide for formatting your files.
✅ How to Import Leads from a CSV File
Follow these steps to import leads into lemlist:
1. Go to the Leads List
In your campaign, navigate to the Leads List section and select "Import from CSV."
2. Upload Your CSV
Browse your computer or drag and drop your
.CSVfile.Click Continue to proceed.
3. Map Your Variables
Each column name becomes a custom variable. lemlist automatically maps common fields like
email,firstname, andlastname.
For unrecognized columns, manually map them or create Custom Variables for unique data (e.g.,
City,Blog).
💡 Best Practices for Mapping Variables:
Use lemlist’s default variables when possible:
email,firstname,lastname, etc.Ensure URLs don’t have spaces in their column names.
Include as many custom variables as needed for personalization.
These are lemlist default variables:
email
firstname
lastname
picture
phone
linkedinUrl
companyName
companyDomain
icebreaker
4. Set Import Preferences
Choose to skip leads already in other campaigns.
Select enrichment options for additional data insights.
✅ How to Fix CSV Import Issues
If your CSV won’t upload, check the following:
🔹 Browser Compatibility: Use Chrome or another updated browser instead of Safari.
🔹 File Format: Ensure your file is a pure .CSV and not an Excel CSV. Convert if necessary.
🔹 Emails Are Required: Every row must have an email address, as it serves as the unique ID in lemlist.
🔹 Field Matching: Map your CSV fields to the appropriate lemlist variables.
FAQs for Smooth Imports
1. Can I use custom variables?
Yes! Add unique data for personalization (e.g., blog URLs or company info). lemlist supports unlimited custom variables.
2. What’s the best way to avoid import errors?
Use the CSV template as a guide.
Test your import with a small file first.
3. Why isn’t my CSV importing?
Double-check the format: pure
.CSVonly.Ensure column names match lemlist variables.
Verify your browser and file compatibility.
Pro Tips for Efficient CSV Imports
💡 Ensure the first row in your file contains column names.
💡 Use meaningful names for custom variables to simplify mapping.
💡 Keep your file clean and organized to avoid errors.