Turning an Excel file into a website: when it pays off and how to do it right

A lot of business runs on an Excel file: a price list, a spare-parts catalogue, stock balances, a schedule or a customer list. The file is perfect while one person works on it. It starts to strain when many people need to see it at once, and on their phones.

Signs your spreadsheet should become a website

• You resend the file on WhatsApp whenever a price changes, and people keep opening old copies.
• Customers look for an item or code on their phone and have to pinch and zoom across a wide table.
• Some columns, such as purchase price, must be hidden from some people and visible to others.
• Several colleagues edit the same file and nobody knows who changed what.
• The file has grown slow, or holds formulas only the person who wrote them understands.

What changes when the file becomes a website

A website is not just the table put online. The real difference is that everyone sees the data in the way that suits them:

• Customers search by product name or code, filter by area or price, and read results as tidy cards on their phone.
• Your team sees more after signing in, each person according to their role.
• There is one version of the truth: update the data and everyone sees the latest at once.
• Important formulas become written rules inside the site, so results come out right every time.

Two ways to do it — pick the one that fits

• A published version refreshed when you send a new file: right for a catalogue or price list that changes every few weeks.
• An admin panel where you upload the Excel file yourself: you get a preview and an error report before anything is published, which suits data that changes daily.

If several people edit the data throughout the day, you most likely need a database and a small system rather than file uploads. That decision belongs before the build starts, not after.

Prepare your file first

• One header row at the top of the sheet, with a clear title for every column.
• No merged cells and no empty rows in the middle of the table.
• A stable code for every row, such as an item or customer number, to prevent duplicates and mix-ups.
• Consistent dates, numbers and currency across every column.
• Sensitive data such as phone numbers or purchase prices in clearly separate columns, so access can be controlled.

Limits worth knowing

Excel handles up to 1,048,576 rows and 16,384 columns per worksheet, and Google Sheets up to 10 million cells per file. In practice problems appear long before those limits: the file slows down, sharing turns chaotic and phones struggle to open it. A website reads the data from an organised database, so it stays fast even with thousands of items.

The bottom line

If the file is viewed far more than it is edited, and many people need it on their phones, turning it into a website saves time and cuts mistakes. Start with the most important sheet, and show customers only what they need.

Quick questions

Sources

• Microsoft — Excel specifications and limits
• Google — file size limits in Google Drive and Sheets