Turn address cleanup into a recurring service line for your clients

If you freelance in data or analytics, you've almost certainly had this conversation. A client sends over a spreadsheet — a customer list, a mailing list, a set of job sites — and somewhere in the middle of the "real" work, you notice the addresses are a mess. Half of them are missing zip codes. Some are duplicated with slightly different spellings. A few are clearly typos that would never make it onto a map.

You quietly fix what you can, mention it in passing, and move on to the analysis they actually asked for. It's the kind of unpaid, invisible work that eats an hour here and an hour there and never shows up on an invoice.

Here's the reframe: that unpaid hour is a service. Clients pay for clean, usable location data all the time — they just don't know to ask for it, because nobody has ever offered it to them as its own thing. If you're already doing the work for free, you're one small step away from turning it into a recurring line item that pays you every month.

The problem you're already solving for free

Almost every client you work with has address data somewhere — customers, leads, job sites, donors, subscribers, delivery stops. And almost none of it is clean enough to map, route, or analyze by location without some work first.

The issues are always the same shape:

• Addresses typed by hand, by different people, over years
• Missing or wrong zip codes
• City names misspelled or abbreviated differently across rows
• No consistent way to tell if two rows are actually the same place
• No latitude and longitude at all, which means no maps, no distance calculations, no territory analysis

Right now, when a client hits this wall, they either pay you to fix it manually (slow, and hard to price fairly for you), or they just give up on doing anything spatial with the data at all. Both outcomes leave money on the table — theirs and yours.

What it costs them today

Ask any client with a customer list what happens when the addresses are wrong, and you'll hear some version of the same three costs.

Wasted spend. Mail goes to addresses that don't exist anymore, or exist but were entered wrong. Marketing lists get used for territory or radius analysis that quietly excludes or duplicates real customers because the underlying locations are off.

Wasted time. Someone — often the client, sometimes you — is manually looking up addresses one at a time to check them, or manually correcting the same ten misspellings every month because nobody fixed the source data.

Missed insight. The client wants to know where their customers actually are, which territories are underserved, which regions are worth expanding into — and none of it is possible until the address list has real, usable coordinates behind it. The data sits there, unused, because getting it "map-ready" always felt like a bigger job than anyone had time for.

You've probably noticed all three of these on client projects. The fix isn't complicated. It's just been manual, which is why nobody's built it into a standing engagement yet.

The service, in plain terms

Here's what you're actually offering: every month (or on whatever cadence makes sense), the client sends you their current address list. You run it through a process that checks each address, corrects what it can, and adds exact map coordinates to every row that's usable. You send back a clean spreadsheet — same format they gave you, just complete and ready to use in a map, a mailing list, a customer database, or a spreadsheet formula that measures distance between two points.

That's it. No dashboards, no new software for the client to learn, no change to how they already work. They keep using spreadsheets. You just make sure the spreadsheet is right.

The tool doing the actual lookup work is CSV2GEO — a subscription built for exactly this kind of recurring, spreadsheet-in, spreadsheet-out job. You upload the client's file, it checks every address and adds the location data, and you get a finished file back. Nothing about it requires you to know anything about maps or programming — if you can open a spreadsheet, you can run the whole process yourself.

What it costs you — and what you can charge

This is the part that makes the math work. The Lite plan on CSV2GEO is $19 a month and covers up to 21,000 US rows (or 12,000 international rows) every month, no matter how many client files you run through it in that period. Most freelance analysts serving a handful of small business clients will use a small fraction of that allowance — a typical client list of a few hundred to a few thousand customer or lead addresses barely registers against a 21,000-row cap.

That means you can offer address cleanup as a $50, $75, or $100 monthly add-on to two, three, or more clients, all running through the same $19 subscription, without ever hitting a usage limit. The subscription is the cost of goods; everything above it is margin. And because it's a monthly plan you can cancel any time, there's no risk in testing it with your first client before you build it into your standard offer.

