Athletic Archive Spreadsheet Preservation Guidelines: Formats, Formulas, and Durable Exports

Athletic departments manage more structured data in spreadsheets than most realize: season rosters with eligibility dates, cumulative win-loss records across decades, all-conference and all-state award tallies, financial ledgers for booster accounts, scholarship tracking sheets, and nomination records for hall-of-fame programs. When those spreadsheets are preserved correctly, they become searchable, citable, and display-ready. When they are not — when a key file lives only on a retiring coach’s personal laptop in a format tied to a ten-year-old version of a software suite — the historical record they represent may be unrecoverable.

Athletic record displays draw from preserved data — consistent spreadsheet preservation ensures that decades of statistics, rosters, and award records remain accurate and displayable regardless of which software version created them

Why Athletic Spreadsheets Need a Dedicated Preservation Plan

Spreadsheets create a specific category of preservation risk that does not apply to photographs, PDFs, or scanned documents. Three failure modes are common at the school level.

Formula dependency. A spreadsheet calculating career point totals, cumulative win-loss percentages, or grade-point averages for scholar-athlete awards depends on formulas referencing other cells, other tabs, or — most dangerously — other files. When the referenced file moves or disappears, the formula returns an error. When the formula uses a function that was deprecated or behaves differently in a newer software version, it produces a wrong answer silently. A preserved spreadsheet that contains formula errors is not a preserved record — it is a source of misinformation.

Format obsolescence. Proprietary spreadsheet formats — .xls from legacy Excel, .numbers from Apple Numbers, .ods from older LibreOffice — can become difficult or impossible to open without the specific software version that created them. A championship statistics workbook created in a format tied to a discontinued product may be functionally unreadable five years from the date it was saved, even if the file itself is intact.

Single-point storage. Athletic spreadsheets frequently exist only on personal devices: a coach’s laptop, an athletic director’s desktop, a booster treasurer’s home computer. When that device fails, the person leaves the role, or the file is simply not transferred during a system migration, the record is gone. Unlike institutional email platforms or shared drives, personal devices have no automatic backup, no retention policy, and no off-boarding checklist that includes “export and transfer athletic data.”

A preservation plan addresses all three risks with a standard format, a documented export process, and a storage protocol that takes the record off personal devices and into institutional control.

Athletic Archive Spreadsheet Formats: What Survives and What Does Not

The format decision is the foundation of every other preservation step. Choose the wrong format and the effort invested in organizing, naming, and documenting the data may not survive the next software upgrade cycle.

The practical rule: For every spreadsheet record that needs to survive more than three years, produce two exports at the time of archiving — a CSV for the raw data and a PDF for the visual reference copy. Keep the working file in .xlsx or .ods format if ongoing updates are needed, but treat the CSV and PDF as the preservation copies.

Step-by-Step Athletic Archive Spreadsheet Preservation Workflow

The following workflow applies to any athletic spreadsheet — a season roster, an all-time statistics record, a booster financial ledger, or a hall-of-fame nomination tracking sheet. Work through the steps in order.

Step 1: Audit the spreadsheet before preserving it. Before exporting anything, review the file for problems that will affect the quality of the preserved record. Check every formula-dependent cell to confirm it is calculating correctly. Check for external file references — formulas that point to another workbook — and either eliminate the dependency by replacing the formula with its calculated value, or document the external reference so future users understand the dependency. Check for hidden sheets, hidden columns, or hidden rows that contain data relevant to the record. A preservation export that omits hidden data is an incomplete archive.

Step 2: Replace volatile formulas with calculated values. Formulas that depend on today’s date (TODAY()), current time (NOW()), or random values are volatile — they produce different results each time the file is opened. In a historical record, a “current age” formula that was accurate when the file was created becomes inaccurate the next time the file opens. Replace volatile formula results with their static calculated values before archiving: copy the cell, paste as values only, and verify the stored number matches the intended historical data point.

Step 3: Document every formula in the file. Before exporting the preservation copies, create a formula reference sheet. This can be a separate tab within the workbook (not exported to CSV) or a companion documentation file. For each formula-driven column or cell range, record: the column name, what the formula calculates, and the formula text itself. This documentation allows a future user — who may not know that the “Winning Percentage” column is calculated and not entered — to reconstruct or verify the formula if the working file is ever opened in a different software environment.

