Home Β· Blog Β· article

How to move from spreadsheets to an outdoor advertising ERP: step-by-step plan and checklist

Double bookings, forgotten sites and stale availability share the same root. How to move sites, clients and bookings into a system without stopping sales, and what changes when proposals go out with a map and an approval link

Β· Hivestr Β· 10 views

How to move from spreadsheets to an outdoor advertising ERP: step-by-step plan and checklist

Moving from a spreadsheet to an outdoor advertising ERP is scary for one simple reason: the spreadsheet is ugly, but it is where your company knows what has been sold. Nobody wants to switch tools in the middle of a two-week cycle and find out, when the crew goes to install the vinyl, that two clients bought the same face.

This guide is for OOH and DOOH media owners who have already decided to stop tracking billboards in a spreadsheet and want to know how to make the switch without stopping sales. You will see why spreadsheet bookings fail, what changes when proposals go out with a map and an approval link, an eight-step migration plan and a checklist you can print and tick off.

Still deciding?

If your question is still "do I really need a system?", start with our Portuguese-language article on the 9 signs your operation should already have migrated. This one starts where that one ends: on the day you decide to change.

Why spreadsheet billboard tracking breaks at booking

The spreadsheet does not fail on its own. The operation around it does: the salesperson who holds a site with a verbal promise, the copy saved on a rep's laptop, the monthly tab someone forgot to update. Three symptoms show up in almost every media owner that tracks availability this way.

SymptomWhere it starts in the spreadsheetWhat changes with an ERP
Double bookingTwo people check different versions of the file, or a verbal hold was never entered.The booking comes from the approved proposal and shows up on the calendar for the whole team at once.
Forgotten siteThe face is on the street but missing from the sales tab, or "occupied" by a campaign that already ended.Each site is a record with status (active, occupied), photos and location. What is not sold shows as available.
Stale availabilityOnly one person updates the file, and they have other jobs.Availability is a result of proposals and campaigns, not of someone remembering to color a cell.

This is not about picking on Excel. Researcher Raymond Panko, from the University of Hawaii, reviewed studies on spreadsheet errors and found they occur in a few percent of all cells. In a large spreadsheet, the question is not whether there is an error but how many. In later work he shows that spreadsheet developers tend to be overconfident about their accuracy.

Outside OOH, the closest thing to a double booking came from the London 2012 Games. Organizers sold 10,000 too many tickets for synchronised swimming. According to The Telegraph, the cause was a single keystroke: someone entered 20,000 remaining seats in a spreadsheet instead of 10,000. The case is in the incident archive of the European Spreadsheet Risks Interest Group. Swap "seat" for "face" and "session" for "two-week cycle" and you have every media owner's nightmare.

We have covered how double booking happens and what it costs and why the availability spreadsheet is OOH's invisible bottleneck (both in Portuguese). Here the focus is different: getting out of it.

The manual proposal is the other half of the problem

At most media owners, the availability spreadsheet feeds a proposal built by hand: check what is free, copy photos, paste addresses, calculate discounts and agency commission, export a PDF, send it on WhatsApp and wait. When the agency asks to swap two sites, the cycle starts again. And between sending and "deal", nobody holds the face safely, because the booking still depends on someone going back to the spreadsheet.

That is the window where double bookings happen: the site was offered to two clients, both said yes, and the spreadsheet only records whoever was entered first.

Migrating is not copying the spreadsheet into a system. It is making the booking come from the proposal, not from someone's memory.

What an outdoor advertising ERP changes in the proposal

At Hivestr, the ERP and CRM for OOH and DOOH media owners, the proposal is built from your own inventory and goes out as a link. In practice:

πŸ—ΊοΈ
Sites picked on the map
Reps add media in grid, map, radius or route views, with an "available only" filter and circuit filters. The client gets a media map with traffic, street and nearby-business layers.
πŸ”—
Approval link
The agency opens the proposal in a browser, sees photos, monthly investment and estimated reach and impressions, and clicks Confirm Campaign. The same link can be forwarded to the advertiser.
πŸ“Œ
Booking tied to the proposal
The proposal can hold OOH sites for 72 hours while the client decides. Bookings appear on the OOH booking calendar, with occupied, reserved and free by month.
πŸ‘€
You know when they opened it
The proposal switches to "Viewed" and shows views, visitors, device and location. Follow-ups stop being a guess.

Clients can also add sites through the "Expand your campaign" section and ask questions in the page's chat. For more on the format, see our guide on building an OOH proposal that closes deals (in Portuguese).

Step by step: migrating to a billboard management system

Order matters. Start with what is stable (sites), then what has an owner (clients), and only then what changes every day (bookings). That way you never enter a booking for a site that is not in the system yet.

1
Set a go-live date and an owner
Pick a date, ideally at the start of a two-week cycle, and one person in charge. From go-live on, availability is checked only in the system.
2
Clean the spreadsheet before importing
One row per site, standard names, address with postal code, type (OOH or DOOH), number of faces or screens, 30-day and two-week prices. Delete retired sites or mark them inactive. Imported junk is still junk.
3
Upload the inventory
Use Import/Export on the Sites screen for the bulk load, then fill in what the spreadsheet lacked: map location, photos, traffic direction of each face, production costs (vinyl, stickers, installation) and the audience profile, which is required.
4
Enter the site lease contracts
Each site's Documents step holds landlord, contract, permit and dates. For DOOH, the contract end date triggers reminders at 30, 15 and 0 days. No more leases that expire unnoticed.
5
Add clients and agencies to the CRM
Contact, email and phone for every active advertiser and agency, with the agreed commission. Start with clients who have a campaign live or a proposal open.
6
Move live bookings and check the count
Every live campaign and every future sale becomes an approved proposal in the system. Then compare: occupied faces per month in the spreadsheet must match the OOH booking calendar. Counting records in and out is the basic rule of any data transfer.
7
Invite the team with the right permissions
Use the Administrator, Manager, Employee and Viewer profiles. Sales reps do not need to see finance. Brazil's data protection law (LGPD, Law 13,709/2018, art. 46) requires measures to protect personal data from unauthorized access, and a shared contact spreadsheet is the opposite of that.
8
Send a first proposal and freeze the spreadsheet
Build a test proposal, open the link as if you were the agency and check map, prices and discounts. On go-live day, make the spreadsheet read-only and keep a dated copy. It becomes history, not a source.
Careful with "running in parallel"

