evernote/html conversion to excel

[metropical]

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; min-height: 14.0px}span.s1 {font: 12.0px 'Hiragino Kaku Gothic ****'}</style>evernote allows one to export as html or evernote.
I'd like to turn an Evernote into an excel sheet.
It's totally unsupported by Evernote.


Has anyone an idea of how I could convert the html export into an Excel (or Pages) sheet?
I won't use an online "app" as there are passwords.


Excel will, of course, open the html files, but the Evernote delimiters remain, in multiples per entry.
I haven't been able to delete the multiple instances of delimiters and replace with tab.


the delimiter is ゠(actually space(s) ) , but there are a varying number of them per line.


The html export from EN is clean, just a varying length space between words, as below.


PJM [there is a longer space here that doesn't show in the phorum] althos12345


The same from Excel import of the EN html export.


PJM ゠ ゠ ゠ ゠ ゠ ゠ ゠ ゠ ゠ ゠ ゠ ゠ ゠ ゠ ゠ ゠ ゠ ゠ ゠ ゠ althos12345

 

[chicagocomputerclasses]

Have you tried using text to columns fixed width option to split the results?

Or use Data->From Web option and direct the browser to your local HTML file using file:///C:/fullpathtoyourfile.html

 

[metropical]

not sure what or where to find that. but I have ended up using Find/Replace and entering multiple spaces and/or tabs as required to reduce to a manageable edit