Step 4: Standardize the data before export. Consistent formatting in the CSV export makes the data usable downstream — for display programs, for import into other systems, and for human review. Before exporting, ensure that dates follow ISO 8601 format (YYYY-MM-DD), that text values use consistent capitalization (not “boys varsity” in some rows and “Boys Varsity” in others), and that numeric fields contain only numbers (no units, no currency symbols embedded in cells, no ranges like “14-16” in numeric columns). Data that is clean in the working file will be clean in the export; data that is inconsistent will compound its inconsistency when imported elsewhere.

Step 5: Export the CSV preservation copy. Export the primary data sheet — or each sheet separately for multi-tab workbooks — as a UTF-8 encoded CSV file. In Excel: File → Save As → CSV UTF-8 (Comma delimited). In LibreOffice Calc: File → Save As → Text CSV, then select UTF-8 encoding. In Google Sheets: File → Download → Comma-separated values. Save the CSV file using the athletic archive naming convention. For a workbook with multiple sheets, use a consistent naming suffix: the roster sheet CSV might be OAK_FTBL_2024_ROSTER_Varsity-Final.csv and the statistics sheet CSV might be OAK_FTBL_2024_STATS_Season-Final.csv.

Step 6: Export the PDF reference copy. The PDF export captures the visual layout — column headers, formatting, and any summary rows — that the CSV does not preserve. In Excel or LibreOffice: File → Print → Save as PDF, or File → Export as PDF. In Google Sheets: File → Download → PDF. Before exporting, set the print area to include all data, scale to fit on a reasonable number of pages, and enable the option to print row and column headers. The PDF is the human-readable reference; the CSV is the machine-readable data. Both are part of the complete preservation record.

Step 7: Apply the athletic archive file naming convention. Name both the CSV and the PDF using the archive naming convention. A consistent naming structure — [SCHOOL]_[SPORT]_[YEAR]_[TYPE]_[DESCRIPTION].[EXT] — makes both files findable without opening them. Retain the original working file (.xlsx, .ods, or .gsheet export) with the same base name and its native extension. All three files — working, CSV, PDF — belong in the same archive folder for that sport and season. Athletic archive file naming conventions for photos, rosters, and records apply directly to spreadsheet exports; use the same naming standard across all file types in the archive.

Step 8: Store the preservation copies in the institutional archive, not on a personal device. Move the CSV and PDF exports — and the working file — to the designated institutional archive location. This may be a school-managed shared drive, a district file server, or an institutional cloud storage system with defined access controls. The preservation copies must not exist only on a personal laptop, a personal Google Drive account, or any storage that is not transferable to the next person who holds the role. Digitizing historical records for institutional display programs follows the same principle — the institutional record must live in institutional storage, not in personal custody.

Step 9: Create a metadata record for each preserved spreadsheet. A metadata record in the archive’s tracking system makes the spreadsheet findable by search rather than by browsing folders. The minimum metadata for a preserved spreadsheet record:

Step 10: Schedule a periodic migration review. CSV and PDF are highly durable formats, but no format is permanent. Every three to five years, review whether the working file formats in the archive are still fully supported by current software. If the review identifies files in formats that are losing support — legacy .xls files, .numbers files, or other proprietary formats — export them to current formats before the old software that can open them is no longer available. Migration is always easier while the source software still exists than after it has been discontinued.

Recognition display profiles are only as accurate as the underlying data records — preserved spreadsheets in durable formats provide the statistical and award history that makes each athlete's profile complete and verifiable

Formula Documentation: The Most Overlooked Preservation Step

Of all the steps in the spreadsheet preservation workflow, formula documentation is the one most frequently skipped — and the one that creates the most problems years later. A CSV export preserves values. A PDF export preserves appearance. Neither preserves the logic that produced calculated fields.

When a hall-of-fame committee five years from now opens the CSV export of a career statistics record and sees a “Career Efficiency Rating” column, they have no way to know whether that number was calculated by formula, entered manually, or imported from a third-party source — unless the formula documentation exists. If the rating was calculated using a formula that contained an error, the documentation is the only record that would allow future staff to identify and correct the error. If the rating used a formula that the program later changed, the documentation establishes the methodology in effect when each record was set.

