Exporting Your Data
Your financial data is YOURS. HOB makes it easy to export everything - transactions, budgets, accounts - as CSV files. Use them for backup, analysis in Excel, or migration to another tool. This guide shows you how.
What You Can Export
HOB lets you export all your financial data in standard CSV format that works with any spreadsheet program.
📝 Transactions
All your transaction history - date, amount, category, account, description, type
📊 Budget Data
Budget amounts by month and category - what you planned to spend vs what you actually spent
🏦 Accounts
Account names, types, balances, and status (active/archived)
📁 Categories
Your category structure - names, types (income/expense), groups, and rollover settings
File format: All exports are CSV (Comma-Separated Values) files that open in Excel, Google Sheets, Numbers, or any spreadsheet program.
Exporting Transactions
This is the most common export - your complete transaction history.
To export transactions:
- Click Export in the navigation (or go to Settings → Export)
- Select Transactions
- Choose your date range (all time, last year, custom range)
- Optionally filter by specific accounts or categories
- Click Export Transactions
- Save the CSV file to your computer
📝 What's Included
Each transaction row contains:
- • Date
- • Account name
- • Category
- • Description
- • Amount
- • Type (Income/Expense/Transfer)
- • Transaction ID (for reference)
Exporting Budget Data
Export your budgets to analyze spending patterns or share with a financial advisor.
To export budget data:
- Go to Export
- Select Budget Data
- Choose the date range (which months to include)
- Click Export Budget Data
- Save the CSV file
What's included:
- Month and year
- Category name
- Budgeted amount
- Actual spending
- Difference (over/under)
- Rollover amounts
💡 Use Case
Perfect for creating custom charts in Excel showing your budget accuracy over time, or analyzing which categories you consistently over/under budget.
Exporting Accounts and Categories
Export your account structure and category organization for backup or documentation.
Accounts export includes:
- Account name
- Account type (Checking, Savings, Credit Card, Investment)
- Current balance
- Status (Active/Archived)
- Notes
Categories export includes:
- Category name
- Type (Income/Expense)
- Group (if assigned)
- Rollover enabled (Yes/No)
- Status (Active/Archived)
Opening CSV Files
Once you've exported, here's how to open and use your CSV files.
In Excel:
- Open Excel
- Go to File → Open
- Select your CSV file
- Excel automatically formats it as a spreadsheet
In Google Sheets:
- Go to Google Sheets
- Click File → Import
- Upload your CSV file
- Choose "Replace spreadsheet" or "Create new spreadsheet"
⚠️ Currency Formatting
Dollar amounts may import as plain numbers. Select the amount column and format it as currency to see dollar signs.
What to Do with Exports
Now that you have your data, here are some powerful ways to use it:
📊 Create Custom Charts
Use Excel's charting tools to visualize spending trends, income vs expenses over time, or category breakdowns HOB doesn't offer yet.
💾 Backup Your Data
Export all transactions and budgets once a quarter. Store the CSV files in Google Drive, Dropbox, or external hard drive. If something happens to your HOB account, you have everything.
🔍 Advanced Analysis
Use Excel pivot tables to slice and dice your data - spending by day of week, monthly averages by category, year-over-year comparisons.
🤝 Share with Professionals
Meeting with a financial advisor or accountant? Export your transactions and send them the CSV. Universal format, works anywhere.
📄 Tax Preparation
Export transactions for the tax year. Filter by tax-relevant categories (charitable donations, business expenses, medical). Give to your tax preparer.
🔄 Migration
Switching to another budgeting tool? Export everything from HOB. Many tools can import CSV files, making migration easy.
Tips for Working with Exported Data
Keep your exports organized:
Create a folder structure like "HOB Exports/2026/Transactions" so you can find old exports easily.
Export regularly for backup:
Set a quarterly reminder to export all transactions and save to cloud storage. Think of it as backing up your financial history.
Use filters to get exactly what you need:
Don't export everything if you only need specific data. Use date ranges and category filters to create focused exports.
Clean up in Excel if needed:
You can delete columns you don't need, sort by any field, or add calculated columns (like "Days Since Transaction" or custom categories).
✅ Best Practice
At the end of each year, export all transactions for that year. This creates a permanent archive of your financial history that you control.
Privacy and Security
Your exported files contain sensitive financial information. Here's how to keep them safe:
Storage recommendations:
- Cloud storage: Google Drive, Dropbox, iCloud - encrypted and backed up automatically
- External drive: Keep a copy on an external hard drive stored securely
- Password-protected: If emailing to yourself or advisor, password-protect the file or use a secure file sharing service
What NOT to do:
- ❌ Don't leave files in your Downloads folder indefinitely
- ❌ Don't email unencrypted CSVs to public email addresses
- ❌ Don't store on shared/public computers
- ❌ Don't share via unsecured file sharing sites
🔒 Remember
These CSV files contain your complete financial history - account names, amounts, merchants. Treat them like you'd treat your bank statements!
Troubleshooting Exports
File won't open in Excel:
Make sure the file extension is .csv. If it downloaded as .txt, rename it to .csv and try again.
Numbers look weird (dates, amounts):
This is usually a formatting issue. Select the column and apply the correct format (Date, Currency, etc.) in your spreadsheet program.
Export is empty or missing transactions:
Check your date range and filters. Make sure you selected "All Time" or the correct custom range. Remove any account or category filters that might be excluding data.
Special characters look strange:
This is a text encoding issue. When opening the CSV, make sure your spreadsheet program uses UTF-8 encoding.
Quick Tips
- 💾 Backup quarterly: Export all transactions every 3 months to cloud storage
- 📊 Excel is powerful: Pivot tables, charts, formulas - do analysis HOB doesn't offer
- 🗂️ Organize exports: Create folders by year/month so you can find old exports
- 🔒 Secure your files: These contain sensitive data - treat them carefully
- 📧 Share securely: Use encrypted services when sending to advisors
- 🎯 Use filters: Export only what you need, not everything every time
- 📅 Year-end exports: Archive each year's transactions as a CSV on December 31st
Next Steps
Make the most of your financial data:
- Using Reports - Analyze your data within HOB before exporting
- Budget Basics - Use exported data to create better budgets
- Getting Started - Back to the basics
Still have questions? Contact support