Keeping spreadsheet and system both updated for weeks feels safe, but it recreates the problem you are trying to fix: two sources of availability. If you need a transition, set a few days of cross-checking with one clear rule: if they disagree, the system wins and someone fixes it right away.

A detail that catches many teams

In Hivestr, the public proposal link already works while the proposal is still a draft. That is handy for reviewing before sending, but a link copied too early reaches the client with provisional prices. Agree with the team: links go out only after review.

Migration checklist: from spreadsheet to ERP

☐ItemDone when
☐Go-live date and owner setDate shared with all of sales and back office.
☐Site spreadsheet cleanedOne row per site, no duplicates, with postal code, type, faces or screens and price.
☐Inventory importedActive sites in the system equal the spreadsheet total.
☐Site records completeLocation, photos, audience and production costs filled in.
☐Lease contracts enteredLandlord and expiry dates on every site.
☐Clients and agencies in the CRMAll active clients and all with open proposals added.
☐Live bookings movedOccupied faces per month match the spreadsheet.
☐Users and permissionsEveryone on the right profile, no shared logins.
☐Test proposal reviewedLink opened outside the company, map, price and discount checked.
☐Spreadsheet frozenFile read-only, with the date in its name.

The mistakes that slow migration down

Waiting for the perfect spreadsheet. Clean what blocks the import (duplicates, different names for the same site) and complete the rest in the system, site by site, with the team already using it.

Forgetting future sales. Migrating only what is live leaves holes in November and December, exactly when the calendar fills up. The March 2027 booking needs to be there too.

Not training reps. If they keep checking the old copy on their phone, double booking comes back. Show them the booking calendar and the proposal link in week one.

Migrating the old process too. If an exported PDF is still the main thing you send, you swapped the spreadsheet but not the sale. The gain is in the link: the agency approves without a phone call, and the booking follows the approval.

The spreadsheet got your company this far, and that deserves credit. But it was built to store numbers, not to hold a face while three reps negotiate at the same time. A well-run migration takes a few days of focused work and ends the question heard most often in sales: "is that site still available?"

FAQ about outdoor advertising ERPs

What is an outdoor advertising ERP?

It is management software built for OOH and DOOH media owners. It brings together site inventory, availability and bookings, CRM, proposals, campaigns (installation, proof of posting, removal), billing and invoicing. Unlike a generic ERP, it understands faces, booking cycles, insertion orders, agency commission and proof of posting.

Can I import my site spreadsheet?

Yes. Hivestr's Sites screen has an Import/Export function for bulk loads. Before that, standardize the spreadsheet with one row per site and check the accepted column template with support.

How long does it take to stop tracking billboards in a spreadsheet?

It depends on inventory size and how organized the spreadsheet is. The heavy part is not the import but completing records and moving future bookings. That is why the plan above starts with cleanup.

Should I keep the spreadsheet after migrating?

Keep a frozen copy as history, but do not update it. Two sources of availability are where double booking comes from.

How does billboard management software prevent double booking?

Availability comes from the proposals and campaigns on record. A proposal can hold OOH sites for 72 hours, approval through the link confirms the campaign, and the whole team sees the same status on the OOH booking calendar.

Does the agency need to install anything to approve?

No. The proposal is a link that opens in a browser, with map, line items, photos and investment. The agency confirms the campaign on the page and can forward the link to the advertiser.

Does it handle OOH and DOOH together?

Yes. Site records have separate forms for OOH (faces, traffic direction, production costs) and DOOH (screens, daily spots, quotas), and one proposal can mix both.

Hivestr

Leave the spreadsheet with bookings in the right place.

Hivestr is the ERP and CRM for OOH and DOOH media owners. Import your sites, send proposals with a map and an approval link and see the whole team's booking calendar. Try it free for 7 days, no credit card, or watch the video walkthrough first.

Try 7 days free β†’

Sources: Raymond R. Panko, What We Know About Spreadsheet Errors, Journal of End User Computing, 1998; Raymond R. Panko, What We Don't Know About Spreadsheet Errors Today, EuSpRIG, 2015; BBC News, London 2012: Olympic synchronised swimming tickets oversold (Jan 4, 2012); The Telegraph, synchronised swimming was overbooked by 10,000 (Jan 4, 2012); European Spreadsheet Risks Interest Group, Horror Stories (case FH1204); Law 13,709/2018 (LGPD), art. 46. Hivestr features checked on the platform in October 2026.

Your media company's whole operation

Inventory, proposals with online approval, CRM, campaigns, proof of posting and finance in one account. 7 days free to try.

Subscribe to the Hivestr newsletter

Get tips, OOH/DOOH industry news, and Hivestr content straight to your inbox.

No spam. Just tips, industry news, and Hivestr content. Unsubscribe anytime.

← Back to Blog