Required stack
필요 기술
ExceliPhoneiCloudCSVData AnalysisData IntegrationData Management
Project brief
프로젝트 내용
I need the full contact list from my iPhone exported into Excel, then merged with several spreadsheets I already maintain. All of my current files are organised strictly by name, so the import must follow the same convention and slot neatly into the existing alphabetised rows without creating duplicates.
Please extract every available field—first and last name, company, phone numbers, email addresses, and notes—and place them into clearly labelled columns. Once the raw export is complete, match each contact against my master workbook, append any new records, and update existing ones where fresher details are found.
Final deliverables:
• A standalone Excel file containing the clean, deduplicated contact export.
• My master workbook returned with all new data merged and names still in perfect A-Z order.
I’ll provide the current sheets as soon as we start and would like a quick turnaround, so familiarity with iCloud contact export tools, CSV handling, and Excel data-cleaning functions such as VLOOKUP or Power Query will help you finish smoothly.
Please extract every available field—first and last name, company, phone numbers, email addresses, and notes—and place them into clearly labelled columns. Once the raw export is complete, match each contact against my master workbook, append any new records, and update existing ones where fresher details are found.
Final deliverables:
• A standalone Excel file containing the clean, deduplicated contact export.
• My master workbook returned with all new data merged and names still in perfect A-Z order.
I’ll provide the current sheets as soon as we start and would like a quick turnaround, so familiarity with iCloud contact export tools, CSV handling, and Excel data-cleaning functions such as VLOOKUP or Power Query will help you finish smoothly.