Завершен

Excel: Determine if the URL inside a cell loads correctly

Hi,

I have a Table with data on around 15000 Products, including the URLs of product images. Some of these URLs dont work, they dont load the image requested and gibe a 404 error.

Each product has 4 image URLs. I need you to create four rows next to the product data saying whether or not the image can be loaded.

Since there are 15000 entries this obviously needs to be automated, which should be not problem using a Macro or VB. Please write Waterloo in your application so I know you read the requirements. Ideally you would make a script that can update itself so I can update many URLs at a time and recheck them if they work or not.

Attached is a sample of 20 rows of data so you can see the file structure. The actual file has 15000.

Навыки: Excel, Веб-скрейпинг, Обработка данных, Excel VBA, Excel Macros

Показать больше: url inside csv, excel creat file makro cell name, excel data validation empty cell 2007, excel check hyperlink valid, vba check if website is open, check url validity in excel, excel function to check url, check url status in excel, excel check if hyperlink exists, how to check url is working or not in excel, validating url in excel, visual basic excel open url, excel code paste cut cell csv, excel check url, copy contents cell excel using macro, listview inside cell, excel vba lookup cut cell, excel copy content several cell, excel macros check data cell, php display url inside page

О работодателе:
( 12 отзыв(-а, -ов) ) Berlin, Germany

ID проекта: #23461692

Поручен:

eduuardo

Hello Waterloo, For automation of 4x15K link check, I can offer a one click magic button with nice dialogue box for custom range selection and batch URL check. All will be done with excel native VBA and Selenium, witho Больше

€20 EUR за 1 день
(20 отзывов(-а))
4.0

41 фрилансеров(-а) готовы выполнить эту работу в среднем за €34

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (g Больше

€50 EUR за 2 дней(-я)
(814 отзывов(-а))
8.8
mantislin

Hi there, I am scraping expert, I have did more than 500+ scraping project, please check my feedback then you will know. Can we discuss more details about this project? then I will provide example data/script for you Больше

€120 EUR за 3 дней(-я)
(373 отзывов(-а))
7.9
sohandas

ok i will make a script to check valid urls and write down, can you please message me so we can discuss more...thanks!

€50 EUR за 2 дней(-я)
(362 отзывов(-а))
7.9
MimiFL

Hi, yes this is very simple to automate. If you are interested in working with me, please message me so i can ask you few simple follow up questions regarding the output. As requested the word "Waterloo". Thanks, Mila Больше

€25 EUR за 1 день
(595 отзывов(-а))
7.2
mtdevil369

Hi,i am excel( vba/marcos) expert . I have understand the project requirement & interested to work for this project. I will start right now and I will do it within your time . Please send a message so we can discuss m Больше

€19 EUR за 1 день
(284 отзывов(-а))
6.8
nvchien94

Hello there, I am an Excel expert and I have 1 macro to check the URL is working or note. I already wrote it yesterday and can modify to match your requirement. Please contact, it can be done within 15 mins. Thank you.

€30 EUR за 1 день
(232 отзывов(-а))
6.6
rahul62544

waterloo......hello sir, hope you are doing great, i had read the description you provided about the project, i have the skills required for this job and i can do your work very effectively in very less time possible.b Больше

€180 EUR за 3 дней(-я)
(183 отзывов(-а))
6.5
branislavm

Hello Waterloo! You are right about VBA - it must be used to check for URL. I can write a code for that in... I think around half an hour. Regards, Branislav

€30 EUR за 1 день
(36 отзывов(-а))
6.3
ineedWorkJob

Greetings sir, Waterloo I have read your project details and i will develop a script that you can also run time to time to check all the rows/products/images whether they are accessible or not. Sir, i can delive Больше

€50 EUR за 1 день
(65 отзывов(-а))
6.0
shahinrahimi

Waterloo ... Hi, I can help you with this URL verification. I have rich experience in VBA-Macro(Web scrapping, Excel, Powerpoint, Word, API, ....), and I do my best to save your time and pocket. Please feel free to con Больше

€50 EUR за 1 день
(66 отзывов(-а))
6.0
arash18k

Hi, I have written the VBA code for you, the sample is ready (Waterloo that you said to write). Please send me message to discuss more and check the file.

€30 EUR за 7 дней(-я)
(15 отзывов(-а))
5.1
VileGnosis

I can make a script that will take in a CSV file and will fill in the columns after checking the urls. My average project completion time is within 3-5 hours on the same day. The skills I have include PHP, HTML5, CSS3, Больше

€30 EUR за 1 день
(20 отзывов(-а))
4.9
merinsinha

Sir I can do it. Expert As 10+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from Больше

€18 EUR за 1 день
(52 отзывов(-а))
4.7
mowachira77

Waterloo Hi. I have fully understood your project requirements and am ready to fulfill them. I have previously completed similar works in data scraping. I will create a script in VBA that will do the work. My useful sk Больше

€30 EUR за 1 день
(35 отзывов(-а))
4.6
dimkazakos

Hi Waterloo ! I have already finished your project. Check demo video here: [login to view URL] Thank you!

€30 EUR за 1 день
(28 отзывов(-а))
4.7
MonisZafar

Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be qucik and accurate. If interested, we can discuss this further on chat.

€30 EUR за 1 день
(24 отзывов(-а))
4.6
evgeny1002

Hi, Waterloo It needs data processing skill which can process excel data and scrapping from web. Your job needs to access excel and also access url to determine successful load or not. I'm sure that I will be suitable Больше

€30 EUR за 1 день
(8 отзывов(-а))
4.0
rajamuzammil

Hello, I'm a professional data processing expert and I'm interested in your project. Can you send me the requirement details ? I'm looking forward to do this project and hope to be collaborating with you in future . Th Больше

€30 EUR за 3 дней(-я)
(11 отзывов(-а))
3.8
HumanoVirtual

Hi, Dear employer please review and test my work. Waterloo, I uploaded file in google drive: [login to view URL] I added URL status check function from VBA Больше

€19 EUR за 1 день
(6 отзывов(-а))
3.7
Prakhark19

Hello there, Myself Prakhar, i am working in python for last 3 years. I have read your description thoroughly and i am confident that i can do this easily. Let's discuss further in personal chat. Regards Prakhar.

€24 EUR за 1 день
(7 отзывов(-а))
3.3