html tables are killin' me.
June 14, 2012 6:12 PM Subscribe
How do I import tables from HTML into Excel when some cells have multiple lines?
posted by KGMoney to computers & internet (6 answers total) 1 user marked this as a favorite
OK, so I've been given an output of a table in HTML, and I need to get it into a spreadsheet so I can work with it. The cells are all text, and while a lot of the cells are single-line, there are 20%+ that show up as multiple lines in the cell.
Problem: When I try to paste the table into Excel, all of the cells with multiple lines end up as separate cells in the table, which means I can't sort them. I could probably consolidate each group of cells, but this table has several thousand entries, so I can't just go through, find each offending cell and fix it, I need a global solution. It doesn't matter if I have to run it through another tool to remove breaks, or whatever. I'm just not quite sure how to fix it, and google isn't helping me.
The data is sensitive, so I can't provide a screenshot. Hopefully the description I'e given makes sense. if not, I can modify the data and post an example.