Import Your HOA Spreadsheet

Upload your HOA spreadsheet — AI maps columns, extracts CC&R rules, and imports your community in one session. Free for up to 50 properties.

Start Free

Upload. Map. Extract. Live.

Import Your HOA Spreadsheet and Go Live in 15 Minutes

Every self-managed HOA board has the same collection: a spreadsheet with property addresses and dues amounts, a PDF of the CC&Rs that nobody has read in three years, and a logo file somewhere on someone’s laptop. That is the starting point. Most HOA software turns that into a six-week setup project with manual data entry, field-by-field configuration, and a support ticket every time something does not map correctly.

HomeHerald’s HOA software setup takes a different approach. Drag and drop your files --- CSV spreadsheets, PDF governing documents, and image logos --- into one upload screen. Google Gemini AI processes everything in parallel: CSV columns get mapped to properties and balances automatically, PDFs get OCR’d and their rules extracted, and images get analyzed for logo detection. You review the results, approve the import, and your community is live.

Fifteen minutes. One session. From spreadsheet chaos to a fully operational HOA with AI that already knows your rules.

[Start Free —>] [See How It Works —>]

No credit card required. No contracts.


Why HOA Software Setup Scares Off the Boards That Need It Most

The irony of HOA software is this: the boards that need it most --- small, self-managed communities drowning in spreadsheets --- are the ones most likely to give up during setup. Not because the software is bad. Because the onboarding is designed for management companies with dedicated staff, not volunteer board members with day jobs.

Setup should not be a second project

Most HOA platforms require weeks of setup. Enter each property manually. Type each resident’s name and email one at a time. Configure payment settings field by field. Upload documents and manually tag each one. By the time the board finishes setup, they have already spent more time on the software than the software will save them in the first month.

For a volunteer board president who signed up to improve the neighborhood --- not to become a database administrator --- this is a dealbreaker. The spreadsheet, for all its problems, at least works right now. A new software tool that requires 40 hours of setup does not.

Spreadsheets have no export path

HOA boards store years of data in spreadsheets. Property addresses, lot numbers, resident names, dues amounts, payment history, account balances. The problem: every spreadsheet is structured differently. One board uses “Address” and “Owner.” Another uses “Property Location” and “Homeowner Name.” A third has merged cells, color coding, and formulas that only the treasurer understands.

Most HOA software offers a CSV import. But the import requires exact column headers, a specific format, and manual mapping when headers do not match. One mismatched column means the entire import fails. The board spends an hour reformatting their spreadsheet to match what the software expects.

Governing documents need more than upload

Uploading a CC&R PDF to a document storage folder does not make it useful. The board still has to read the document to find rules. They still have to type those rules into the violation management system manually. The document sits in storage, and the AI features that could use it --- if only someone spent the time to extract every rule by hand --- remain empty.

Your HOA’s data is already organized. It just needs software smart enough to understand your format instead of forcing you to match its format.

[Start Free —>]


How HomeHerald Onboarding Works: AI Does the Data Entry

HomeHerald’s onboarding wizard is designed around one principle: your existing data is the starting point, not an obstacle. Upload what you have. The AI figures out the rest.

Step 1: Multi-file drag and drop

The onboarding screen accepts multiple files at once. Drag and drop your CSV spreadsheet (property and resident data), your PDF governing documents (CC&Rs, bylaws, rules), and your community logo (any image format). No file-by-file upload process. No switching between screens. Everything goes in at once.

Step 2: AI processes everything in parallel

A Cloud Function triggers parallel processing across all uploaded files simultaneously:

CSV files --- Google Gemini analyzes the column headers and sample data rows. It identifies which columns contain addresses, lot numbers, resident names, email addresses, phone numbers, dues amounts, and account balances. The AI does not require exact header names. “Property Location,” “Home Address,” “Street Address,” and “Addr” all map to the same field. The system presents its column mapping for your review.

PDF documents --- Each PDF goes through the same AI pipeline used in Document Management: complete OCR for scanned pages, auto-classification into six categories (BYLAWS, CC&R, RULES, POLICIES, MINUTES, OTHER), and rule mining that extracts individual enforceable rules with category, title, description, and suggested fine amount.

Image files --- The AI analyzes uploaded images for logo detection. If a community logo is identified, it is set as the community’s branding for the resident-facing app, notifications, and physical USPS letters.

All processing happens simultaneously. You do not wait for one file to finish before the next one starts.

Step 3: Review before anything is imported

Nothing is imported automatically. The onboarding wizard presents a comprehensive results screen:

  • Properties found --- the total count and a preview of parsed addresses with mapped data
  • Balance summary --- total outstanding balances detected across all properties
  • Documents classified --- each uploaded PDF with its auto-detected category and color badge
  • Rules extracted --- the number of enforceable rules mined from your governing documents, with previews
  • Amenities detected --- any amenity references found in your documents
  • Dues amount detected --- the recurring assessment amount if identified in your data

You review every mapping, every classification, and every extracted rule. Edit anything the AI got wrong. Approve what it got right. Then import.

Step 4: Batch import

