Background: I’m working on a web app that needs complex grid data entry. Most web-based grid controls are either too simple or way too expensive and complicated to implement.
My idea: What if users could download a pre-made spreadsheet from our website, fill it out with their data, then click a button inside the spreadsheet to send everything back to our server? This would let people use Excel or LibreOffice Calc (which most folks already have) instead of dealing with clunky web forms.
Example workflow:
User visits our site and clicks “Download Data Entry Form”
They get a specially designed spreadsheet with built-in submit functionality
User enters their complex calculations and data
They hit a “Send to Website” button in the spreadsheet
The spreadsheet posts all data back to our web application
Question: Has anyone actually built something like this? I’m frustrated with current web grid solutions and wondering if using desktop spreadsheets as input widgets is feasible. Any technical gotchas or success stories would be helpful.
honestly this sounds like a nightmare for security reasons. leting users run arbitrary spreadsheets that can post back to your server opens up tons of attack vectors. what happens when someone reverse engineers your template and starts sending malicous payloads? might be easier to just bite the bullet and use a proper web grid component even if its pricey
I implemented something similar for a financial reporting system about three years ago. The concept works well for specific use cases, but there are several technical considerations worth noting. We used Excel’s VBA capabilities to create a custom ribbon with submission functionality that posted data via HTTP requests to our REST API. The biggest challenge was handling authentication securely - we ended up using temporary tokens that expired after the session. File format compatibility became an issue when users modified the template structure, so we implemented strict validation on both the client and server sides. Performance was surprisingly good for datasets under 10,000 rows, but larger files required chunked uploads. The solution worked particularly well for our power users who needed complex formulas and pivot table functionality that web grids simply could not match. However, maintenance overhead increased significantly due to version control of the Excel templates and supporting different spreadsheet applications across the organization.
interesting approach! i’m curious tho - how would you handle users who dont have macros enabled or are on mobile devices? also what about data validation on the server side when stuff comes back from the spreadsheet?