Thursday, September 20, 2012

Copying HTML tables to Excel

Forgot how I was able in the past to get complex web tables to properly get put into an Excel worksheet (my former MFL, aka Master Feature List).  I now remember, thanks to this post, that what I would do is:

  • Open the page in question in IE
  • Save locally
  • Add a stylesheet in the header to get the next step to work correctly
  • <STYLE type="text/css">
    br {mso-data-placement:same-cell;}
    </STYLE>

  • Resave the local HTML page
  • Open the local HTML page in IE
  • Copy and paste from IE into Excel
  • Wha la, just what I wanted.



No comments: