Client Data Cleanup & Content Creation

My multifamily brokerage has client contact details scattered across emails, old spreadsheets, and CRM exports. I need help consolidating all of that information, scrubbing it for accuracy, and delivering a single, well-structured Excel/CSV file I can rely on going forward. The work starts with pulling every available record, removing duplicates, normalizing name, phone, and email formats, and flagging any gaps or obvious inaccuracies.

Once the clean database is in place, I’d like to keep the momentum going with a steady stream of content—market-update emails, brief blog posts, and property-focused social snippets that draw on the insights in the new dataset. If you’re comfortable moving seamlessly between data hygiene in Excel/CSV and light, brokerage-friendly content writing, this will turn into a long-term collaboration.

Deliverables
• Clean, deduplicated Excel/CSV file of client contact details
• Simple data dictionary or field key (so anyone on my team understands the columns)
• Ongoing monthly batch of short written pieces (newsletter blurbs, 300-word posts, etc.) once the database is finalized

Acceptance Criteria
• Zero duplicate emails or phone numbers in the final sheet
• Consistent formatting for names, phone numbers, and addresses
• Content pieces delivered in Word or Google Docs, proofread and ready to publish

If this mix of data work and content creation fits your skill set, let’s get started.