For each calculated column or cell range in any spreadsheet that will be archived, record:

• Column or cell reference: The column header and cell range (e.g., “Column G: Career Points, cells G2:G201”)
• Formula text: The exact formula, including sheet references if cross-tab (e.g., =SUM(SeasonStats!D2:D50))
• What it calculates: Plain-language description (e.g., “Sum of all season point totals for this athlete across all seasons in the SeasonStats tab”)
• Methodology notes: Any decisions embedded in the formula that are not self-evident (e.g., “Includes regular season and playoff games; excludes scrimmages which appear in column H”)
• Date documented: When this formula documentation was created

Store this documentation in a dedicated tab within the working file before exporting preservation copies — that way it is always co-located with the data it describes.

Which Athletic Spreadsheets Need Preservation Treatment

Not every spreadsheet an athletic department creates warrants formal preservation. The decision should be based on whether the data has long-term historical, administrative, or legal value.

High Priority — Permanent Retention

• Season rosters with eligibility records. Final rosters documenting which athletes competed in which seasons, including any eligibility notes, are primary source documents for future award programs, all-time records, and hall-of-fame nominations.
• All-time statistical records. Cumulative point, assist, win, save, or other performance records that may be cited in recognition programs for years or decades.
• Award and honor tracking. Spreadsheets recording all-conference, all-state, scholar-athlete, and program-specific award recipients, including the year and conferring organization.
• Championship and win-loss records. Season-by-season win-loss records and championship documentation are core program history data.
• Hall-of-fame nomination records. Tracking sheets for open nomination cycles, including nominee names, years submitted, and disposition, document the history of the recognition program itself.

Medium Priority — Long-Term Retention (10+ Years)

• Booster financial ledgers. Revenue and expense records for booster accounts may be required for audit or legal reference years after the fiscal year closes.
• Scholarship and award financial records. Tracking sheets for scholarship recipients, award amounts, and disbursement history.
• Facility usage and scheduling records. Multi-year scheduling and usage records for athletic facilities, particularly those with naming rights or donor acknowledgment attached.
• Recruiting and college placement tracking. Records documenting where program graduates enrolled and any scholarship placements the program facilitated.

Lower Priority — Operational Retention (1–5 Years)

• Season game schedules and transportation logistics
• Fundraiser tracking sheets without long-term financial implications
• Practice schedule and facility reservation records
• Routine equipment inventory sheets

For programs also maintaining donor recognition wall records and nonprofit recognition tracking, donor-related spreadsheets — pledge tracking, giving history, recognition category records — should be treated as high-priority permanent records rather than operational documents, since they document commitments with legal and relationship implications.

Export Strategies for Specific Athletic Spreadsheet Types

Different types of athletic spreadsheets require slightly different export approaches because of their structure and intended downstream use.

Roster Spreadsheets

Preservation goal: A complete, accurate record of who competed in each season.

Export approach: Export one CSV per roster type per year (varsity, junior varsity, freshman if maintained separately). The CSV should contain one row per athlete, with columns for: athlete name, grade level at time of roster, sport, season year, jersey number (if applicable), position (if applicable), and any eligibility notation. Include a column for a unique athlete identifier if the archive uses one — this is the field that links the roster record to other records about the same athlete.

Retain the working file for rosters that are built during the season and updated as rosters change; the preservation copies should reflect the final, end-of-season state.

Statistics Spreadsheets

Preservation goal: A verifiable record of individual and team performance that can support future all-time records, records-board displays, and nomination documentation.

Export approach: For season statistics, export the individual statistics sheet and the team summary sheet as separate CSVs. Document all calculated columns using the formula documentation approach above. The PDF export is particularly important for statistics records because the visual layout — which columns appear in which order, what the column headers mean, how totals and subtotals are organized — is context that the CSV does not carry.

Programs building digital record board displays that surface top performances and school records will find that CSV exports from consistently formatted statistics spreadsheets are the most import-ready source format for those systems — provided the column structure is documented and consistent across years.

Award and Recognition Tracking Spreadsheets

Preservation goal: A complete, searchable record of which athletes received which honors in which years, usable for display programs and nomination review.