Compare that to pay-as-you-go pricing, which runs $0.0015 per US row with no subscription — the Lite plan effectively pays for itself once you're processing more than about 12,700 rows total across all clients in a month, and subscribing generally saves up to 30% versus paying per row anyway. For a freelancer running this as a repeat service, the subscription is the obvious choice.

How it works, month to month

Step 1: Ask the client for their current list

At the start of the cycle, request their latest export — customers, leads, job sites, whatever the list is. Most small business tools (spreadsheets, simple customer databases, invoicing software) can export a list as a plain spreadsheet file in a couple of clicks. You don't need it perfect. That's the whole point.

Step 2: Upload the file to CSV2GEO

Log in, upload the spreadsheet, and confirm which column holds the address. The system checks each row, matches it against a database of over 504 million addresses across 63 countries, and works out the exact location for every address it can confidently identify.

Step 3: Review what came back flagged

Not every address will match cleanly — that's normal, not a failure. You'll get a finished file with clear coordinates for the addresses that worked, and clear markers on the handful that didn't. Skim those flagged rows; usually it's a typo, a missing unit number, or an address that's simply out of date.

Step 4: Send the clean file back

Deliver the finished spreadsheet in the same format the client is used to seeing, with the new location columns added. No new software, no login for them to learn, no change to their workflow — just a better version of the file they already use.

Step 5: Repeat on your chosen cadence

Set a recurring calendar reminder — monthly is typical, though some clients only need this quarterly. Each cycle takes a fraction of the time it did the first time, because you already know the client's data quirks and the process itself never changes.

Making it a real offer, not a favour

The shift from "I fixed this for free" to "I offer this as a service" is mostly about naming it. Put a line in your proposal or your existing retainer: address verification and geocoding, refreshed monthly, delivered as a clean spreadsheet. Clients who mail things, route things, or map things will recognize the value immediately — most of them have been quietly frustrated by bad address data for years and never knew there was a simple fix.

If you're not sure how to price the add-on, start conservative. A client with a few hundred rows a month is a light lift for you; charge accordingly, and raise the rate for larger or messier lists. The subscription cost stays flat regardless, so your margin only improves as you take on more clients.

FAQ

Is this hard to set up if I'm not techy at all? No. If you can attach a file to an email, you can use this. You upload a spreadsheet and download a finished one — there's no software installation, no coding, and no technical setup involved.

What happens if a client's address is messy, incomplete, or just wrong? The system does its best to match messy or incomplete addresses and will flag anything it can't confidently resolve. You review those flagged rows, make a quick correction if needed, and re-run just that portion. It's rare that more than a small handful of rows in any list need manual attention.

How much client data can I actually run through the $19 plan? The Lite plan covers 21,000 US rows a month (12,000 international). For most freelancers serving a few small business clients, that's well beyond what any single month's workload needs, which is why it works so well as the base cost for a service you resell.

Can I cancel if I stop needing it for a month? Yes. It's a standard monthly subscription with no lock-in — cancel any time you don't need it, and resubscribe when the next client cycle starts.

Is client data safe going through this process? The file you upload is used only to add location data to the addresses you provide, and you control what happens to it after you download your results. You're not handing client data to a third party they've never heard of — you're using a tool the same way you'd use any other spreadsheet software.

Do I need to tell my clients what tool I'm using? No. From their side, they see a spreadsheet go out and a better spreadsheet come back. What you use to do the work is entirely up to you, the same as any other part of your process.

What if a client's list grows past the plan's row limit? CSV2GEO has larger plans — Plus, Starter, Pro, and Business — that scale up as your combined client volume grows. You can move up a tier whenever it makes sense rather than needing to plan for maximum volume from day one.

The takeaway

You're already doing this work. The only thing missing is the invoice line. A $19 monthly subscription is a low enough cost that you can test this as a real service offer with your very first client this month, price it with real margin, and repeat it every cycle without adding meaningful work to your plate.

Related Articles

• Cleaning client mailing lists as a monthly service
• Startup guide: from free tier to your first paid plan
• Mapping leads and customers without enterprise CRM tools
• The real cost of running your own geocoder
• Pitching geocoding spend to your CFO

--- *I.A. / CSV2GEO Creator*