How do you get all your data out of AppFolio (and other property management tools)?
Short answer: AppFolio, a property management platform for rent, leasing, maintenance and accounting, exports one report at a time. Open a report such as the Rent Roll, set its filters and columns, click Update, then choose Actions and Export as CSV, which opens in Excel. AppFolio says it offers secure export so you can organize your data outside the system, but its pricing and product pages describe no single "export everything" button. If you need all of it, ask AppFolio in writing what it will hand over, or use the API on its Plus or Max plan.
You want your tenant, lease and money data out of your property management software, either to build better reports or to be ready if you ever move.
I'm Ranjit, and I run Blur Studio: 15+ years building software, 120 apps taken live, and clients who have gone on to raise $10M+. I build AI systems and processes that help businesses do a lot more with a lot less time. I also work differently from most of what else is out there, more on that further down this page. Say hello.
What can you export from AppFolio?
AppFolio's accounting and reporting page says it offers "secure export functionality to organize your data outside AppFolio." In daily use that means reports. Each report is a saved view of your data, such as the Rent Roll (units, tenants, rent and lease dates), the Unit Directory or the Tenant Directory. You export the view, not the database. For what AppFolio connects to, see AppFolio integrations.
That is enough for most jobs: sending an owner a spreadsheet, feeding a dashboard, or giving your accountant a year of ledgers. It is not the same as a full copy of everything, and I will come back to that gap below.
How do you export an AppFolio report to Excel or CSV?
The steps below come from a help guide written by RentCheck, a rental inspection software company that imports AppFolio data. Button names can change between versions, so treat this as the usual path and check it in your account.
- Go to the Reports page and find the report you want. The Unit Directory sits under Property and Unit Reports. The Tenant Directory sits under Tenant Reports.
- Set the Filters. For a list of current units, choose "Show Active Units".
- Pick your Columns, for example bedrooms, unit address, city, state and zip.
- Set Grouping. "Do not group rows" gives you a flat table that is easiest to use in Excel.
- Click Update so the screen shows what you set.
- Select Actions at the top of the screen, then Export as CSV.
CSV means comma separated values: a plain text file that Excel, Google Sheets and most other tools open directly.
Using Report Builder to get the columns you want
Report Builder is AppFolio's tool for making custom reports. AppFolio's own blog describes starting from a base report such as a Rent Roll, adding fields from elsewhere in the system, such as a resident's phone number and email, and then exporting or saving the result. Do that once, save it, and you will not rebuild it every month.
AppFolio's pricing page does not name Report Builder in any plan, so ask your rep which plan includes it. My guide to AppFolio reports goes into what the built-in reports cover and where they run short.
What a report export does not give you
- It is a snapshot. A file you export on the 3rd is wrong by the 4th.
- It is one view at a time. Leases, ledgers, owner statements and work orders each come from different reports.
- It does not copy documents on its own. Signed leases and photos are not rows in a spreadsheet.
- It is manual. Someone has to remember to do it.
For automation, the live route is an API, which is a way for one program to ask another for data. AppFolio's pricing page lists a read-only API on Plus (from $3.20 per unit per month) and a read and write API on Max (from $5.00), as of November 2026, with minimum spend applying. Core, from $1.49, does not list one. For a plain explanation of what that gets you, see my guide to the property management API.
AppFolio also describes an Excel Connection Add-in, but its announcement is for the Investment Manager product, which is a different product from the one property managers use. Do not assume it applies to you.
How to export from Rentec Direct
Rentec Direct is property management software for landlords and small managers, and it has the clearest public export help of the tools here. Its knowledge base says most downloads are CSV files. There are three routes:
- Ledgers. Open the ledger (tenant, property, owner or bank account), click the gear icon above it, and select Download.
- Reports. Click Reports, choose the report and its criteria, then click the PDF or CSV icon.
- Lists. Go to Settings, then Utilities (under Tools), then choose Download Active Property, Tenant, or Owner List.
If you keep books in QuickBooks, accounting software for small businesses, Rentec's help says you can run the Account Ledger B report under Accounting, download it as CSV, and use QuickBooks' import tool. That download is included with Rentec Pro and PM, not Starter. Rentec Pro and PM also include API access, which is the way to automate it.
Rentec's help page frames these downloads as a way to keep your own backup or use the data in other applications, and says you can also email a report from the report screen. That makes it a useful habit to copy: run the same downloads on a set day each month and file them by date.
Yardi Breeze and Zillow Rental Manager
Yardi Breeze is Yardi's property management software for smaller portfolios. Zillow Rental Manager is Zillow's tool for landlords who list rentals. Check each vendor's help center for the current export steps, then do three things:
- Open the report you need and look for an export icon or menu. Note the file formats it offers.
- Ask support, in writing, which reports and data types you can export and in what format.
- Do not use a browser add-on that scrapes pages for tenant data. It handles sensitive information and may break the vendor's terms.
Checklist: what to export before you do anything big
Whether you are building reports or planning a move, pull the same set:
- Rent roll and unit directory
- Tenant directory with lease start and end dates
- Tenant ledgers and the list of who owes what, including security deposit balances
- Owner list and owner statements
- Vendor list and open work orders
- General ledger and bank reconciliation reports for the last full year
- Signed leases and key documents, saved as files
Save each with the date in the file name, such as rent-roll-2026-11-12.csv. Keep them in a folder with limited access. They hold tenant names, phone numbers and money owed.
Worked example with made-up numbers
Say a 120-door firm sends 40 owners a monthly update. Today a staff member exports the Rent Roll, pastes it into an Excel template, fixes two columns and adds a comment. Suppose it takes 20 minutes an owner. That is 40 times 20 minutes, about 13 hours a month. If the same data came in through the API into a simple dashboard, the 13 hours turn into a few minutes of review. These numbers are invented, but the shape is real: the work is in the pasting, not the thinking.
What to do with the files
Open the CSV in Excel and check the basics: zip codes that lost a leading zero, dates read as text, and money in the wrong format. If you do this every week, you have outgrown the spreadsheet. I wrote about that step in moving a spreadsheet into a web app, and about the broader choice in build versus buy.
How I'd approach this
Most firms I talk to should stay on AppFolio. It is a strong system for the daily work, and a move is a big project. The gap is usually reporting, not the software.
So my order is this. First export the seven items on the checklist, once, so you have a safe copy. Second, save the two or three reports you rebuild by hand every month in Report Builder. Third, if you still repeat the same export every Monday, ask AppFolio whether your plan includes the API, then build a small reporting layer on top that refreshes itself. That layer keeps you on the software you already know and takes the copy and paste out of your week.
Questions people ask
How do I export from AppFolio to Excel?
Open a report on the Reports page, set the filters, columns and grouping, click Update, then choose Actions and Export as CSV. Excel opens CSV files directly. Menu names can vary, so check them in your account.
Can I export all my data from AppFolio at once?
AppFolio's pricing and product pages describe export of data you choose, report by report, and an API on Plus and Max. They do not describe a single export of everything. If you plan to leave, ask AppFolio in writing what it will provide and in what format.
Can I export Rentec Direct data to Excel?
Yes. Rentec Direct's help says ledgers, reports and lists of active properties, tenants and owners download as CSV files that open in Excel or Google Sheets. See also my comparison of property management APIs if you want to automate it.
Can I schedule an AppFolio export?
A scheduling option may exist inside Report Builder on your account, but AppFolio's public pages do not describe it, so check with your rep. The dependable way to automate is the API on Plus (read only) or Max (read and write).
Can I export Yardi Breeze data?
Ask Yardi support which reports and data types you can export and in which file formats, and ask for it in writing. Open the report you need and look for an export option.
Is it safe to keep exported tenant data in a spreadsheet?
Only if you treat it like the original. The files hold names, contact details and balances. Keep them in a folder with limited access, delete old copies and never email them in plain attachments. Check your state's rules or ask a local attorney if you are unsure what you must protect.
More in this topic: US property management: APIs and integrations (11 guides) →
Sources
- AppFolio accounting and reporting
- AppFolio pricing
- AppFolio blog: customizing your reports with Report Builder
- AppFolio: Revamped Reporting and Excel Connection Add-in (Investment Manager)
- RentCheck: downloading units and residents from AppFolio
- Rentec Direct: how to download data from your account
- Rentec Direct: download data then import into QuickBooks
- Rentec Direct pricing
- Rentec Direct API v3 documentation