Click import. Properties are created, balances are set, documents are stored and indexed, rules are saved to the community database, and your community logo is applied. The entire import runs as a batch operation. If your spreadsheet has 100 properties, all 100 are created in one pass.

Step 5: Your community is live

After import, Herald Chat can answer resident questions using your uploaded CC&Rs. Herald Shield can analyze violation complaints against your extracted rules. Residents can be invited via QR code or email. Your HOA is operational.


What Makes This HOA Software Setup Different From Every Other Import

Most HOA software offers a CSV import that requires exact column headers and fails when your data does not match. HomeHerald’s onboarding uses AI to understand your data, not the other way around.

AI column mapping that understands your spreadsheet

Google Gemini analyzes your CSV headers and sample rows to determine what each column contains. “Owner Name,” “Resident,” “Homeowner,” and “Name” all map to the same field. “Monthly Dues,” “Assessment,” “HOA Fee,” and “Amount Due” all map correctly. The AI does not need a template. It reads your spreadsheet as-is.

Address normalization

Different spreadsheets format addresses differently. “123 Main St” versus “123 Main Street.” “Apt 4B” versus “Unit 4B.” HomeHerald normalizes addresses during import so matching works consistently across the platform --- from payment recording to violation tracking to resident self-service property claiming.

Duplicate detection

If your spreadsheet contains duplicate properties (same address listed twice with different data), the AI flags them during the review step. You decide which entry to keep or how to merge them before import. No silent duplicates polluting your community data.

Property limit enforcement

Your plan’s property limit is enforced during import. If your CSV contains 150 properties and your plan supports 50, the system warns you before import. No surprise failures. No partial imports. You see the constraint before you commit.

PDF rule mining in the same session

Other platforms separate document upload from community setup. HomeHerald processes your CC&Rs during the same onboarding session as your property import. By the time your properties are created, your rules are already extracted and ready to power Herald Shield and Herald Chat. No second setup step.

Results review before anything goes live

Every onboarding decision is presented for human review before import. The AI suggests column mappings, document classifications, and rule extractions. You approve, edit, or reject each suggestion. Nothing goes into your community database without your confirmation.


Onboarding in Action: Real Setup Scenarios

Scenario 1: Self-managed HOA with a spreadsheet and a PDF

Board president Elena has a Google Sheets spreadsheet with 87 properties: address, lot number, owner name, email, phone, monthly dues amount, and current balance. She also has a 45-page CC&R PDF that was scanned from the original paper document in 2018.

Elena exports her spreadsheet as CSV, downloads her CC&R PDF, and drags both files into HomeHerald’s onboarding screen.

Processing (30 seconds):

  • The CSV AI maps all seven columns correctly. “Lot #” maps to lot number. “Monthly HOA” maps to dues amount. “Balance Owed” maps to current balance.
  • The CC&R PDF gets OCR processing (it is a scanned document), auto-classified as CC&R, and the AI extracts 52 enforceable rules with categories, titles, and fine amounts.

Review: Elena sees 87 properties with balances totaling $4,200 across 12 properties. The 52 rules are previewed with descriptions. She edits one rule where the AI misread a faded section number, approves everything else, and clicks import.

Result: 87 properties created, 52 rules saved, CC&R indexed for Herald Chat. Elena shares the community QR code in the next newsletter. Residents start joining and asking Herald Chat questions that afternoon.

Elena’s setup time: 12 minutes.

Scenario 2: New community starting from scratch

A newly formed 34-unit townhome community has no existing data. Board member Ryan has the developer’s CC&Rs (a clean digital PDF), a property list from the developer (an Excel file with 34 addresses and lot numbers), and the community logo.

Ryan exports the Excel file as CSV and uploads all three files. The AI maps the two CSV columns (address and lot number), classifies the CC&R, extracts 38 rules, and detects the logo. Ryan reviews and imports. The community is live before the first board meeting.

Ryan’s setup time: 8 minutes.

Scenario 3: Messy spreadsheet with inconsistent formatting

Treasurer Patricia inherited a spreadsheet from the previous treasurer. It has merged cells, color-coded rows, three empty columns, inconsistent address formatting (“123 Main St” and “123 Main Street” for the same property format style), and a “Notes” column with free-text comments.

Patricia exports to CSV (which strips the formatting) and uploads. The AI identifies the relevant columns, ignores the empty ones and the Notes column, normalizes the address formats, and flags two potential duplicate properties where the same address appears with different owner names. Patricia reviews: one is a genuine duplicate (data entry error), the other is a property that changed hands. She removes the duplicate and updates the second entry. Import proceeds cleanly.

Patricia’s setup time: 15 minutes (including duplicate resolution).


Other Platforms Make You Do the Data Entry. HomeHerald Does It for You.

Every HOA software platform offers some form of import. But “import” usually means “reformat your spreadsheet to match our exact template, then upload and hope it works.” HomeHerald’s AI-powered onboarding reads your data as it exists and maps it to the right fields automatically.

