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

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.
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.
| Symptom | Where it starts in the spreadsheet | What changes with an ERP |
|---|---|---|
| Double booking | Two 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 site | The 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 availability | Only 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:
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.
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.
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
| β | Item | Done when |
|---|---|---|
| β | Go-live date and owner set | Date shared with all of sales and back office. |
| β | Site spreadsheet cleaned | One row per site, no duplicates, with postal code, type, faces or screens and price. |
| β | Inventory imported | Active sites in the system equal the spreadsheet total. |
| β | Site records complete | Location, photos, audience and production costs filled in. |
| β | Lease contracts entered | Landlord and expiry dates on every site. |
| β | Clients and agencies in the CRM | All active clients and all with open proposals added. |
| β | Live bookings moved | Occupied faces per month match the spreadsheet. |
| β | Users and permissions | Everyone on the right profile, no shared logins. |
| β | Test proposal reviewed | Link opened outside the company, map, price and discount checked. |
| β | Spreadsheet frozen | File 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.
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.