SUMMARY
The discussion focuses on efficiently updating an address list for a non-profit organization, which contains approximately 11,000 entries dating from 3 to 40 years old. The data is currently stored in an Excel spreadsheet, originally created from index cards in 2002, and has been partially updated using the National Change of Address service, which only tracks changes from the last four years. The user seeks cost-effective methods or services to update addresses and verify the status of individuals on the list, particularly in preparation for the organization's anniversary.
PREREQUISITES
- Familiarity with Excel for data management
- Understanding of the National Change of Address service
- Basic knowledge of SQL for potential database queries
- Awareness of data verification services for address updates
NEXT STEPS
- Research bulk address verification services
- Explore SQL queries for updating and managing large datasets
- Investigate data cleaning tools compatible with Excel
- Learn about the implications of using public records for address updates
USEFUL FOR
This discussion is beneficial for non-profit administrators, data managers, and anyone involved in maintaining large contact lists or seeking efficient methods for data updates and verification.