The file arrives as a CSV, which every spreadsheet and CRM can read. A few minutes of preparation before you import saves hours of clean-up later.
1. Open it in a spreadsheet first
Open the CSV in Excel or Google Sheets and look at the header row. Our file uses plain names such as Agent name, Email, Brokerage / office, Office address, City, State, ZIP, Parish, Office phone, Mobile phone, License type, License number, Association and Fax. Write down which CRM field each one should go into.
2. Keep phone numbers and ZIP codes as text
Spreadsheets like to turn ZIP codes and long numbers into numbers, which can drop leading zeros or switch to scientific notation. In Excel, use Data › From Text/CSV and set those columns to Text, rather than double-clicking the file. Louisiana ZIP codes start with 70 or 71, so you will rarely lose a leading zero, but phone numbers can still be reformatted.
3. Decide what to do with shared office emails
Some small brokerages use one address for several agents. If your CRM treats email as the unique key, those agents can merge into a single contact. Decide in advance whether you want one contact per person or per address.
4. Load your suppression list first
If you have emailed agents before, import your unsubscribes and bounces before the new file, and set your platform to block them. That way no one who opted out is added back by accident.
5. Tag the source and date
Add a tag such as “LAEstateList, Nov 2026, St. Tammany” to every imported contact. When replies come in, you will know which list and which area they came from, and you can compare parishes.
6. Use the extra columns
- Parish: segment campaigns by market, for example Northshore and South Shore.
- Association: group agents by local board, which follows market areas closely.
- License type: separate brokers from salespeople where it is on file, which helps when recruiting.
7. Warm up before a big send
New lists and new sending domains should start small. Send to a few hundred contacts, watch bounces and complaints, then increase. The outreach guide covers this in more detail.