After following the guide to display the excel table on this web page, You no longer need to install any plugins to create tables that suit your needs. You can even add formulas to each cell in the table.
You may have or want to insert tables in web pages for any purpose, if you create a table using the normal method (table block in WordPress or text editor in Joomla) You may find it difficult to set up the table view. You may have to use a plugin to create a table that suits your needs.
By using Google Spreadsheet You can insert excel tables in web pages. With this way, You can do anything in the table as you normally do in the Application Excel. An example is the table below, Several columns in this table use formulas, You can also move between sheets.
In this guide, Mahmudan will show you how to display an Excel table on any web page without using a plugin. Follow these steps
Steps to Display Excel Tables on Web Pages
Steps 1: Upload file Excel ke Google Drive
![Tricks to Display Excel Tables on Web Pages without Plugins: 6 Practical Steps 2 upload file Excel ke Google Drive](https://www.mahmudan.com/wp-content/uploads/2024/01/upload-file-Excel.jpg)
Create a table in Excel according to your needs, then upload to Google Drive web, You must have a Google account to do this. The example used here is the Salary-Employee.xlsx file
Steps 2: Open the Excel file with Google Sheets
![Tricks to Display Excel Tables on Web Pages without Plugins6 LaPractical Steps buka file excel dengan google spreadsheet](https://www.mahmudan.com/wp-content/uploads/2024/01/buka-file-excel-dengan-google-spreadsheet.jpg)
On the Google Drive web page, Right click the Excel file then select Open with then select Google Spreadsheet. The Google Sheets page will open in a new tab.
Steps 3: Publish to the Web
![Tricks to Display Excel Tables on Web Pages without Plugins: 6 Practical Steps 4 publikasikan file excel ke web](https://www.mahmudan.com/wp-content/uploads/2024/01/publikasikan-file-excel-1.jpg)
Once the file opens in Google Sheets, click the File menu then select Share then select Publish to the web
Steps 4: Embed Files
![Tricks to Display Excel Tables on Web Pages without Plugins LanPractical Steps sematkan file](https://www.mahmudan.com/wp-content/uploads/2024/01/sematkan-file.jpg)
In the dialog box Publish to the web, select tabs Pin it then click the button Publish. Warning message Confirmation will appear at the top of the browser tab, click OK to confirm.
Steps 5: Copy Embed Code
![Tricks to Display Excel Tables on Web Pages without Pluginsgin:Practical Stepstis 6 salin kode semat](https://www.mahmudan.com/wp-content/uploads/2024/01/salin-kode-semat.jpg)
Once you confirm the warning message, The embed code will appear. Copy the embed code and then paste it on your web page.
Steps 6: Paste Excel File Embed Code on Web Page
![Tricks to Display Excel Tables on Web Pages without Plugins LanPractical Steps paste Kode Semat File Excel di Halaman Web](https://www.mahmudan.com/wp-content/uploads/2024/01/tempelkan-kode-semat-file-excel-di-halaman-web.jpg)
If you use WordPress, in a page or article select a block Custom HTML, then paste the code. This step is the same as when you pin <iframe></iframe> in HTML in general. If you use Joomla, in the text editor, look for the buttonInsert CodeorEdit HTML Source then paste the code.
Tips: To set the frame display size, You can add properties width=”100%” height=”260″ inside an iframe like the example below
<iframe src="https://docs.google.com/spreadsheets/d/e/2PACX-1vSxBqqX30A2cNbsoDzzjDX9jp9lLIyxlEkBvjkmQ7MS4jOopodO35h5IRKnQG1mlw/pubhtml?widget=true&headers=false" width="100%" height="260"></iframe>
Results
The results are as you can see at the top of this guide. The following is a screenshot of the results of displaying an Excel table on a web page
![Tricks to Display Excel Tables on Web Pages without PluginsgkahPractical Steps menampilkan tabel excel di halaman web](https://www.mahmudan.com/wp-content/uploads/2024/01/menampilkan-tabel-excel-di-halaman-web.jpg)
One thing to remember, to make changes to the table, You have to do it in Google Drive.
Hope it is useful.