Real-Time Excel–Postgres Sync
Budget: ₹12,500 – ₹37,500 INR
I have an inventory spreadsheet that staff update on their Windows machines throughout the day, and I need every change reflected in a PostgreSQL database almost immediately. The file lives locally (not in OneDrive or Google Sheets), so I’m after a lightweight service or script—Python, .NET, PowerShell, anything reliable—that will watch the Excel file, capture row-level edits, and push them via API into the Postgres tables in real time.
Here’s what I’m aiming for:
• A background process that launches with Windows, detects inserts, updates, and deletions in the workbook, and posts only the delta to the database—no full-file reloads.
• Configurable mapping between the spreadsheet columns and the destination table so we can tweak the layout later without code rewrites.
• Robust error handling and a simple log (JSON or text) so I can trace sync attempts and failures.
• A small installer or clear step-by-step setup guide so non-technical team members can deploy it on other PCs.
Acceptance criteria
1. Edit a cell in the local Excel file; the corresponding Postgres record updates within seconds.
2. Shut down or restart Windows; the service resumes automatically and continues syncing.
3. No duplicate rows or data loss after forty-eight hours of continuous use.
If you’ve built something similar—or can show a quick proof-of-concept—let’s talk.
Here’s what I’m aiming for:
• A background process that launches with Windows, detects inserts, updates, and deletions in the workbook, and posts only the delta to the database—no full-file reloads.
• Configurable mapping between the spreadsheet columns and the destination table so we can tweak the layout later without code rewrites.
• Robust error handling and a simple log (JSON or text) so I can trace sync attempts and failures.
• A small installer or clear step-by-step setup guide so non-technical team members can deploy it on other PCs.
Acceptance criteria
1. Edit a cell in the local Excel file; the corresponding Postgres record updates within seconds.
2. Shut down or restart Windows; the service resumes automatically and continues syncing.
3. No duplicate rows or data loss after forty-eight hours of continuous use.
If you’ve built something similar—or can show a quick proof-of-concept—let’s talk.
Related categories:
Python
Visual Basic
.NET
Excel
Software Architecture
Powershell
Database Management
API Development