-
How to Import Data from Website in LibreOffice Calc
almost 10 years ago
-
almost 10 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.
-
almost 10 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.
-
almost 10 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)