Analyzing web content is a common requirement of a web developer. In this condition, converting the content from html to Excel is becoming a necessary requirement. Through the Excel sheet, developers can easily analyze complex content in the form of tables and structured data.
To convert the data into a CSV or XLXS format, several methods are available on the market. If you are a beginner and don’t know how to export html files into Excel, then this blog is for you. This blog will examine how to convert the default HTML file to Excel format.
Best Method To Convert Data HTML to Excel
In the market, several best methods for HTML to Excel conversion are available. These methods help in website development to understand the data. Here are some methods of convert default download from html to Excel are outlined below:
1. Convert HTML to Excel with JavaScript
By using this method, you can export HTML table to Excel through the Javascript library. To convert it, you first have to generate the table using the getElecmentByID() function. Then, use the javascript library “TableToExcel” for JavaScript HTML to Excel export. You can download HTML content as Excel by outlining the code.
Code:
<!DOCTYPE html>
<html lang=”en”>
<head>
<meta charset=”UTF-8″>
<meta name=”viewport” content=”width=device-width, initial-scale=1.0″>
<title>Export HTML Table to Excel</title>
</head>
<body>
<table id=”dataTable” border=”1″>
<tr>
<th>Name</th>
<th>Age</th>
<th>City</th>
</tr>
<tr>
<td>John Doe</td>
<td>30</td>
<td>New York</td>
</tr>
<tr>
<td>Jane Smith</td>
<td>25</td>
<td>Los Angeles</td>
</tr>
</table>
<br>
<button onclick=”exportTableToExcel(‘dataTable’, ‘table_data’)”>Download as Excel</button>
<script>
function exportTableToExcel(tableID, filename = ”) {
let downloadLink;
let dataType = ‘application/vnd.ms-excel’;
let tableSelect = document.getElementById(tableID);
let tableHTML = tableSelect.outerHTML.replace(/ /g, ‘%20’);
filename = filename ? filename + ‘.xls’ : ‘excel_data.xls’;
downloadLink = document.createElement(“a”);
document.body.appendChild(downloadLink);
downloadLink.href = ‘data:’ + dataType + ‘, ‘ + tableHTML;
downloadLink.download = filename;
downloadLink.click();
document.body.removeChild(downloadLink);
}
</script>
</body>
</html>
2. Converting HTML Table To XLSX With SheetJS
It is another method that is used to convert HTML table to XLSX. In this method, we used the js library “SheetJS (xlsx.js) ” in the js code. With the help of HTML5 Excel export solutions it helps users to how easily they can convert the HTML files in various Excel spreadsheets.
Through this code, you can help to convert your html file into a spreadsheet.
Code:
<script src=”https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.17.0/xlsx.full.min.js”></script>
<script>
function exportToExcel() {
let table = document.getElementById(“dataTable”);
let workbook = XLSX.utils.table_to_book(table);
XLSX.writeFile(workbook, “table_data.xlsx”);
}
</script>
<button onclick=”exportToExcel()”>Download as XLSX</button>
3. Exporting HTML Data To CSV Format
Comma-separated values(CSV) files are widely used for data analysis and can be easily opened in Excel. Here are some methods to export HTML data to CSV.
This method is best for those who want to prevent the code. CSV files are famous for analyzing data. This can be easily opened in Excel format. You can first convert your HTML file into CSV and then download it into the Excel sheet.
You can get help from this code to the HTML export button to Excel.
Code:
<script>
function downloadCSV(csv, filename) {
let csvFile;
let downloadLink;
csvFile = new Blob([csv], { type: ‘text/csv’ });
downloadLink = document.createElement(“a”);
downloadLink.download = filename;
downloadLink.href = window.URL.createObjectURL(csvFile);
downloadLink.style.display = “none”;
document.body.appendChild(downloadLink);
downloadLink.click();
}
function exportTableToCSV(filename) {
let csv = [];
let rows = document.querySelectorAll(“table tr”);
for (let row of rows) {
let cols = row.querySelectorAll(“td, th”);
let rowData = [];
for (let col of cols) {
rowData.push(col.innerText);
}
csv.push(rowData.join(“,”));
}
downloadCSV(csv.join(“\n”), filename);
}
</script>
<button onclick=”exportTableToCSV(‘table_data.csv’)”>Download as CSV</button>
Conclusion
Converting the HTML data to Excel file helps the developer understand the data. For beginner and experienced developers, it’s a good step to resolve their tasks. If you are facing issues converting the html file to a spreadsheet. Then our mentioned tricky methods are helpful to you. By following this method, you can make your way easy.
In this blog, we tell you different methods to covert the ideal html to an Excel sheet. Also, the code may reduce the time and help to complete the work.
Frequently Asked Questions
1. How Do You Convert An HTML File To Excel?
To convert the html file to an Excel spreadsheet, you have to outline these methods.
- Convert it through the Java script
- Convert html file to Excel by Sheetjs
- Tranform html file to Excel via CSV format
2. How Do You Convert HTML To CSV Format?
Through the Html library, extract the data from the html sources and organize them tabularly. Then, save the extracted data by using the CSV library. Convert it into an Excel sheet.
3. How Do Simple Methods Convert HTM Files Into Excel?
- Upload the file and Select the HTM file.
- Set the conversion options in Excel output format.
- Convert the file and download it into excel.
4. How To Convert A Web File To Excel?
- Open the Excel file
- Go to the Power Query tutorial
- Create the Power query tutorial on the sheet
- Import the web data
- Select data and transform it into the sheet
