See where your hotel guests really come from, every month

If you run a small hotel or bed-and-breakfast, you probably already know your busiest months, your best-reviewed rooms, and roughly how many repeat guests you get. What you likely don't know — not with any real confidence — is where your guests are actually travelling from.

Your booking system can tell you a guest's billing address. It can print you a list of names and check-in dates. What it almost never does is turn that list into something you can *see* — a map showing whether last month's guests were mostly locals on a weekend break, families driving in from three hours away, or visitors flying in from out of state. That picture matters. It tells you where to spend your (probably small) marketing budget, whether that new highway billboard is doing anything, and whether the wedding party you hosted actually brought people from out of town or just relatives who live twenty minutes up the road.

Right now, most small properties either guess at this or pay for a marketing analytics tool built for chains with a hundred properties and a data team. Neither is a good fit for a ten-room inn.

The real cost of not knowing where guests come from

This isn't a dramatic problem. Nobody loses a booking because of it. But it quietly costs you in smaller ways, month after month:

• You keep spending on local social ads because it's easy, even though half your guests are already driving past you weekly.
• You can't tell your local tourism board or a co-op ad partner anything useful about your actual draw radius.
• When a slow season hits, you can't tell whether it's a local downturn or whether your longer-distance guests have simply stopped coming.
• You renew the same regional print ad every year out of habit, with no real evidence it reaches anyone who books.

None of these show up as a line item. They show up as marketing spend that doesn't quite pay for itself, and a nagging sense that you're guessing where a smarter operator would know.

What you actually have already

Here's the thing — you don't need new software to fix this. You already have the raw material. Every reservation system, from a spreadsheet you keep yourself to a proper property management system, can export a list of past guests with a mailing address or billing address attached. That's it. That's the whole ingredient list.

What's missing is a simple, cheap way to turn that list of addresses into map-ready locations — a latitude and longitude, a city, a distance from your front door — without hiring anyone or learning a new piece of software.

That's exactly what a monthly geocoding subscription does, and it's a much smaller job than it sounds.

How it works

Step 1: Export your guest list

Pull a simple export from your reservation system or spreadsheet — guest name (or booking ID, if you want to keep things anonymous), and their address. Most systems can do this in a couple of clicks. If you keep bookings in a spreadsheet already, you're basically done with this step.

Step 2: Upload the file

Upload that spreadsheet through CSV2GEO. There's nothing to configure and nothing to install — you're just handing over a file, the same way you'd attach one to an email.

Step 3: Let it run

The service reads every address in the list and works out its exact location — this covers over 504 million addresses across 63 countries, so whether your guests are coming from the next town over or from three countries away, it's covered.

Step 4: Download your results

You get back the same spreadsheet you uploaded, with new columns added: latitude, longitude, city, and distance from your property if you want it. Nothing is removed or reformatted — it's your file, just filled in.

Step 5: Drop it into a map or a simple chart

From there, you can paste it into any free mapping tool, or just sort it by distance and city in a normal spreadsheet to see the pattern immediately — which towns show up again and again, which states or regions barely register, and whether your "regional" reputation is actually regional at all.

What this actually gets you

Once you've done this a couple of months in a row, patterns show up fast. You might find that a surprising number of your guests are coming from one specific city two hours away — which tells you exactly where to spend on ads, rather than guessing. You might find your "destination wedding" bookings are mostly local guests attending a local wedding, which changes how you think about that segment entirely. You might find your slow season losses are concentrated in out-of-town guests, which points at travel patterns rather than anything you're doing wrong locally.

None of this requires a dashboard subscription or a marketing consultant. It requires a spreadsheet, once a month, run through a simple upload-and-download process.

The plan that fits a small property

A small hotel or B&B doesn't need enterprise-scale geocoding. You're not processing tens of thousands of rows a month — you're processing however many reservations you get, which for most independent properties is a few hundred to a couple of thousand.

The Plus plan at $29 a month covers up to 32,000 US addresses or 18,285 international addresses monthly, cancel anytime. For almost any independent hotel or B&B, that's far more headroom than you'll use in a typical month — which means you can run this guest-origin snapshot every single month, plus clean up your mailing list for a seasonal promotion, plus check a group booking's home addresses, all inside the same subscription. Subscribing this way also runs up to 30% cheaper than paying per address as you go, so there's no reason to hold back on using it regularly.

You can see the full set of plans, including smaller and larger tiers, at csv2geo.com/pricing.

Frequently Asked Questions

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. There's no software to install and nothing to learn beyond uploading a spreadsheet and downloading the result.

What happens if a guest's address is incomplete or messy? Most real-world address lists have a few of these — a missing zip code, a misspelled town, a P.O. box. The service does its best to match what it can and flags anything it genuinely can't place, so you're never left guessing which rows are trustworthy. If you want a deeper look at handling stubborn addresses, we've written a full guide on that separately.

Do I need a marketing background to make use of the results? No. Sorting a spreadsheet by city or distance is something anyone comfortable with basic spreadsheet use can do in a few minutes. You don't need charts or dashboards to see that forty guests came from one town and two came from another.

Is this only useful for marketing decisions? Not at all. Some properties use it to plan shuttle or local partnership arrangements, some use it to decide where to place print materials, and some just use it to answer the question "where do our guests actually come from" when a bank, investor, or tourism board asks.

Can I cancel if I only need this for a season? Yes. It's a monthly subscription with no lock-in — cancel anytime you don't need it, and start again whenever a new season or campaign calls for it.

Is my guest data safe if I upload it somewhere? Yes. You're uploading a file to process addresses into locations — nothing more is done with it, and you control the file the whole time, from export to upload to download.

What if my guest list changes size a lot month to month, like a seasonal property? That's fine. The Plus plan's 32,000-row US allowance is well above what most small properties need even in a peak month, and if you ever need more or less, you can move between plans as your season shifts.

The bigger picture

Chains do this kind of analysis as a matter of course — they have entire teams dedicated to guest origin data, drive-time analysis, and marketing attribution. Independent properties usually can't justify that overhead, so they skip the analysis entirely and market on instinct instead.

A $29-a-month subscription doesn't require a team. It requires an export you already know how to do, an upload that takes a minute, and a download that turns your guest list into something you can actually look at and understand. That's a fair trade for finally knowing where your guests are really coming from.

Related Articles

• Cutting undeliverable mail before it goes to print
• Mapping venues and vendors by drive time
• Geocoding without engineers: an ops guide
• The one-week geocoding pilot playbook
• Pitching geocoding spend to your CFO

---

*I.A. / CSV2GEO Creator*