-
How to Import Data from Website in LibreOffice Calc
over 8 years ago
Hi Guys,
I need to import data from a website, Like a Website ( http://ss64.com/nt/ ), which provide list of commands and their description.
I want these command and description can directly import to my local LibreOffice Calc Sheet columns seprately.I already search on internet but most of Tuts and QandA only Showing the method for MS Office. Like this website:
http://www.internet4classrooms.com/excel_import.htm.
Can anybody help me out. Any step by step explanation on this issue is much appreciated.
-
over 8 years ago
In continuation to my answer, here's something useful and fun:
Copy the following formula in cell B1 (assuming your data starts in A1): SUBSTITUTE(TRIM(A1)," ","*",1)
Copy down the above formula to the rest of the cells
Select column B
Go to Data--> Text to column...
Check "Other" and put "*" there (without double quotes)
Press Ok
Your Data should be split and formatted in a nice usable table.
-
over 8 years ago
Here are the steps:- Select the starting cell where you want the imported data to be placed
- Go To Insert --> Link to External Data...
- This will open an "External data" dialog box where you need to put in the url of the source and press Enter.
- This will bring up "Import Options" asking you to select a language to import. Select Automatic.
- This populates the list box with HTML elements. Select HTML_Tables.
- In case, you want your data to automatically refresh, there is an option to set the frequency at which the data will be refreshed.
- This should populate your sheet with the required data.
-
over 8 years ago
Hi Sir ( @nitin.joshi) Thanks you so much sir for the step by step and detail explanation. Few hours back it is tough task, Now It is looking easier now. Thanks you once again
-
3 Answer(s)