Upload your intake spreadsheet, in any layout, and the page builds an operational dashboard around it: monthly totals, donor concentration, distribution, and trends. Filter by department or date. Switch the audience setting to share with donors, board, or the public without exposing sensitive fields.
Pantry Dashboard is a browser-based, audience-aware dashboard for food bank operations. The project grew out of a data analysis support engagement with a local Pennsylvania food bank, and is generic enough that any food bank with a similar intake spreadsheet can adopt it. For research and exploratory purposes only. Not a substitute for operational decision-making without independent verification.
You drop your intake file onto the page. The dashboard auto-detects which columns are dates, departments, donors, recipient sites, pounds, and households. Wide-sparse data is handled by design: each department fills only its columns, and empty cells are treated as not-applicable rather than missing.
One toggle switches between four audience modes: Internal staff, Board and executive, Donors, and Public. Each mode shows or hides specific views and fields. The board view drops row-level data and emphasizes trend lines. The donor view emphasizes intake and aggregated impact. The public view aggregates everything and removes donor names entirely.
Your file never leaves your browser. Parsing happens in JavaScript on your device. There is no server upload, no account, and no analytics that touch the contents of your data. Close the tab and the file is gone.
Null Set Labs, a youth-led research lab. The dashboard is part of the lab's Open track: tools released as a public good. See nullsetlabs.org.
Pantry Dashboard is open source under CC BY-NC 4.0. Source: github.com/nullsetlabs/foodbank-dashboard.
Parsing uses SheetJS. Charts use Chart.js. Both load from public CDNs.