Google Sheets/Excel Specialist for Data

Google Sheets/Excel Specialist for Data Cleanup & Automation – Commercial Real Estate
Job Description:
I’m looking for an experienced Google Sheets or Excel specialist to clean, organize, and automate a commercial real estate lead list. This dataset includes property addresses, owner names, and multiple phone numbers, often duplicated due to shared numbers (like main office lines).
Tasks include:
Remove all rows with entirely blank phone numbers.
Identify and eliminate duplicate phone numbers across multiple columns (keep one unique entry).
Provide clear reporting on key metrics, including:
Total unique properties
Total unique contacts
Count of mobile vs. non-mobile phone lines
Final count of unique phone numbers ready for dialer use
Create a centralized Master Log Sheet to track cleaned datasets, including timestamps and source file names.
Develop a dashboard panel summarizing these metrics clearly at the top of each cleaned file.
Set up a reusable automation template, macro, or script for future data uploads.
Provide clear documentation (SOP) and a Loom video walkthrough demonstrating your process and how to use the automation independently.
Preferred Tools:Google Sheets or Excel (explain your recommendation clearly).
Timeline:This is urgent, with a deadline by Tuesday, 5/27/25. Sooner delivery is highly valued.
Application Requirements:
Briefly describe your step-by-step approach to this task.
Specify which platform you recommend (Google Sheets or Excel) and why.
Provide your total project cost or estimated hours.
I’m looking to move quickly, minimize back-and-forth, and establish a reliable working relationship for ongoing projects. If you understand clearly and can meet the timeline, I’d love to work with you.
 ... Show more