INTL
Freelancer
보통
외주
원격 가능
iPhone Contacts to Excel Merge
예산
$600~$1,500 INR
예상 기간
1주 이내
난이도
보통
기술 스택
Excel
iPhone
iCloud
CSV
Data Analysis
Data Integration
Data Management
AI 분석 요약
iPhone 연락처를 Excel로 추출하고, 기존 Excel 스프레드시트와 병합하여 데이터를 업데이트하는 프로젝트입니다. 추출된 연락처는 중복 없이 완벽한 A-Z 순서를 유지해야 하며, 마스터 워크북에 새로운 기록을 추가하고 기존 기록을 최신 정보로 갱신해야 합니다. iCloud 연락처 내보내기 도구, CSV 처리, Excel 데이터 정리 함수(VLOOKUP, Power Query) 활용 능력이 중요합니다.
프로젝트 원문 설명
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.
Freelancer에서 원본 확인
원본 보기