How to merge address fields into a single address column
- Step 1Export the contact or customer CSV — Download from your CRM, store, or mailing tool.
- Step 2Drop into CSV Column Merger — Select Address Line 1, Address Line 2, City, State, and Postcode columns.
- Step 3Set the separator — Choose comma-space for standard address format, or match your destination system's expectation.
- Step 4Download the updated CSV — The merged address column is appended. Remove the original columns if needed.
Frequently asked questions
Can I skip blank address lines in the merge?+
Yes. Enable the skip-blank option to avoid double separators when Address Line 2 is empty.
Will the original address columns be deleted?+
No. The merged column is appended. Remove the originals manually or with the Column Remover tool afterwards.
What separator should I use for Google Ads or Meta audience uploads?+
Check the platform's documentation. Most accept comma-separated or pipe-separated full addresses.
Privacy first
Processing runs locally in your browser with PapaParse. No file is uploaded — only metadata counters are saved for signed-in dashboard stats.