Import external data - in more than just one column

[sci_citation]

I am trying to get this table:

http://services.datasport.com/2014/zkb/maennedorf/RANG091.HTM

into an LO Calc spreadsheet.

The fundamental “import” is done via Insert > Link to External Data... then paste in the URL from above and choose HTML_2 from the available tables.

However - this only leads to a direct import of the online-table into one single column in my spreadsheet.

Is there an option somewhere to specify the “cell-separation”? (something like when you’ll import a csv-table. There you’ve got some options - either fixed column-widths or to specify a character for cell-separation e.g. or “;” or “,” etc.)

[ROSt53]

I could create a Calc sheet with each column of the original table in a separate Calc column.

• Select table at homepage
• Copy to clipboard (xtrl+c)
• Opened Notepage and pasted (ctrl+v)
• Saved Notepad file (txt format9
• Right clicked > open with > Calc => Import screen of Calc pops up
• CSV Import settings: