How to change supporters’ address format?
US-based organizations can control how supporter mailing addresses are formatted. You can choose whether addresses are saved in Proper Case or ALL CAPS.
Please note that changing this setting will not alter the format of existing data. The new format will only apply to addresses from donations received after the setting change. The selected case format will only affect addresses in the United States and its territories, and only those entered in English.
How to change the address format
Before selecting an address format, address validation must be enabled.
- Open Dashboard → Settings → Supporters
- Locate the Supporter mailing address section
- Enable Validate mailing address, if it’s not already enabled
- Choose one of the following options:
- First letter of each word capitalized
- All letters capitalized
- Save changes
Updating existing addresses
This setting does not retroactively update previously collected addresses. To reformat existing data, export your supporter records and apply formatting in a spreadsheet.
For example, in Microsoft Excel, you can use the =PROPER() formula to convert text to proper case. Microsoft provides a helpful guide on how this function works.
Related articles
This guide explains how to update a supporter’s email address and outlines important rules that apply to supporter records.
Important Notes
A supporter’s email address is their unique identifier in Fundraise