Consolidate Customer Data in Excel
Budget / SalaryHourly project
TypeFreelance project
LocationRemote
Posted52 minutes ago
I have multiple Excel workbooks filled with customer contact details—names, phone numbers, email addresses—alongside their sales and order history. I need these files merged into one master sheet that is tidy, consistently formatted, and free of clutter.
Here is what matters most to me:
• Combine every worksheet into a single, well-structured workbook.
• Identify duplicate customer records and keep only the most complete version of each record, discarding the rest.
• Retain both the contact information and the corresponding sales/order history so each customer’s activity remains intact.
• Apply clear, uniform column headers and date/phone/email formatting so the data is easy to filter or pivot in the future.
Deliverable:
A final Excel file (.xlsx) containing the consolidated, de-duplicated dataset, ready for immediate analysis. A brief “change log” sheet outlining any major cleaning actions you took (e.g., number of duplicates removed) would be appreciated.
Here is what matters most to me:
• Combine every worksheet into a single, well-structured workbook.
• Identify duplicate customer records and keep only the most complete version of each record, discarding the rest.
• Retain both the contact information and the corresponding sales/order history so each customer’s activity remains intact.
• Apply clear, uniform column headers and date/phone/email formatting so the data is easy to filter or pivot in the future.
Deliverable:
A final Excel file (.xlsx) containing the consolidated, de-duplicated dataset, ready for immediate analysis. A brief “change log” sheet outlining any major cleaning actions you took (e.g., number of duplicates removed) would be appreciated.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.