Hi,
it is hard to tell what caused this, without seeing the HTML file.
So, it would be great, if you could upload that somewhere.
Also, please try saving to CSV and importing that. That’s actually a “more recommended” way for Excel files.
Regards,
Tobias
PS — the file has commas in many fields, and I want to preserve the links where they exist. Excel doesn’t support setting a non-comma csv delimiter on output, afiak.
Hi,
thanks for the link!
I assume that the reason for this problem is the not really valid HTML in the file. Excel does a bad job there, as it adds attributes to the tags without properly wrapping them in quotation marks. That likely throws the import library off.
For the CSV: You are correct that Excel uses commas as the delimiter, it does however correctly escape commas in cells. This is detected by the import library, so you should actually have no problems with the CSV file.
Regards,
Tobias
The csv export is correctly parsed for rows/columns.
But, none of the hyperlinks are transfered, so I think I’ll hand hack the Excel output and just paste that in. Also there are some unicode (Chinese) characters that are dropped.
Anyway, thanks for the prompt follow up — these limitations aside, this is a very nice tool with great documentation.
Bob
Hi Bob,
yes, the hyperlinks seem not to be exported to CSV by Excel 🙁
And those Unicode characters likely get lost during some kind of character encoding conversion… :-/
Best wishes,
Tobias
