Import Builder/Guides/Buildium import errors
Property management

Buildium Import Errors and How to Fix Them

Buildium loads rentals and vendors from workbooks it publishes itself. These are the problems that shift columns, break lists and dates, split owners and properties, or leave sample data behind, and how to fix each one.

Buildium's import rules

Start from Buildium's own Rentals or Vendors workbook
Every asterisked column filled in
Column headings and order left as they are
Sub type, rent frequency, bedrooms and bathrooms worded as on the Lists sheet
Dates entered as real dates, postal codes as text
Account and bank names that exist in your Buildium
The sample rows removed

Where the file goes

The workbooks are on Buildium's Onboarding Templates page. Upload the completed file in Settings, under Import data, then Upload data file, and choose the type of data. The Rentals workbook carries the property, unit, tenant and owner in one row, so one upload covers them. For the order across record types, Buildium recommends properties first, then people, then financial transactions.

Common errors and their fixes

The sample rows are still in the file

Cause: Both workbooks come with sample data: the Rentals sheet has a sample unit at 10 School Street, and the Vendors sheet has rows labelled (Sample), such as (Sample) John Smith.

Fix: Replace or delete the sample rows before you upload, so no made-up vendor, tenant or owner is loaded.

Values land one column across

Cause: The workbook's columns are in a fixed order. Pasting a CSV along with its own header row, or from a file with columns reordered or removed, shifts every value into the wrong column.

Fix: Paste the data rows only, starting under Buildium's headings, from a CSV that has the same columns in the same order.

A required column is blank

Cause: Twelve columns on the Rentals sheet carry an asterisk: property name, unit number, sub type, operating bank account, property address line 1, unit address line 1, city, state, postal code, tenant first and last name, and rental owner name. On the Vendors sheet only the vendor name does.

Fix: Fill in every asterisked column on every row. Buildium also marks the tenant's first and last name as required, so a vacant unit has no place on this sheet: check how Buildium wants vacant units added before you list them.

Sub type isn't on Buildium's list

Cause: The Lists sheet allows Single-Family, Multi-Family, Condo/Townhome, Industrial, Office, Retail, Shopping center, Storage and Parking space. SFH, Duplex or Apartment are not on it.

Fix: Use the list's wording exactly, and map each of your own property types to the closest one.

Bedrooms and bathrooms as plain numbers

Cause: The lists are worded, not numeric: Studio, 1 Bed to 9 Bed+, and 1 Bath, 1.5 Bath and so on up to 5 Bath and 5+ Bath. A 2 or a 2.5 on its own doesn't match them.

Fix: Write 2 Bed and 2.5 Bath, or leave both blank, since they are optional.

Rent frequency in your own words

Cause: Rent frequency is one of Monthly, Daily, Weekly, Every two weeks, Every two months or Quarterly. Bi-weekly, Biweekly and Every 2 weeks are not on the list.

Fix: Use the list's wording, and leave the column empty for a unit with no rent charge.

Dates turn into text or the wrong day

Cause: The sample row holds real Excel dates. A date pasted as text, or read in another country's order, can come out as the wrong day or not as a date at all: 03/04/2026 is 4 March in one country and 3 April in another.

Fix: Enter lease start and end, next due dates and agreement dates as MM/DD/YYYY, and format those cells as dates in the workbook. See the date formatting guide.

Postal codes lose their leading zero

Cause: The sample postal code is 01234. A spreadsheet reads it as a number and shows 1234, which no longer matches the address. The Vendors sample also shows a ZIP+4 written as 50323 - 1234.

Fix: Format the postal code columns as text before pasting, and write ZIP codes the same way throughout. See leading zeros in CSV files.

Accounts that don't exist in your Buildium

Cause: The Operating bank account, Rent Account, Default Expense Account and Category columns name things set up in your own Buildium account. The Lists sheet shows the standard income accounts, such as Rent Income and Late Fee Income, but yours can differ.

Fix: Copy the account names from your Buildium account exactly, including capitals and punctuation, and create a missing account in Buildium first.

One owner, two spellings

Cause: The rental owner is given by name on every unit row, and Buildium links properties to an owner by matching that name, according to its help. Mike Kelley and Mike Kelly, or Kelley Properties LLC and Kelley Properties, can leave you with two owners.

Fix: Spell each owner the same way on every row. The whitespace guide covers stray spaces that make names differ.

One building typed two ways

Cause: 10 School Street and 10 School St. on different units of the same building look like two properties to anything that matches on text.

Fix: Use one property name and one property address on every unit of the building, and check the first import for a split.

Emails and phone numbers in cells meant for one

Cause: The login email columns hold one address, and the phone columns one number. Two emails separated by a comma, or a number with a note after it, may not be read.

Fix: One email address and one phone number per cell. Put anything extra in the Comments column.

The upload is checked and refused

Cause: According to Buildium's help, the file is validated before anything is imported, the errors are listed, and the Import button appears once validation passes.

Fix: Open the error report, fix each row in your own file, and upload it again instead of changing records by hand afterwards.

Tax IDs and dates of birth in the wrong hands

Cause: Both workbooks have columns for a tax payer ID (TIN) and the Rentals sheet has dates of birth for tenants and owners. A filled-in workbook emailed around carries that data with it.

Fix: Collect those columns only if you need them, and don't send filled-in workbooks by email. An Import Builder form checks and validates in the browser, so the file only goes where you send it.

After uploading

Buildium warns that an import can't be undone, so check the file before you confirm it. Fix any rows Buildium reports in your own file and upload it again, rather than editing records by hand, so the file stays the record of what you loaded.

Open the first few properties in Buildium and compare them with the sheet: the owner, the bank account, each rent charge and the lease dates. A shifted column or a misspelt owner shows up there before it spreads across a whole portfolio.

Checklist before you upload

Sample rows deleted
Data pasted without the CSV's header row, in the workbook's column order
Every asterisked column filled in
Sub types, frequencies, bedrooms and bathrooms as on the Lists sheet
Dates as real dates, postal codes as text
Bank, income and expense accounts match your Buildium account
Each owner and property spelled one way
One email and one phone number per cell
Tax IDs and dates of birth only where needed

Collecting units, tenants or vendors from several sources?

Send each owner or site manager a form instead of a spreadsheet. The Buildium rentals template follows the Rentals workbook's column order and checks sub types, rent frequencies and dates as they are typed. For contractors, the Buildium vendors template flags repeated names. Switching from another system? Read the data migration guide.

Try the rentals template

Import Builder is an independent product and is not affiliated with, endorsed by, or sponsored by Buildium. Buildium is a trademark of its owner. Import rules as shown in Buildium's published Rentals and Vendors templates, November 2026.