If you rent out one to three condos and want to move vacation rental bookings from Excel to an app, typing the rows in again is the easy part. The real risk is the stay that never made it into the sheet: dates agreed in a WhatsApp chat, a note in a notebook or a platform booking someone forgot to copy. This guide shows you how to stop tracking bookings in Excel in six steps, without losing a reservation along the way. You’ll find the minimum columns your sheet should have before you migrate, the mistakes that come up most often and a hypothetical example.
This guide covers the switch itself. It won’t help you compare apps. If you’re still working out your daily routine, start with how to organize vacation rental bookings, and for reviewing incoming requests see the guide to direct booking requests.
Step 1: Collect every place a booking lives
Most owners think their bookings are in one spreadsheet. Usually they’re spread across several places. Before you transfer bookings from a spreadsheet to an app, list every source:
- The main spreadsheet, plus any older copy someone still opens.
- A paper notebook or diary.
- WhatsApp, Instagram or Facebook chats where dates were agreed.
- Emails with confirmations, deposits or changes.
- The calendars on Airbnb, Booking.com or any other platform you list on.
- Whatever your partner, cleaner or check-in helper remembers but never wrote down.
Go through each one and add any future stay that’s missing from the sheet. At this point the sheet doesn’t need to be tidy. It needs to be complete.
Step 2: Clean and standardize the sheet
Now give every row the same shape. Before you migrate, your sheet should have at least these columns:
- Condo: always written the same way, such as “Ocean 2B” rather than “2B” one day and “beach condo” the next.
- Check-in date and checkout date, in one format with the full year.
- Guest: a reference name.
- Contact: phone or email.
- Guests: number of people.
- Channel: direct, Airbnb, Booking.com or other.
- Status: request, confirmed or cancelled.
- Agreed amount and balance due.
- Notes: arrival time, special agreements.
Use one row per stay. A guest who comes twice gets two rows. Highlight empty cells and fill them in now, before you start entering anything. The sheet holds personal details, so share it only with people who need it and keep it out of group chats.
Step 3: Pick a cutover date
The cutover date is the day the app becomes your main record. Choose a quiet day with no arrivals and tell everyone who helps you. From that day on, every new booking goes into the app first. During the test period you also add it to the sheet.
Step 4: Enter future stays first, then useful history
Start with the stays that can still go wrong: the ones that haven’t happened yet. Enter confirmed stays first, then pending requests. Leave history for last, and only bring over what you’ll actually look up, such as returning guests or stays with an incident. Years of old rows you’ll never open can stay in the archived sheet.
Two things to keep in mind if you use Miresev:
- Plan on entering bookings by hand. Don’t count on uploading your Excel or CSV file. That’s another reason to clean the sheet in Step 2.
- Platform dates may arrive another way. On paid plans, Miresev imports booked dates from external calendars such as Airbnb and Booking.com through iCal links every 3 hours. It isn’t real time and it isn’t a direct API integration. You can also give each platform a Miresev calendar link showing your booked dates, and you can revoke it whenever you like. Only dates travel, not prices or messages. If you connect those calendars, don’t also retype the same platform stays by hand, or you may see them twice. The guide to Airbnb and Booking iCal sync explains what a calendar link carries.
Step 5: Run both records side by side for one or two weeks
For one or two weeks, keep both. Every day, or at least every other day, check:
- Is every future stay in the sheet also in the app, with the same dates?
- Is there anything in the app that isn’t in the sheet?
- Do the statuses match? A request should never show as confirmed.
- Do platform dates in the app match each platform’s own calendar?
- Did this week’s new bookings go into both records?
When something doesn’t match, fix it and write down why it happened. The reasons show you which habit still needs work.
Step 6: Retire the spreadsheet
After several days with no differences, stop updating the sheet. Rename it to something like “Bookings – archive, do not edit”, keep it read-only and tell everyone. Two live records are exactly what you were trying to get rid of. For keeping a single source of truth day to day, see how to set up an apartment booking calendar.
Common mistakes when you migrate vacation rental reservations
- Duplicates from copying: the same stay appears twice because it was in the sheet and in a chat, or because it came in through iCal and was also typed by hand.
- Mixed date formats: “03/04” could mean March 4 or April 3. Settle on one format before you start entering.
- Unconfirmed requests mixed with confirmed stays: an unanswered inquiry ends up blocking dates as if it were a booking, or a real booking gets treated as a maybe.
- Counting checkout as a booked night: decide whether checkout day is free for the next arrival and apply the same rule to every row.
- Cancellations still marked active: a cancelled stay nobody updated gets copied over as live.
- Switching in peak season: if you can, migrate during a week with few arrivals.
A hypothetical example: three condos, a notebook and a group chat
This example is fictional and only illustrates the process.
Andrea owns three small condos in a mountain town. Her mother keeps a paper notebook for the condo she manages, Andrea runs a spreadsheet for the other two, and both of them agree dates in a family WhatsApp group. One condo is also listed on a platform.
On a Sunday evening Andrea goes through the notebook and the group chat and finds three future stays missing from her sheet. While cleaning up the columns she finds the same couple entered twice, once by her and once by her mother, under slightly different names. She also changes one row from “confirmed” to “request” because the guest never answered her last message.
She picks a Wednesday with no arrivals as her cutover date and enters the next four months of stays first. She brings over history only for guests who have come back more than once. For twelve days she compares both records every night. On day five she spots a booking that only went into the notebook and adds it. Then she archives the sheet, retires the notebook and tells her mother that from now on there’s one place to check.
Where Miresev fits
Miresev’s free plan includes one active condo with its booking page, booking requests and guest registration. It doesn’t include the condo calendar, manual blocks, buffer nights, invoices or external calendars. Those come with paid plans, so check what each plan includes on the pricing page before you plan your migration around them. You can see the setup steps in how it works and what’s on offer for a first condo on the owners page.
Once your sheet is clean, you can create your Miresev account and start with your first condo’s booking page. To see what that page involves, read the guide to setting up a booking page for your condo.
Frequently asked questions
Can I upload my Excel file straight into Miresev?
Don’t count on it. Plan on entering bookings by hand, which is why it pays to clean the sheet first and enter future stays before anything else.
Do I need to move my whole booking history?
No. Future stays are what matter. From the history, keep only what you’ll look up, such as returning guests or stays with incidents. The old sheet can stay as a read-only archive.
How long should I keep the spreadsheet and the app running together?
One or two weeks is usually enough. Once you’ve gone several days without finding a difference, retire the sheet.
Will moving my bookings to an app stop double bookings?
Not completely. One record cuts down on mistakes, but dates imported through iCal update at intervals, so a booking can land between updates. Check availability right before you confirm.



