Title: HTML upload garbled
Last modified: August 20, 2016

---

# HTML upload garbled

 *  [rvbinder](https://wordpress.org/support/users/rvbinder/)
 * (@rvbinder)
 * [15 years, 3 months ago](https://wordpress.org/support/topic/html-upload-garbled/)
 * I saved an excel xlxs as html, and then uploaded. The result is garbled: the 
   row/column mapping is completely off.
 * Please advise.

Viewing 6 replies - 1 through 6 (of 6 total)

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [15 years, 3 months ago](https://wordpress.org/support/topic/html-upload-garbled/#post-2118340)
 * 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
 *  Thread Starter [rvbinder](https://wordpress.org/support/users/rvbinder/)
 * (@rvbinder)
 * [15 years, 3 months ago](https://wordpress.org/support/topic/html-upload-garbled/#post-2118384)
 * Here’s a link to page with the garbled table.
    [http://www.robertvbinder.com/home/thought-leadership/articles/biblography/](http://www.robertvbinder.com/home/thought-leadership/articles/biblography/)
 * You should be able to view/download the html file from
    [http://www.robertvbinder.com/pubs-list.html](http://www.robertvbinder.com/pubs-list.html)
 * Thanks
    Bob
 *  Thread Starter [rvbinder](https://wordpress.org/support/users/rvbinder/)
 * (@rvbinder)
 * [15 years, 3 months ago](https://wordpress.org/support/topic/html-upload-garbled/#post-2118389)
 * 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.
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [15 years, 3 months ago](https://wordpress.org/support/topic/html-upload-garbled/#post-2118399)
 * 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
 *  Thread Starter [rvbinder](https://wordpress.org/support/users/rvbinder/)
 * (@rvbinder)
 * [15 years, 3 months ago](https://wordpress.org/support/topic/html-upload-garbled/#post-2118411)
 * 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
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [15 years, 3 months ago](https://wordpress.org/support/topic/html-upload-garbled/#post-2118580)
 * 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

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘HTML upload garbled’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/wp-table-reloaded_f7dcd3.svg)
 * [WP-Table Reloaded](https://wordpress.org/plugins/wp-table-reloaded/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-table-reloaded/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-table-reloaded/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-table-reloaded/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-table-reloaded/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-table-reloaded/reviews/)

 * 6 replies
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [15 years, 3 months ago](https://wordpress.org/support/topic/html-upload-garbled/#post-2118580)
 * Status: not resolved