Export approach: The CSV export for an award tracking spreadsheet must include, at minimum: athlete name, athlete unique identifier if available, sport, award name, conferring organization, and year awarded. A consistent column structure across years is essential — if the column order or column names change between the 2015 export and the 2025 export, the records cannot be merged without manual cleanup. Establish the column structure once, document it, and use it for every annual export that follows.

Hall-of-fame programs, digital recognition wall builds, and interactive touchscreen display projects all consume award tracking data. The more consistently the data is structured and named across years, the faster these projects can import and display accurate historical records.

Financial and Booster Spreadsheets

Preservation goal: A legally defensible, auditable record of revenue, expenses, and obligations.

Export approach: Financial spreadsheets require the most rigorous formula documentation because errors in a financial record have direct consequences. Before exporting, verify that every calculated total matches a manual cross-check. Export the PDF with totals prominently visible and a date stamp in the document. Retain the working file in addition to the preservation copies. Store financial exports in a restricted-access folder within the archive, and coordinate with the school district’s records retention requirements for financial documents, which may be longer than the program’s general archive retention policy.

Alumni recognition programs depend on structured data from years of preserved spreadsheets — award tracking, statistical records, and roster history all feed the profiles that make hall-of-fame displays and recognition programs accurate

File Naming and Storage for Athletic Spreadsheet Archives

Consistent file naming for spreadsheet archives follows the same structure used for other archive file types. Apply the [SCHOOL]_[SPORT]_[YEAR]_[TYPE]_[DESCRIPTION].[EXT] convention to every preservation copy.

Type codes for spreadsheet records:

Example file names:

Folder structure for spreadsheet archives:

Store spreadsheet preservation copies in the relevant sport and year folder within the overall athletic archive, alongside other document types for the same period. Do not create a separate “Spreadsheets” silo — that approach separates the roster CSV from the team photograph folder for the same season, requiring users to navigate two locations to get the full picture of a given year.

/Archive
  /Football
    /2024
      OAK_FTBL_2024_ROSTER_Varsity-Final.csv
      OAK_FTBL_2024_ROSTER_Varsity-Final.pdf
      OAK_FTBL_2024_ROSTER_Varsity-Final.xlsx
      OAK_FTBL_2024_STATS_Season-Final.csv
      OAK_FTBL_2024_STATS_Season-Final.pdf
      OAK_FTBL_2024_PHOTO_TeamPortrait_001.jpg
  /Athletics-Wide
    /Awards
      OAK_ATHL_2024_AWARD_AllConference.csv
      OAK_ATHL_2024_AWARD_AllConference.pdf
    /HOF-Nominations
      OAK_ATHL_2024_HOFNOM_Cycle-2024.csv

Connecting Preserved Spreadsheets to Digital Recognition Programs

A preserved spreadsheet archive becomes most valuable when it feeds a recognition program that makes the data visible — a hall-of-fame display, a digital record board, an interactive touchscreen that surfaces school history for students, alumni, and visitors.

The connection between the archive and the display depends on three things: the data is in a format the display system can import (CSV is almost universally accepted), the column structure is consistent across years (so all-time records can be merged without manual cleanup), and the records are accurate (which the formula documentation and audit steps above protect against).

For programs building new athletic recognition displays or upgrading physical trophy cases and honor boards, a well-organized spreadsheet archive is the fastest path to a complete, historically deep display. Instead of reconstructing records from newspaper archives, physical plaques, and institutional memory, the display builder can import the CSV exports directly and begin from a foundation of verified historical data.

Programs that have accumulated years of spreadsheet records but never systematically preserved them will typically find a mix of usable and unusable files. The usable files — modern formats, consistent column structures, formula-documented — can be imported relatively quickly. The unusable files — formula-dependent without documentation, in deprecated formats, with inconsistent column structures — require cleanup before import. Starting a systematic preservation workflow now limits the size of that cleanup project for every future display build.

School recognition programs that span athletic achievement and academic honor both benefit from structured historical data — a preserved spreadsheet record of scholar-athlete awards, academic all-state selections, and multi-year honor roll data is as valuable to a complete recognition display as the athletic statistics that typically get more preservation attention.

For programs that have already digitized some historical records and want to understand how organized archives support display quality, the relationship between hall-of-fame build quality and source data is direct: displays built from clean, organized archives are more historically complete, faster to build, and more accurate than those reconstructed from fragments.

