Member Avatar for MKIII

Hello all, i'm trying to have an excel spreadsheet online (with a url) like I've seen done before, but I dont' quite know how to do it.

So I've saved the spreadhseet as a webpage, I inserted the spreadsheet onto my webpage and publised the page.

The question is, how does one continually save the spreadsheet??? I would like people to enter data and I would like to have a local copy saved on my computer also.

Thanks.

  • 3 Contributors
  • 2 Replies
  • 128 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by autocrat

Dani AI

Generated

Saving an Excel workbook as a static webpage gives you a snapshot, not a live, editable file. There are two practical ways to get a continually saved spreadsheet at a URL: a cloud-hosted spreadsheet that supports browser editing and autosave, or a server-side web app that accepts inputs and stores them in a proper back-end. Both routes were touched on earlier — pointed toward cloud sharing, and sketched the server-side/storage path — so below are concrete trade-offs and steps.

Cloud-hosted route (fastest): import your .xlsx into an online spreadsheet service, open it in the browser, and share an edit link so collaborators can type directly. The service keeps real-time saves and version history. To keep a local copy, use the provider’s sync client to mirror the folder on your machine, or set up an automated export (via the provider API or scripting) that saves periodic .xlsx or .csv backups. Note that “publish to web” often produces a read-only view; make sure you’re sharing an editable link when you expect people to enter data. See Google Sheets for a quick start and the Apps Script/Sheets API for automation.

Server-side route (more control): collect entries via web forms, write them into a back-end store, and render the sheet from that data or generate Excel exports on demand. This avoids file-locking and concurrency problems that crop up when many people try to edit one XLSX file. It requires development and hosting, but gives validation, logging, and reliable backups.

Quick checklist: don’t rely on static HTML for live edits; pick cloud for simplicity, server-side for scale and data integrity; always enable version history and automated backups; limit edit permissions to trusted users to protect data.

Recommended Answers

All 2 Replies

Member Avatar for cmannering

Without having a LAN set up that allows read and write across the network you may not be able to do this online. You can use something like Google Docs to share things, also something we use here at work is ning.com which allows you to privately share and modify attachments of many types.

Member Avatar for autocrat

If you have a windows based server it is doable with a little effort (sort of the only advantage to a windows server!).

The other alternative is to attach the spread sheet to a database, and have the database attached to the webpage.

That means you can make changes to thespreadsheet, upload thechanges tot he DB... and the results would be updated onthe page.

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.