Huge table excel into html
Hey everyone! I have an Excel file containing structured table that I need to convert into clean, readable HTML code (ideally including a table). Does anyone know of a tool or software that can help
-i have multiple files so if i want to make them manual it will take too long
Thanks in advance!
6 Replies
have you tried looking online for a tool that would convert spreadsheet to a html table ?
i tried this
https://tableconvert.com/ but didnt work
and this software kutools for excel
but gave me a terrible html code (not clean)
Table Convert Online
Table Convert Online - Simplify Your Table Conversion ...
Effortlessly convert Excel (or other spreadsheets) to Markdown Table. Utilize the Table Editor to create and modify Markdown Table online.
this the result of kutools but the code is not clean at all
Maybe dump them to CSV, & use a component that converts CSV to a table?
ok i will try
still doesn't work
LibreOffice Calc has a Export feature, which supports html. The issue is that the styling gets applied too, and the column widths get set for each column, which makes the output very big
~580kb for the file you shared
your best bet is probably to use something like that and then use prettier, and search and replace with some regular expressions, to clean up the output to the point it's usable to you