Excel summary table is made into an interactive web page: calculations and charts can be viewed at any time

Key points of this article

Summary tables that require repeated viewing and switching of calibers are suitable for interactive web pages, while ordinary files can be retained for one-time finalization.
Before exporting, use several key figures in Excel as a benchmark to check whether the summary and chart in the web page are consistent item by item.
The structure of the pivot table may not be retained as it is. It is recommended to organize the results into a common summary table before placing it in the document.
The webpage will be forwarded, and sensitive columns such as employee salaries and customer phone numbers will be deleted before publishing, and only summary columns will be retained.

Many people have an Excel summary sheet in their hands: monthly sales, expenses of each department, project progress, and several charts hanging at the bottom. After sending it to colleagues, they can only see the numbers at a certain point in time. If they want to change the caliber or look at a certain area, they have to ask you to do the calculation again. By making this table into an online table web version, readers can directly view the calculation results and charts in the browser, and can also switch the viewing range themselves.

This article is written for people who need to report data to leaders, customers or partners on a regular basis. After reading, you will know: which summary tables are suitable for making interactive web pages, how to build a dynamic document with real-time calculations and charts in OmniDoc, and how to check whether it is reliable after exporting.

Should the summary table be made into an interactive web page? One sentence conclusion

Conclusion: When readers need to check repeatedly, switch conditions, or calculate while reading, it is more suitable to make an interactive web page; when only one final draft is needed, keep an ordinary file.

your situation	Recommended practices	reason
Only show the final draft to the leader once	Keep PDF or Word version	Numbers will not be mistakenly changed, and the reading order is fixed.
The same table is updated every week, and the other party checks it repeatedly	Create dynamic documents and export web pages	Calculations and charts are updated with the data, eliminating the need to resend the file each time
The other party needs to switch the month or region by themselves	Add interactive tables and real-time calculations to web pages	Readers can see the results under different calibers, reducing the need to ask questions back and forth.
There are many formulas in the table and someone needs to check them	Keep calculation instructions and check against baseline numbers	The origin of each number is easier to trace
Data contains sensitive information	Delete sensitive columns first, then publish summary version	Once the web link is forwarded, the data leaves your control

Scenario: Send a sales summary to multiple managers every month

Xiao Zhou sends sales summaries to the heads of five regions every month. The table contains a 12-month detailed table, a regional summary table, and three charts: trend line, regional column, and proportion pie chart. In the past, Excel was sent out once a month, and the person in charge often asked "How did the figures for the last quarter in East China come from?" or wanted to see a certain product line but could only wait for his reply.

What he wants is a link: when he opens it, he can see new calculation results and charts, and he can switch regions and months by himself. In this way, his monthly workload can be reduced, and the person in charge does not have to wait.

Complete process

Organize data sources. In Excel, organize the detailed data according to unified column names, remove merged cells and blank rows in the middle, and use the same format for date columns.
Find the benchmark numbers in Excel. First calculate the key indicators such as total amount, year-on-year and proportion, and write down a few numbers for later verification.
Create a new dynamic document. Create a new dynamic document in OmniDoc, put the summary table and explanatory text into it, and divide the chapters into chapters by area. The specific entrance is subject to the current version of the client.
Insert charts and real-time calculations. Charts and tables should reference the same set of data to prevent tables and charts from being calculated separately. When values change, they should be synchronized.
Set the content that readers can view. Schedule interactions as per your readers' needs, allowing them to view results for different regions or months.
Compare to benchmark figures. Use the numbers noted in step 2 to check whether the summary and charts in the web page are consistent with the original Excel table.
Export to HTML. OmniDoc's dynamic documents can be exported as interactive HTML. After exporting, they can be opened once in two browsers and viewed again on the mobile phone.
Share and date. Send the exported file to readers, indicate the data expiration date, and retain the original Excel file as the data source to facilitate subsequent tracing and updating.

Where things can easily go wrong

Web page numbers are inconsistent with Excel. When discovering, look at the data type first. Numbers in text format are not included in the sum, resulting in a result that is too small or zero. The solution is to uniformly change these cells to numerical format, and then re-compare the baseline numbers.
Chart range is not extended accordingly. After adding a month, the horizontal axis of the chart may still stay at the old position. After each data update, check whether the data range of each chart contains a new row.
The pivot table structure is not preserved as is. Do not assume that the layout and refresh methods of the pivot table will be completely carried over. A safer approach is to organize the perspective results into a common summary table first, and then put it into the document for inspection.
The web page and Excel are modified at the same time. After a long time, it is easy to lose track of which version is the new one. The solution is to only modify the data in the original Excel table, re-export it after each update, and indicate the date on the page.
Sensitive information is leaked with the web page. Employee salary, customer phone number, bank account number, etc. columns should not appear in summary web pages. Check column by column before publishing, and only retain the fields required for summary caliber.

🎯 Which method is suitable for you?

If you only need one final draft

Just keep the PDF or Word version, there is no need to create an interactive web page for a one-time report. Finalized documents are also more stable in transit.

If you are going to update weekly, show it to the same people over and over again

Create a dynamic document, using the original Excel table as the data source, and export a new web page after each update, allowing readers to use the same entrance to view new results.

If your readers need to switch the caliber themselves

Focus on the interactive section, placing filtering by region, month, etc. on the webpage, while keeping calculation explanations in the document to help others understand the source of each number.

If the table contains sensitive information

First, delete the sensitive columns and only make the summary results into a webpage. Before publishing, please confirm which data can be made public to avoid problems if the webpage is forwarded.

❓ Frequently Asked Questions (FAQ)

1. If you don't have a pivot table, can you create an online pivot table?

The approach in this article is to organize the summary results into tables and charts, then create interactive web pages. The steps for generating pivot tables are not covered in this article. You can first complete the pivot in Excel, then put the results into the document.

2. Can exported web pages be opened offline?

This depends on the format of the exported file and the reader's browsing environment. It is recommended to use a computer without an internet connection to open the system once and confirm everything is correct before deciding on the sending method.

3. What should I do if the chart is hard to read on my phone?

Chart tag overlap is usually caused by category names being too long or too many series on the same screen. You can shorten the category names in the source table or reduce the number of series in the same chart, then export the checks again.

4. Will the webpage automatically update after modifying Excel?

It depends on whether the data is maintained directly in dynamic documents. If you only make changes in Excel, you usually need to re-enter the data into the document and export a new webpage.

📝 Summary

For Excel summary tables that need to be repeatedly viewed and switched, making an online web version of the table is more convenient than reposting the file every time. First, organize the source data, cross-check with benchmark numbers in Excel, then export the interactive webpage, so readers can see new calculations and charts at any time.

Open OmniDoc and process your table file