How to Import Data from Excel to a CRM and Automate Your Marketing Campaigns

You just came back from Alimentaria, Hispack, or any industry trade show with 300 business cards in a bag and an Excel file full of names, emails, and scribbled notes. You have 48 hours before those contacts go cold. What do you do? Most exhibitors dump the data into a spreadsheet, send a generic email, and lose 90% of the opportunities. Salesly offers an alternative: import those contacts in 5 minutes and launch automated follow-up campaigns from day one.

Table of Contents

• The problem: trade show contacts dying in a spreadsheet
• Step 1: Prepare your Excel before importing
• Step 2: Import contacts into Salesly in 5 minutes
• Step 3: Segment contacts by interest and urgency
• Step 4: Launch automated follow-up campaigns
• Real example: post-Alimentaria follow-up in 3 days
• Mistakes to avoid when importing trade show contacts
• From Excel to pipeline: the leap your team needs
• FAQ

Key Takeaways

Point	Details
Window of opportunity	80% of trade show leads are lost if not contacted within the first 72 hours
Import time	Salesly imports CSV/Excel files with up to 10,000 contacts in under 5 minutes
Response rate	Automated post-trade show follow-up campaigns achieve 35-45% open rates, vs 15% for generic mass emails
Trade show ROI	Companies with structured follow-up recover 3x more of their booth investment

The problem: trade show contacts dying in a spreadsheet

Every year, thousands of businesses invest between €3,000 and €30,000 in trade show booths at events like Alimentaria, Hispack, FITUR, or Smart City Expo. They collect hundreds of contacts — business cards, badge scans, tablet forms — and pile them into a shared Excel file. So far, so good.

The problem starts on Monday morning. The sales rep has 50 new contacts plus 30 open opportunities from before the show. Without a system that prioritizes and automates, follow-up becomes manual, slow, and inconsistent. Two weeks later, the spreadsheet is still there, but the contacts are already talking to your competitors.

Key fact: According to CEIR (Center for Exhibition Industry Research), 79% of trade show visitors make purchasing decisions within 6 months — but only if they receive relevant and timely follow-up.

Step 1: Prepare your Excel before importing

Before uploading data to Salesly, spend 15 minutes cleaning your spreadsheet. It doesn’t need to be perfect, just consistent:

1. One row per contact: No merged cells or notes in extra rows.
2. Standard columns: Name, company, email, phone, job title, notes. Salesly auto-maps the most common columns.
3. Source field: Add an “Origin” column with the value “Alimentaria 2026” (or the relevant trade show). This lets you filter and measure ROI later.
4. Remove duplicates: If you scanned the same card twice, delete one. Salesly also detects duplicates during import, but it’s cleaner to do it beforehand.
5. Save as CSV or XLSX: Both formats are supported.

Pro tip: If you collect data with a card scanning app (CamCard, ABBYY), export directly to CSV. Data quality is better than manual transcription.

Step 2: Import contacts into Salesly in 5 minutes

The import process in Salesly is designed so any sales rep can do it without technical help:

1. Go to Contacts > Import in the Salesly dashboard.
2. Upload your file (CSV or XLSX). Salesly detects columns automatically.
3. Map the fields: The system suggests matches (Name → name, Email → email). Review and adjust if needed.
4. Assign tags: Label all imported contacts with the trade show tag (e.g., “Alimentaria-2026”). This is essential for later campaigns.
5. Confirm the import: Salesly validates emails, detects duplicates, and shows a summary before confirming.

In under 5 minutes, your 300 trade show contacts are in the CRM — tagged and ready to work. No copy-paste, no transcription errors.

Step 3: Segment contacts by interest and urgency

Not all trade show contacts are equal. Someone who requested a demo at your booth is not the same as someone who stopped by to grab a pen. Salesly lets you segment during import or right after:

• Hot: Requested a demo, a quote, or mentioned a specific project. These go directly into the sales pipeline as active opportunities.
• Warm: Showed general interest, asked questions, left their card. They receive an automated nurturing sequence.
• Cold: General networking contacts. They go to a marketing list for periodic content.

This segmentation is the difference between sending a generic email to 300 people and sending the right message to each group. Conversion rates multiply by 3.

Step 4: Launch automated follow-up campaigns

With contacts imported and segmented, Salesly lets you create follow-up sequences that run on autopilot:

For hot contacts (first 24-48h)