CapabilityHomeHerald OnboardingOther HOA Software
AI column mappingGemini reads headers and sample rows, maps automaticallyRequires exact column headers or manual mapping
Multi-file parallel processingCSV, PDF, and images all process simultaneouslyOne file type at a time, separate setup steps
PDF rule extraction during setupCC&Rs processed and rules mined in the same sessionDocument upload is separate from community setup
OCR for scanned documentsGemini vision converts scanned/printed text to searchable contentNo OCR, requires digital-native PDFs
Address normalizationHandles abbreviations, formatting differences, and typosExact text matching only
Duplicate detectionAI flags potential duplicates for review before importSilent duplicates or import failure
Results review before importEvery mapping and extraction presented for approvalImport-and-hope or manual field-by-field entry
Logo detectionAI identifies community logo from uploaded imagesManual logo upload in separate settings screen

If your community’s data lives in a spreadsheet and a filing cabinet, HomeHerald is the only platform that turns both into a fully operational HOA in one session.

[Start Free —>]


Onboarding Pricing

Onboarding and import are included on every HomeHerald plan. No setup fee. No import fee. No per-property charge for onboarding.

Free plan

  • Multi-file drag-and-drop upload (CSV, PDF, images)
  • AI column mapping for CSV imports
  • AI document processing: OCR, classification, and rule mining
  • Duplicate detection and address normalization
  • Up to 50 properties imported
  • Full results review before import
  • Great for communities setting up for the first time
  • Higher property limits for larger communities
  • Unlimited AI queries for Herald Chat and Herald Shield using your imported data
  • Full automation features available immediately after setup
  • Priority support during onboarding
  • All features activated on import

A free plan is available to get started. Setup and import are included on every plan at no additional cost. No credit card required. No contracts.


Frequently Asked Questions About HomeHerald Onboarding

What file formats does the import accept?

The onboarding wizard accepts CSV files for property and resident data, PDF documents for CC&Rs, bylaws, and other governing documents, and image files (JPG, PNG) for community logos. Word documents are also accepted for governing documents. Each file can be up to 50 MB.

Do I need to reformat my spreadsheet before importing?

No. That is the core advantage of AI-powered onboarding. Google Gemini reads your CSV headers and sample data rows to determine what each column contains. Whether your columns are labeled “Address,” “Property Location,” “Home Address,” or “Addr,” the AI maps them correctly. You review the mapping before import and can adjust anything the AI gets wrong.

How long does the import process take?

Processing time depends on file size. A typical CSV with 50 to 100 properties processes in under 15 seconds. PDF documents process in 30 to 60 seconds for standard digital files, and up to the full 300-second window for large scanned documents requiring OCR. All files process in parallel, so total processing time is determined by the largest file, not the sum of all files.

What happens if the AI maps a column incorrectly?

The results review screen shows every column mapping before import. If the AI maps “Lot #” to the wrong field, you can manually correct it with a dropdown selector. The import does not proceed until you approve the mapping. You are always in control of what gets imported.

Can I import from another HOA software platform?

If your current platform allows data export to CSV, you can import that CSV into HomeHerald. The AI column mapping handles different export formats without requiring you to reformat. Export your data, upload the CSV, and let the AI map the fields.

What if my CC&Rs are a scanned paper document?

HomeHerald’s AI performs complete OCR on scanned documents and images. A CC&R document scanned from paper in 2005 gets the same processing as a born-digital PDF from 2024: text extraction, section structure preservation, auto-classification, and rule mining. The quality of the scan affects OCR accuracy, but even moderately clear scans produce usable results.

Can I add more properties or documents after the initial setup?

Yes. The onboarding wizard is the initial setup flow, but you can add individual properties, upload additional documents, and import supplemental CSVs at any time from the Settings and Document Management sections. The AI processing is the same regardless of when you upload.

Is there a limit to how many properties I can import?

Your plan’s property limit applies during import. The free plan supports up to 50 properties. If your CSV contains more properties than your plan allows, the system warns you before import. You can upgrade your plan or select which properties to import within the limit.


HOA Software Setup Should Take Minutes, Not Weeks

Your community’s data already exists. It is in a spreadsheet, a PDF, and a logo file. The only thing standing between you and a fully operational HOA platform is the setup process --- and that process should take 15 minutes, not 15 days.

HomeHerald’s AI-powered onboarding reads your spreadsheet columns, extracts rules from your CC&Rs, and imports your entire community in one session. By the time you share the join code with your residents, Herald Chat already knows your rules, Herald Shield is ready to analyze complaints, and your board dashboard shows your entire community at a glance.

For communities currently running on spreadsheets, our guide on ditching the spreadsheet for your self-managed HOA explains why the switch matters. For a complete overview of what you can do after setup, see our beginner’s guide to HOA management.

[Start Free, Set Up in 15 Minutes —>]

Free plan available for up to 50 properties. AI-powered import included on every plan. No credit card required. No contracts.

Free for up to 50 properties

No credit card. No trial period. The Free plan includes Herald AI Chat, Pet Protect, Stripe payments, physical mail, and a mobile app.

  • 50 properties, 100 users
  • Herald AI Chat & Pet Protect
  • Native iOS + Android app

Ready to try HomeHerald?

Start free with up to 50 properties. No credit card required. No contracts. Set up your community in minutes.