Ask Your Question

html table -convert-to csv, strange characters [closed]

asked 2014-02-25 16:31:40 +0200

gigaelektro gravatar image

updated 2015-09-11 21:59:47 +0200

Alex Kemp gravatar image

hi, i'm using

libreoffice --headless -convert-to csv ./evprice.xls

to convert a html table to a csv file. when i open the output csv file it contains a lot of strange characters, just like when opening an exe file in notepad.

here are some of the characters óz·³VV®<s&žF$Ö:u,+Ïó㼌2²zggg

when i open the html table in libreoffice manually it all works great, but i need a command line solution.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 16:58:00.731180

2 Answers

Sort by » oldest newest most voted

answered 2014-02-25 23:26:12 +0200

m.a.riosv gravatar image

Maybe is an issue with the character set, but you can attach directly a html table in calc with:
Menu/Insert/Link to external data, select the html file, and select the table to import. There some options about it in Menu/Tools/Load-Save/HTML compatibility.

edit flag offensive delete link more


i'm using the command line version

gigaelektro gravatar imagegigaelektro ( 2014-02-28 15:57:02 +0200 )edit

answered 2014-02-28 16:02:41 +0200

gigaelektro gravatar image

i don't know what's changed but now theres html in the csv file. it's not exactly the same html as in the original table so libreoffice did do something to it but still not converted to csv.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-02-25 16:31:40 +0200

Seen: 612 times

Last updated: Feb 28 '14