Hallway kiosks that display program history are only as complete as the archives feeding them — preserved spreadsheets in CSV format are among the most import-ready source types for interactive recognition displays

Frequently Asked Questions

Should we preserve the working file (.xlsx or .ods) in addition to the CSV and PDF exports?

Yes. The working file preserves formulas, formatting, and multi-tab structure that the exports do not. It is the file that makes it possible to update or correct a record if an error is found later. The CSV and PDF exports are the durable, format-independent preservation copies; the working file is the authoritative source. Treat all three as parts of a complete preservation record and store them together in the same archive folder.

Our statistics spreadsheet has dozens of formula-driven columns. Do we need to document every formula?

Document every formula that produces a value that may be cited, displayed, or used in a recognition program — career totals, winning percentages, award point calculations, efficiency ratings. Purely intermediate formulas that convert one internal value to another for display purposes (rounding, unit conversion) can be documented more briefly. The test is: if this cell’s value appears in a hall-of-fame profile, a record board display, or a nomination packet, the formula behind it needs documentation.

We have spreadsheets in Apple Numbers and Google Sheets that were never exported to other formats. How do we preserve them now?

For Apple Numbers files: open the file in Numbers and export to .xlsx first (preserves formulas and formatting), then produce the CSV and PDF preservation copies from the .xlsx version. For Google Sheets: download as .xlsx via File → Download, then follow the same CSV and PDF export steps from the .xlsx version. Do not preserve Google Sheets by saving the shared link — if the account is closed or the sharing settings change, the link is inaccessible. The exported file must exist outside the cloud account as a standalone file.

How do we handle multi-tab workbooks with different types of data in different tabs?

Export each data tab as a separate CSV file using the naming convention with a tab-specific description. A roster workbook with a varsity tab and a JV tab produces two CSVs: OAK_FTBL_2024_ROSTER_Varsity-Final.csv and OAK_FTBL_2024_ROSTER_JV-Final.csv. Export a single PDF of the full workbook (all tabs) as the visual reference, labeled with the workbook name. Include a formula documentation tab in the working file that covers all data tabs.

Our hall-of-fame committee maintains a nominations spreadsheet that is updated every year. How should we preserve a record that is still active?

For actively maintained records, preserve an annual snapshot at the close of each nomination cycle. Export the CSV and PDF at the point when the cycle closes — nominations submitted, reviewed, and decided — using the year of the cycle in the file name. The working file continues to be updated for the next cycle; the year-end snapshots are the preservation record. This approach captures the state of the record at each decision point without disrupting the working file.

Which cloud storage services are acceptable for storing athletic archive spreadsheets?

Any cloud storage system that the school district controls — meaning the institution can access the files regardless of who holds a specific staff role — is acceptable. District-managed Google Workspace shared drives (not personal Google Drive), institutional Microsoft SharePoint or OneDrive with school-controlled accounts, and district-managed file servers are all appropriate. Personal cloud accounts — a staff member’s personal Google Drive, iCloud, or Dropbox — are not acceptable storage for institutional records, because access depends on the individual’s account remaining active and accessible to the institution.

How does spreadsheet preservation connect to a school’s overall digital preservation policy?

Athletic spreadsheet preservation follows the same principles as broader digital preservation file format guidance — open, non-proprietary formats for long-term copies, working files retained alongside exports, periodic migration review to catch format obsolescence. The spreadsheet-specific additions are formula documentation and the two-export (CSV + PDF) approach. Programs without a broader digital preservation policy can treat the spreadsheet workflow described here as a self-contained starting point and extend the same principles to photographs, video, and documents as the archive program develops.

What is the best way to retroactively preserve a large backlog of unsystematically saved spreadsheets?

Start with the highest-priority record types — all-time statistics, award tracking, championship records, hall-of-fame nominations — and work backward by year from the most recent. For each file: open it, audit the data, replace volatile formulas, document calculated columns, export CSV and PDF, name according to convention, and store in the institutional archive. For files in deprecated formats that cannot be opened in current software, check whether the software that created them is still available anywhere in the district — on an old machine or via a compatibility mode — before concluding the file is unrecoverable.