Importing Historical Data
Your church didn't start tracking metrics the day you signed up for Vitals. Import your past data so you can see year-over-year trends from day one.
Most churches we work with have years of attendance counts, giving totals, and other numbers stored in spreadsheets, old church management systems, or even paper notebooks. Importing that data into Vitals means your dashboard tells the full story of your church — not just the chapter that starts today.
Why Import Historical Data?
Without historical data, your Vitals dashboard starts from zero. That means no year-over-year comparisons, no seasonal trend lines, and no way to see if that new outreach initiative actually moved the needle compared to last year. Importing even a year or two of past data transforms your dashboard from "here is what happened last Sunday" to "here is how our church has been growing over time."
What importing unlocks
Year-over-year comparisons
See this Easter vs. last Easter, this quarter vs. the same quarter a year ago.
Seasonal trend lines
Discover patterns like the summer attendance dip or the December giving spike.
Accurate growth metrics
Know your real growth rate instead of guessing based on memory.
Better board reports
Show your elders or board a multi-year story, not just a snapshot.
Real-world example: First Baptist had 3 years of attendance data in an Excel spreadsheet from their old system. They imported it all in about 10 minutes and immediately saw their growth trend — a steady 8% year-over-year increase they didn't even realize was happening.
What Can Be Imported
You can import data for any metric that exists in your Vitals account — both default metrics and any custom metrics you have created. If it is a number you track, you can import it.
Where Your Data Might Live
Before you import, take a few minutes to gather your historical numbers. Here are the most common places churches find their past data:
Spreadsheets (Excel, Google Sheets)
The most common source. Many churches keep a running spreadsheet updated each Monday morning. If you have one of these, you are in great shape — it is the easiest format to import.
Old church management systems
Systems like ChurchTrac, Shelby, ACS, or FellowshipOne often have an export feature. Look for a "Reports" or "Export" option and pull your weekly metrics into a CSV file.
Planning Center reports
If you use Planning Center, you may already have data flowing into Vitals via our integration. But if you had Planning Center data before connecting to Vitals, you can export it and import the historical portion.
Paper records or bulletin notes
Some churches have attendance and giving numbers written in a notebook or printed in the weekly bulletin. You will need to type these into a spreadsheet first, but even partial data is valuable.
Formatting Your Spreadsheet
Vitals needs a simple spreadsheet with a few specific columns. You can use Excel (.xlsx) or CSV format. Here is what the columns should look like:
| Column | Required? | Description |
|---|---|---|
Date | Yes | The date of the service or week (e.g., 2024-01-07 or 1/7/2024) |
Metric Name | Yes | The name of the metric (e.g., "Total Attendance" or "Total Giving") |
Value | Yes | The number (e.g., 342 or 12500.00) |
Campus | Multi-site only | The campus name (must match a campus in your Vitals settings) |
Example spreadsheet
| Date | Metric Name | Value | Campus |
|---|---|---|---|
| 2024-01-07 | Total Attendance | 342 | Downtown |
| 2024-01-07 | Total Giving | 12500.00 | Downtown |
| 2024-01-07 | Total Attendance | 187 | Westside |
| 2024-01-14 | Total Attendance | 356 | Downtown |
Tip: Metric names in your spreadsheet need to match the metric names in Vitals. Check Settings → Metrics to see the exact names — including any custom renames you have made.
Tip: Single-location churches can leave the Campus column blank — Vitals will assign the data to your default campus automatically.
Step-by-Step Import Process
Once your spreadsheet is ready, the actual import takes just a few clicks.
- 1Go to Settings → Import Data.
- 2Click Choose File and select your spreadsheet (.xlsx or .csv).
- 3Vitals will preview the first few rows so you can confirm the data looks correct.
- 4Map your columns — Vitals will auto-detect Date, Metric Name, Value, and Campus columns if they are named correctly. If not, use the dropdowns to map each column manually.
- 5Review the import summary: total rows, metrics detected, date range, and any warnings.
- 6Click Import. Vitals processes the data in the background — you will see a progress bar.
- 7When complete, you will get a summary showing how many data points were imported and if any rows were skipped.
You can import multiple files if your data is split across different spreadsheets. Just run the import process again for each file.
If you import data for a date that already has a value, Vitals will ask if you want to overwrite the existing value or skip the duplicate.
Handling Messy or Incomplete Data
Real-world data is rarely perfect, and that is totally fine. Here is how Vitals handles the most common issues:
- Missing weeks
- Don't worry if you are missing some weeks. Vitals handles gaps gracefully — it will not count missing weeks as zero. Your charts will simply skip over the gap, and averages will only include weeks where data was actually recorded.
- Inconsistent dates
- Vitals accepts most common date formats (1/7/2024, 2024-01-07, Jan 7 2024, etc.) and normalizes them automatically.
- Blank values
- If a cell is blank, Vitals skips that row. It will not import a zero — it simply leaves that week without a data point for that metric.
- Extra columns
- Any columns beyond Date, Metric Name, Value, and Campus are ignored. You do not need to clean up your spreadsheet first.
- Unrecognized metrics
- If a metric name in your file does not match any metric in Vitals, that row is flagged and skipped. You will see these in the import summary so you can fix the names and re-import.
Bottom line: Partial data is way better than no data. Even if you only have attendance numbers and not giving, or only 18 months instead of 5 years, import what you have. You can always add more later.
Bulk Import vs. Manual Backfill
Vitals gives you two ways to add historical data. Here is when to use each approach:
- Spreadsheet import (bulk)
- Best when you have a lot of data — say, a year or more of weekly numbers sitting in a spreadsheet. This is the fastest way to get large amounts of historical data into Vitals. Use the process described above.
- Manual backfill (one week at a time)
- Best when you have just a handful of past weeks to enter, or when your data is scattered across paper records and you are entering it as you find it. Go to the dashboard, select the date you want to backfill, and enter the numbers manually — just like entering current-week data.
Our recommendation: If you have more than about 10 weeks of data to enter, use the spreadsheet import. It will save you a lot of clicking.
You can mix both approaches. Import the bulk of your history from a spreadsheet, then manually backfill a few stray weeks you discover later.
Verifying Your Imported Data
After importing, take a few minutes to spot-check that everything landed correctly. Here is a quick checklist:
- 1Go to your dashboard and switch to a date range that covers your imported data (e.g., "Last 12 Months" or a custom range).
- 2Check that the trend lines look reasonable — do the peaks and valleys match major events like Easter, Christmas, or your summer slump?
- 3Pick a few specific dates and compare the dashboard numbers to your original spreadsheet to make sure they match.
- 4If you are multi-site, switch between campuses to confirm each location’s data was assigned correctly.
- 5Check the import log in Settings → Import Data for any rows that were skipped or flagged.
Pro tip: Import your data early — ideally during your first week with Vitals. That way your dashboard shows meaningful trends right away instead of starting from scratch. Your team will be much more excited about Vitals when they open it and see years of history, not just an empty chart.
Related Articles
Still have questions? Email us at support@vitals.church — we usually reply within a few hours.