Hi @AbhijithS,
I will show you how to do it step-by-step on the website https://organicchemistrydata.org/solvents/ that shows a table of chemical solvents with different characteristics.
On JMP, click on "File", "Internet Open" and then "Web Page..." and insert the URL of the website you would like to use data from and click on OK :
![Victor_G_3-1702368892607.png Victor_G_3-1702368892607.png](https://community.jmp.com/t5/image/serverpage/image-id/59545i5711B5D2D80710D5/image-size/medium?v=v2&px=400)
![Victor_G_0-1702368478508.png Victor_G_0-1702368478508.png](https://community.jmp.com/t5/image/serverpage/image-id/59542iA9C3B836135B2069/image-size/medium?v=v2&px=400)
Then, JMP will show you the tables it has found automatically on the website. You can select all or select only the ones you are interested in, and then click on OK :
![Victor_G_1-1702368551470.png Victor_G_1-1702368551470.png](https://community.jmp.com/t5/image/serverpage/image-id/59543iC66CB2B393F01961/image-dimensions/364x205?v=v2)
JMP will then provide you a datatable with the informations directly extracted from the website table(s). There may be some correction/cleaning needed (for column formats/types, missing values, ...), but overall it is doing a good job :
![Victor_G_2-1702368640651.png Victor_G_2-1702368640651.png](https://community.jmp.com/t5/image/serverpage/image-id/59544i95CB8ECF958DAE5A/image-size/medium?v=v2&px=400)
You also have a script "Source" in your datatable that contains the informations about how and where the data has been collected. In this case, it contains this script, used to retrieve the data and create the datatable :
Open(
"https://organicchemistrydata.org/solvents/",
HTML Table( 1, Column Names( 1 ), Data Starts( 2 ) )
)
Hope this answer will help you in your task
Victor GUILLER
Scientific Expertise Engineer
L'Oréal - Data & Analytics