Why a unit didn't come through

The unit is on the sheet, but you can’t find it in UnitBook. There are four reasons, and they’re quick to tell apart.

On the sheet

12 Elm St #4B22,400

One row, as the manager left it

What happens to itWhere you look

• Lands in your listingsNeeds review, waiting on youNeeds review tab
• DelistedA status word, a hidden row, or a red or pink fillDelisted tab
• Import issueBad address, or text in a number columnSources page
• Skipped quietlyBlank row, a repeated header, or a section headingNowhere

Four things can happen to a row on the sheet, and each one sends you somewhere different.

1. It’s there, you’re just not looking in the right place

Check this first. It’s the answer more often than the other three put together.

Clear your filters and search for the address in the All tab rather than Needs review. Then check the Delisted tab. If you find it there, see reason 3 below.

2. UnitBook couldn’t read the row

Open Sources and look at the card for that sheet. Rows that couldn’t be read show under Import issues, with the reason.

It’s nearly always one of three things:

• The address cell is empty
• The address and the unit number disagree, like 12 Elm St #4B in one column and 2C in another
• A number column has words in it, like “call for price”

Fix the cell in the spreadsheet, then click Sync now. If the row isn’t really a unit, like a parking space, dismiss the issue so the warning goes away.

3. The sheet says it isn’t available

UnitBook takes a unit down when the sheet suggests it’s no longer available. A word like rented, pending or coming soon anywhere in the row will do it, and so will a heading above the row saying something similar. So will hiding the row, or shading it red or pink.

The one that catches people out is a hidden row. Unhide everything and the sheet looks complete, but UnitBook read it the way the manager left it.

If a unit was already rented the first time it ever appeared on the sheet, UnitBook doesn’t create a listing at all. It’ll turn up on its own once the manager marks it available.

4. It isn’t a unit

UnitBook skips rows that aren’t units: blank rows, headings, section labels, parking spaces and notes. It does this quietly, so you’re not buried in warnings.

If a real unit is being skipped, its address cell usually doesn’t look like an address, perhaps a nickname or a building name with no street. Ask the manager to put a proper street address in it.

Still can’t find it?

Two things to check.

The tab. Reimport the sheet and look at the row count. A sheet pointed at last year’s tab will keep working perfectly and show you nothing new.

The last check. The card on the Sources page shows when UnitBook last looked. If it’s paused, start it again, or click Sync now.

If the row is there, readable, and marked available, and the unit still isn’t in UnitBook, email the link to the sheet and the unit’s address to support@unitbook.app.