• Email 1 (day 0): “Thanks for visiting us at Alimentaria. Here’s a summary of what we discussed + link to a personalized demo.”
• Auto-task (day 2): A task is created for the assigned sales rep to call the contact.
• Email 2 (day 5): Relevant case study for their industry + meeting proposal.

For warm contacts (first week)

• Email 1 (day 1): “Great meeting you at Alimentaria. Here’s our guide on [relevant topic].”
• Email 2 (day 7): Webinar or value-add content invitation.
• Email 3 (day 14): Direct question: “Do you have a sales challenge we could help with?”

For cold contacts (monthly)

• Added to the monthly newsletter with industry content.

Real result: A food distributor using Salesly after Alimentaria 2025 converted 23 out of 180 trade show contacts into customers in 4 months — a 12.7% conversion rate, compared to the usual 2-3% with manual follow-up.

Real example: post-Alimentaria follow-up in 3 days

Here’s a practical step-by-step case:

Day 0 (Friday, last day of the show):

• The team exports 245 contacts from their scanning app to CSV.
• They import to Salesly in 4 minutes. Tags: “Alimentaria-2026”.
• Classification: 38 hot, 92 warm, 115 cold.

Day 1 (Saturday):

• The automatic sequence sends the first personalized email to the 38 hot contacts.
• Open rate: 67%. Three reply requesting a meeting.

Day 3 (Monday):

• The Salesly pipeline shows 38 new opportunities with estimated value.
• The sales rep has a list of 12 priority calls (contacts who opened the email but didn’t reply).
• Warm contacts received their first nurturing email on Sunday.
• The sales director sees in Salesly’s analytics the total pipeline value generated by the show: €87,000.

Without Salesly, that Monday the team would be opening an Excel file trying to remember who each rep talked to.

Mistakes to avoid when importing trade show contacts

Waiting too long. Every day that passes, the response rate drops 10%. Import the data the same day or, at most, the next day.

Not segmenting. Sending the same email to someone who requested a demo and someone who walked past your booth for 2 seconds doesn’t work. The first expects a proposal; the second doesn’t even remember your brand.

Importing dirty data. Misspelled emails, duplicate names, empty fields. Spend 15 minutes cleaning the Excel before importing. Salesly detects errors, but prevention is more efficient than correction.

Not measuring ROI. If you don’t tag contacts by trade show, you’ll never know how many customers you generated at Alimentaria vs. Hispack. The source tag is mandatory.

Forgetting GDPR. Trade show contacts must have given consent to receive commercial communications. Make sure you have a legal basis (legitimate interest or explicit consent) before launching campaigns.

From Excel to pipeline: the leap your team needs

Trade shows are the biggest lead generation investment for many SMBs. But without a system that turns business cards into opportunities and opportunities into sales, that investment fades. Salesly lets you go from an Excel file with 300 names to an organized pipeline with automated campaigns in less than an hour.

If your team is exhibiting at Alimentaria 2026 (or just did), book a free Salesly demo and see how to turn trade show contacts into real customers — before they go cold.

FAQ

Can I import contacts into Salesly from any Excel format?

Yes. Salesly accepts CSV, XLS, and XLSX files. The system automatically detects columns and lets you map each field (name, email, phone, company, job title). If your file has different column names, you can assign them manually in the mapping step. Import supports up to 10,000 contacts per file.

How do I avoid importing duplicate contacts?

Salesly automatically compares new contacts against existing ones using email as the primary identifier. If it detects a duplicate, it gives you three options: skip the contact, update the existing record with new data, or create a new record. This prevents the same contact from appearing twice in your pipeline.

Do the automated campaigns comply with GDPR?

Salesly includes GDPR compliance tools: consent management, automatic unsubscribe link in every email, and legal basis tracking per contact. For trade show contacts, the most common legal basis is legitimate interest (business relationship initiated at the event). Still, it’s recommended to include an explicit consent checkbox on your booth’s capture form.

How long does it take to set up a follow-up sequence?

Creating a 3-email sequence with automated tasks in Salesly takes 15 to 30 minutes. Salesly provides pre-built templates for post-trade show follow-up, quote follow-up, and inactive contact reactivation. Once created, the sequence triggers automatically for each new contact matching the segmentation criteria.

Does Salesly integrate with business card scanning apps?

Yes. You can export contacts from apps like CamCard, ABBYY Business Card Reader, or HubSpot Card Scanner to CSV, then import that file directly into Salesly. Field mapping is automatic for the most common formats. For trade shows with official badge scanning systems, the file provided by the organizer is also compatible.