People use spreadsheets so often because they are useful for presenting data. They use them in their personal lives, but even more in business.
Customers, vendors, investors, government agencies, and others ask for them.
It is always possible to send a copy of the file to them. But it is not guaranteed that they have a copy of Microsoft Office Excel.
Another option is to attach it to an email as a printable PDF file. An easy solution is to make the spreadsheet accessible as a web page that anyone can open with a web browser.
This post shows how to publish an Excel sheet on the web. It also shows how to publish a Google Sheets document on a public website.
It goes over the entire process, and it is not as hard as it seems. The good thing is that there are no special tricks or requirements needed.
Why Publish Excel Spreadsheets on the Web?
Many businesses use Excel files. They store customer records, financial information, sales data, and more within these files.
Most of the time they store this information locally, or sometimes on an external server.
Sharing data often involves a tedious process of sending emails back and forth. Sometimes the attachment is not included, or the wrong file or the wrong version is sent.
Because these documents go to and fro, no one is sure whether the document they have is the most up-to-date one. The solution to all these problems is a local intranet or a secure internet site for publishing data.
This ensures that everybody has access to current information. This may be inventory data, monthly sales figures, or something else.
Automatic updates to the information on the secure website or the intranet is a must. A secure website also makes it possible to access information from a mobile device, at any time and place.
That all sounds fantastic, but there remains one practical question. How to publish an Excel spreadsheet on the web?
Data Format Options
Excel spreadsheets may contain different types of data. These data types include currencies, numbers, text, and even visual data.
Excel also has different ways of visualizing information. It uses chart types like waterfalls and doughnuts.
To make it more complicated, sometimes it is necessary to export a combination of these data types. An example is stock prices that are shown in conjunction with a graph of last month’s performance.
Exporting this is possible in different formats.
Useful formats are JPG, PDF, HTML, and others. It’s possible to store numerical data as CSV, JSON, or XML.
HTML Web Markup
HTML, or HyperText Markup Language, is the coding language used for every website. The browser on a local computer is able to read the code and convert it to a visual representation on the screen.
It is possible to convert any kind of data format to HTML, including tables, graphs, and headings. Converting an Excel table to HTML means that a web browser can now read it and display it.
JSON is based on a system that pairs keys and values. It is especially suited for coding Excel data for online purposes.
JSON works directly with a web page and the data is also easy to import into a database.
XML is similar to the JSON format but has a longer history. In appearance, it is like HTML but it describes spreadsheet data.
In fact, Excel stores all workbook data in this format. This is an open standard so anyone can use it.
This makes it very practical. Anyone can open, edit, and import the information in an XML file.
The CSV format is the oldest of the spreadsheet formats that are still in common use. CSV stands for Comma Separated Values.
In this format, commas separate the fields. Instead of commas, it is also possible to use different symbols, like tabs.
CSV files are still commonly used. For example, MySQL databases make use of it.
How to Publish an Excel Spreadsheet on the Web
Start by opening the desired Excel spreadsheets in Microsoft Office Excel.
- Open the File
- Click Save As.
- At the bottom of the window, click on the down arrow of the drop-down menu.
- Select Web Page from the list.
- In the File Name box, type an appropriate name for the file.
- Click Publish.
Sheet Option Button
Change the Selection Option depending on whether part of the sheet is selected. If changes to the sheet are being saved, the button changes to Republish: Sheet.
If nothing is selected, Excel will by default save the entire workbook. It will include all the data in the HTML file.
To limit what gets included in the HTML file, select the appropriate items in the Choose List. It is possible to publish only one item at a time.
To continue publishing, select a different element and follow the procedure outlined above.
These are the publishable elements and a description of how to publish them:
- The whole workbook.
Select the whole workbook. Excel will publish it with all the associated interactivity.
It is not possible to publish it with the interactive elements.
- Complete worksheets.
Select the sheet names, then select All Content of the sheet.
Under Sheet Name select the desired items. Examples include PivotTable or a chart.
Items do not include cell ranges.
- Cell Ranges.
Select the cell ranges.
To select the right range, click on the worksheet. The dialog box will now collapse.
Now, select the range by clicking and dragging. Then click on the Expand Dialog Button:
Select Items on Sheet. Then select the appropriate Chart.
- Filtered ranges.
Click Select Items on Sheet and then apply the AutoFilter.
- External data ranges.
Select Items on Sheet name. Then select the query item
To republish part of a previously published workbook, click Previously Published Items. Select the elements to republish.
Alternatively, select Remove to prevent an element from publishing again. Finally, click a different item on the list to continue publishing.
It is also possible to add a page to the HTML file:
- Click the Change
- Type a heading in the Page Title text box in the Set Page Title box.
- Click OK. The title will appear in the middle at the top of the page.
This header is not the same as the web page title.
- Click Save.
- Close the Save As box.
By default, Excel saves a single worksheet as HTM, a Hypertext Markup file. It uses the .mht extension if publishing multiple worksheets.
Some file servers, in particular the ones that run on UNIX, are case-sensitive. So, keep the effect of capitalization in mind when choosing a file name.
Publishing with Interactivity
Adding interactivity allows visitors to work with the data in their browsers.
For example, it’s possible to publish an interactive sheet that calculates loan information. A visitor can use the sheet to calculate monthly payments by entering information like interest rate and loan amount.
To add interactivity, tick the box Add Interactivity. Then select the kind of interactivity.
The choices that Excel offers depend on the kind of document.
For a worksheet with formulas, an option is Spreadsheet Functionality. Users then use the web page to enter new values and make certain calculations.
PivotTable is an interactivity option for PivotTable. Users can rearrange data by changing the layout of columns and rows.
This allows them to have a different view of the data. The Spreadsheet functionality is available for filtered range Excel spreadsheets.
The Chart option will appear for PivotChart reports. The chart will not appear on the web page when an interactive chart is published through Excel.
Publish the chart separately to include the chart on the web page.
Use Google Docs
In recent years Google Docs has become more and more popular. It is another great option for embedding spreadsheets into a web page.
It is simple and is very convenient to work with when there are many changes to make to the spreadsheet.
Changes made to the Google Sheets document are reflected on the web page. So it is not necessary to perform any additional tasks.
To use Google Sheets for publishing spreadsheets:
- Open the Google Sheets document.
- Update the data as needed.
- Go to File.
- Click Publish to the Web.
- Start posting.
- Copy and paste the shortcode that it generates.
The best way to publish an Excel sheet on the web is with WordPress and wpDataTables
The most classy way for publishing Excel with WordPress is through wpDataTables, the best WordPress plugin for tables and charts.
Here’s how easy it is to import Excel in WordPress:
And you can get more info about the process through our documentation page for importing data from Excel, CSV, or Google Spreadsheets.
If you enjoyed reading this article on how to publish an excel spreadsheet on the web, you should check out this one on how to delete WordPress themes.
We also wrote about a few related subjects like how to watermark images, how to check the WordPress version, creating a comparison table with WordPress plugins, how to upload an HTML file in WordPress, where are WordPress pages stored and why is WordPress so hard to use.