Workflow · Clean · Opening soon

Standardize addresses

Clean up mailing addresses in your Excel export. Apply USPS-style abbreviations, state codes, zip codes, and capitalization in one pass.

Book a demo

Someone typed

“standardize the mailing addresses: consistent street abbreviations, state codes, zip codes and capitalization”

The agent read it as

Standardize the mailing addresses in Customer Mailing Addresses for consistent street abbreviations, state codes, zip codes and capitalization, using USPS abbreviations.

What the agent built

1 step, each one an ordinary Mammoth step you can open and change.

File

Customer Mailing Addresses

CSV export · 15 rows

Step

Standardize address formatting

Step 1

Result

Standardized Mailing Addresses

15 rows

Schedule

Runs when you say

Proposed

File
Customer Mailing Addresses
CSV export · 15 rows
Step
Standardize address formatting
Step 1
Result
Standardized Mailing Addresses
15 rows
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 15 rows came out.

Download Customer Mailing Addresses sample (15 rows)Excel: File > Save As > CSV (sheet: Mailing_Addresses)

What you get back

The result of that run, the rows to look at first.

Standardized Mailing AddressesSample data15 rows

Customer ID	Customer name	Street address	City	State	ZIP code
cust_1001	Northwind Outfitters	128 E MARKET ST	MADISON	WI	53703
cust_1002	Briar & Co.	55 WESTLAKE AVE APT 4B	SEATTLE	WA	98109-4412
cust_1003	Summit Ledger Group	9 PINE RD	PORTLAND	OR	97205
cust_1004	Harborline Foods	4100 N 7TH ST STE 210	PHOENIX	AZ	85014
cust_1005	Blue Cedar Studio	77 KING ST	CHARLESTON	SC	29401-2003
cust_1006	Iron Orchard Supply	600 S BROADWAY BLVD	LOS ANGELES	CA	90013
cust_1007	Lumen Care Partners	2400 W CEDAR AVE	CHICAGO	IL	60622
cust_1008	Maple Ridge Retail	18 ELM ST	BOSTON	MA	02110
cust_1009	Evergreen Transit	9010 3RD AVE N	MINNEAPOLIS	MN	55401-1234
cust_1010	Cinderhouse Media	12 OAK CT	DALLAS	TX	75201
cust_1011	Pelican Bay Imports	3001 COASTAL HWY	WILMINGTON	DE	19801
cust_1012	Aurora Fabrication	1442 MOUNTAIN BLVD STE 5	DENVER	CO	80202

15 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How do you standardize mailing addresses?

Export your address list from Excel and upload the file. Mammoth standardizes the mailing addresses with consistent street abbreviations, state codes, zip codes, and capitalization. It then returns standardized mailing addresses you can review or export.

How it works

How to use the Standardized Mailing Addresses workflow

1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Standardized Mailing Addresses: questions

What export should I use from Excel?

Use the exported spreadsheet that contains the address columns you want to standardize. A flat file with one row per address works best.

What happens to rows that do not match an address pattern?

Rows that do not clearly match stay unchanged or are flagged for review, depending on the rule setup. You can check those rows before you use the result.

How do I change the address rules?

Edit the step in plain words, such as changing which parts should be standardized or how strict the matching should be. Then run the workflow again on the same export.