🪔
Data Manager
PSOTS Chhath 2026 · Historical Import & Resident Directory
🪔 PSOTS Data Manager
Import & Resident Directory
← Admin Panel
0
Total Records
0
Years Imported
0
Unique Flats
₹0
Total Historical
📋 Option A — Paste from Google Sheets
Open your old Google Sheet → Select all data → Copy (Ctrl+C) → Paste below.
Expected columns: Name · Flat · Amount · Date · Mobile (optional)
Paste directly from Google Sheets — headers should be in the first row
📁 Option B — Upload File
Upload a CSV, Excel (.xlsx / .xls), or PDF file. Excel files with multiple sheets show a sheet picker — choose which one to import. PDF text is extracted and placed in Option A for review before importing.
📂
Click to choose file or drag & drop here
CSV · Excel (.xlsx / .xls) · PDF
🗂 All Imported Historical Data
All contribution records stored in the system. Shown per year.
No data imported yet. Use the import tool above.
👥 Resident Directory
Master list of all PSOTS residents with their details. Built automatically from historical contribution data. Used to auto-fill manual entries when you type a flat number.
#NameFlat / TowerMobileYears Contrib.Total GivenLast YearActions
Build directory from history data first
✏️ Add / Update Resident Manually
Add a resident who isn't in the historical data — new residents, family members, etc.
🔍 Flat Number Lookup
Type a flat number to instantly see resident details, contribution history and contact info. Used by the admin for manual/cash entry — no need to remember names.
Start typing a flat number above to look up resident details.
🕐 Quick Access — All Flats
All residents in the directory. Click any row to look them up.
⚙️ Google Apps Script — Full Setup
This script connects your Google Sheet to the website. It handles form submissions, contributor list, historical data lookup AND resident directory — all in one deployment.
1
Open your Google Sheet
The same sheet where 2025 contributions are stored. Create a new tab named 2026 for current year data. Keep existing tabs (2025, 2024 etc.) as-is.
2
Open Apps Script
Extensions → Apps Script → Delete all existing code → Paste the full script below.
3
Deploy as Web App
Click Deploy → New Deployment → Web App → Execute as: Me → Who has access: Anyone → Deploy → Authorize → Copy the URL.
4
Paste URL in Settings
Go to Admin Panel → Settings tab → paste URL into "Apps Script URL" field → Save.
Apps Script Code — Copy All
🔗 Connect Your Sheet
Once deployed, paste your Apps Script URL here to test the connection.
📊 Your Sheet Structure
Set up your Google Sheet tabs like this:
Tab NameCol ACol BCol CCol DCol ECol FCol GCol H
2026 (current)TimestampNameFlatMobileAmountDateMethodStatus
2025 (existing)NameFlatAmountDate…your existing columns
Residents (new)FlatNameMobileTowerMaster directory