Formula for Spreadsheet to import data from URL

Completed Posted 4 years ago Paid on delivery
Completed Paid on delivery

I am trying to import data from this URL: [login to view URL]

What I need is to import name, score and release date into my google spreadsheet.

Tried this one but did not find any table

=IMPORTHTML("[login to view URL]", "table", 6)

Excel Data Entry Data Processing Web Scraping

Project ID: #22127724

About the project

48 proposals Remote project Active 4 years ago

Awarded to:

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I am Excel and Web Scrapping Expert on freelancer.com and have been featured by the freelancer community (goo More

€100 EUR in 2 days
(816 Reviews)
8.8

48 freelancers are bidding on average €29 for this job

jkaranm

Hi Future Client, I’m Janis and I’ve been here in freelancer since 2014 together with my team. I’m one of the preferred freelancers because of my good standing and good feedback from previous employers. I was asked by More

€35 EUR in 1 day
(114 Reviews)
8.9
bouslimi1979

Hi, you need a script not a formula... I can code a VBA macro which will run on Excel to get all the data which is displayed in many pages. After that you can import the file into your google sheet

€50 EUR in 1 day
(324 Reviews)
7.9
sohandas

you have to use xpath expression in order to get the actual data, please message me for more details..................thanks!

€30 EUR in 1 day
(386 Reviews)
8.0
gangabass

I can provide you a simple Google Spreadsheet script that will import above table into your sheet (your code doesn't work because it's not a table but a series of LI elements).

€30 EUR in 1 day
(466 Reviews)
7.8
dgled

Hi, I am financial experts and a guru in Microsoft Office/Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application (automation) including preparation of gra More

€50 EUR in 2 days
(94 Reviews)
7.2
TonmoyRoy111

Dear client, I can write the formula for you.. I ensure you will be happy after hiring me. Kindly contact me. Roy

€100 EUR in 1 day
(455 Reviews)
7.3
onlinejob247

Okay. I have huge experience in working with these projects. If you need sample work just send me a message. Waiting for your quick reply.

€30 EUR in 1 day
(154 Reviews)
6.8
bertythomas

Hi, I can create an API for you using which you can pull this data. The API can output in TXT/ CSV/ EXCEL or any other formats as per your need. You will be able to use that API in your google spreadsheet. Lets discu More

€20 EUR in 1 day
(31 Reviews)
6.6
kayemhussain

Dear hiring manager ,, Fully understand your requirements & i am ready to start your work now & deliver to you within next 8 hours.I am highly experienced .Please sir give me a chance .I will start your work now. T More

€19 EUR in 1 day
(62 Reviews)
5.9
sonarkaushik

Sir,      I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. Regards

€28 EUR in 2 days
(110 Reviews)
6.3
bianyunzhi95

Hi. Nice to meet you. I am really good at web scraping. I will satisfy your demands and requirements. Hope your reply. Best regards.

€30 EUR in 1 day
(15 Reviews)
5.9
Ahmed818

Hello, i am expert in this kind of jobs i can write vba code inside excel or google sheet to extract data from website samples of my VBA jobs https://www.freelancer.com/projects/excel/Create-Excel-Spreadsheet-Macr More

€8 EUR in 1 day
(92 Reviews)
5.4
saniahayat

♚♚➤➤Hi there➤➤♚♚I am ready to start your work right now. I will impress you with my work and will do good job for you. 10 Year experienced in Excel, word, typing, data scraping, Web scraping.

€75 EUR in 1 day
(21 Reviews)
5.0
Rina247

Hello! I’ve read your job description & I am very much interested in working on your project. I have a good experience of the works. I am the right candidates for this task. I am a quick, reliable and efficient worker More

€19 EUR in 7 days
(56 Reviews)
5.2
serdaryalcin

Hi, If you have Microsoft Excel, I can share with you a small macro that can pull data from the website. And I can share with you the macro. Regards,

€19 EUR in 7 days
(24 Reviews)
4.7
IshaqKN

Hi there, Let me write short Python script for your required task. Best regards, Ishaq

€15 EUR in 3 days
(21 Reviews)
4.5
toolpusher

Hey, You tried, I could give this a try using another query. Get in touch lets see.. I am readily available now

€20 EUR in 1 day
(15 Reviews)
4.4
NayaPakistan

Hello there. I can create a formula to import name, score and release date into your google spreadsheet.

€30 EUR in 1 day
(9 Reviews)
4.2
USAWebExpert

Hi There, I have an expert team of data scrapping from url. Need to discuss over chat PM? It will be done through python.

€120 EUR in 7 days
(11 Reviews)
4.1
Touhid3331

Hi, Your Job almost done. How many data do you need? Looking forward to our chat. Thanks Touhid H

€10 EUR in 1 day
(6 Reviews)
4.0