The image is a visual

The image is a visual comparison of the customer-lead data before and after cleanup for TechNova Solutions.

Upper section: Messy data

The upper section shows the information exactly as it was collected from business cards and signup sheets. It contains inconsistent capitalization, different phone-number formats, duplicate entries, incomplete fields, and possible spelling variations. For example, “ravi kumar” and “RAVI KUMAR” represent the same person, while Farhan Ali appears twice with slightly different company and phone formatting.

Lower section: Organized and cleaned data

The lower section is the CRM-ready version. Duplicate leads have been removed, names and company names have been standardized, email addresses have been converted to lowercase, and phone numbers have been formatted using the +91-XXXXXXXXXX pattern. A new Status column has also been added.

Status

Meaning

Ready

The lead has the required email and phone information.

Needs Follow-up

Important information, such as an email address or phone number, is missing or incomplete.

The blank cells in the cleaned table are intentional. They indicate information that was not available in the original data; no details were invented. Overall, the image demonstrates how unstructured lead information can be transformed into a more consistent and usable CRM database.