Library Member Data Management

I need help tidying up and maintaining our library’s member records. The work is entirely focused on personal-detail fields—specifically each member’s name and postal address. You’ll take raw sign-up sheets (PDF and occasional handwriting scans), enter the information accurately into our master spreadsheet, and ensure the data stays consistent with our existing format.

I’ll share the current Google Sheets file, a brief style guide for capitalisation and abbreviations, and a small batch of test records so you can demonstrate your approach. Once the format is confirmed, the remaining data—about 1,200 entries—can be completed in bulk.

Deliverables
• Updated Google Sheet with all member names and addresses correctly entered, de-duplicated, and alphabetically sorted.
• A short change log noting any illegible entries or duplicates you encountered.

Acceptance criteria
• 100 % of supplied records appear in the sheet.
• Zero empty required fields (name or address).
• No duplicate rows (checked via conditional formatting or similar).

If you are comfortable working quickly in Google Sheets or Excel, have a sharp eye for detail, and can turn this around within a week, I’d love to collaborate.