Tools to Capture and Convert the Web
GrabzIt's Online Community

Table to CSV conversion issue

Ask questions on how to capture or convert web pages or HTML into images, CSV, PDF or DOCX documents as well on how to convert videos into animated GIF's using our API.

Sometimes when I convert a table to a CSV, the formatting of the information is different when I check the CSV result. This is most prevalent when the table in question has multiple headers. Here's a link to an example table in which this issue occurs: https://www.sec.gov/Archives/edgar/data/320187/000032018720000018/R2.htm

Does anyone have an idea on how to fix this issue?

 

Asked by anonymous on the 16th of November 2020

Currently row and column spans are not handled in html to CSV. I have raised a case to look into the issue 

Answered by GrabzIt Support on the 16th of November 2020

This is now fixed. The rowspans and colspans are now normalised so that it properly handles being converted to CSV and other formats that don't support spanning multiple columns and rows.

Answered by GrabzIt Support on the 17th of November 2020

Thanks a lot for the quick response and fix. 

Answered by anonymous on the 17th of November 2020

No problem.

Answered by GrabzIt Support on the 17th of November 2020