Member Avatar for Lightninghawk

So I have an excel spreadsheet I use for Closing Inventory and Register Reports.
Very simple.

I want to post this on my website so each of my stores can fill it out online and then it submits itself to my email as an excel spreadsheet.

Does anyone have any idea about how to go about doing this?

PM me with email address for copy of xlsx file if desired.

~Daniel

  • 2 Contributors
  • 4 Replies
  • 99 Views
  • 15 Hours Discussion Span
  • Latest Post Latest Post by Lightninghawk

Dani AI

Generated

asked for stores to fill a simple Closing Inventory/Register report online and have it emailed back as an Excel file. correctly pointed toward server libraries; below are practical, up-to-date choices and concrete pitfalls to avoid.

Fast and simple
Create an HTML form mirroring the spreadsheet columns and post to a server script that builds a CSV (comma-separated) file. CSV is the least friction: Excel opens it, it is trivial to generate, and it avoids the complexity of real .xlsx generation. Important details: always escape fields (double quotes around values, double internal quotes), prepend a UTF-8 BOM if using non-ASCII characters so Excel on Windows reads encoding correctly, use file locking when appending to a shared file, and send via an authenticated SMTP client (not raw server mail) so attachments reliably arrive. Name files with store ID and timestamp (for example Store12_20251105.csv).

Robust and feature-rich
If you need multiple sheets, formulas, cell formats, or strict Excel compatibility, generate a real .xlsx on the server (or client) using a modern library in your stack (for example a maintained XLSX library for PHP/Node/Python). That lets you reproduce the exact workbook. Alternatively, use cloud forms (Google Forms -> Google Sheets, or Microsoft Forms/Power Automate) and export or automate XLSX emails. Tradeoffs: libraries need coding and hosting; cloud tools reduce dev work but may introduce accounts, permissions, or cost.

Security, testing, and deployment
Require SSL, authenticate each store (token or login), validate and sanitize every field (numbers, dates), and log raw submissions so you can re-send attachments if email fails. Test with real Excel versions and different locales (decimal separator and list delimiter differ by country).

Recommended Answers

All 4 Replies

Member Avatar for Lightninghawk

Any other options? even the developer isn't recommending it for newer versions of excel...

Plus doesn't appear to be the simplest option either. Thank you though

Member Avatar for Lightninghawk

Thanks I'll get on it at next break and let you know what I come up with.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.