Convert HTML-table to Excel (office 2016)

Question

Convert HTML-table to Excel (office 2016)

Anonymous

Trying to convert an HTML-table to an Excel table.

The problem is that Excel changes the table in the following way:

Text converted to date
Numbers in parentheses are now negative.
Numbers are rounded or truncated.
All horizontal lines are removed.

Example of problem:

Below is an example of a HTML-table opened in Excel 2016 by right-clicking the table, choosing "open with excel".

Is this possible to do? (without having manually revert the changes).

Example table

https://raw.githubusercontent.com/rasmusrhl/stuff/master/table.html

Example table (as webpage:

https://rasmusrhl.github.io/stuff/

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

2 answers

Answer 1

Hi Rasmus,

Converting an HTML-table to an Excel table might need the use of VBA. In order for us to provide more advanced support, we recommend posting your concern on our developer forum. You can post it by clicking on this link.

Let us know if you have further concerns.

Regards.

Answer 2

Anonymous

Hi,

take a look here, maybe could help..

http://www.convertcsv.com/html-table-to-csv.htm

Share via

Convert HTML-table to Excel (office 2016)

2 answers