Tamamlanmış

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.

Beceriler: Excel, Web Scraping, Veri İşleme, Excel VBA, Excel Macros

Daha fazlasını gör: 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

İşveren Hakkında:
( 11 değerlendirme ) Berlin, Germany

Proje NO: #23461692

Seçilen:

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 Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% EUR
(13 Değerlendirme)
3.3

Bu iş için 43 freelancer ortalamada €33 teklif veriyor

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 Daha Fazla

€50 EUR in 2 gün içinde
(750 Değerlendirme)
8.5
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 in 2 gün içinde
(304 Değerlendirme)
7.5
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 Daha Fazla

€120 EUR in 3 gün içinde
(328 Değerlendirme)
7.7
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(522 Değerlendirme)
7.0
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(29 Değerlendirme)
6.0
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(173 Değerlendirme)
6.1
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(165 Değerlendirme)
6.2
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(50 Değerlendirme)
5.7
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(52 Değerlendirme)
5.1
songhku925

Waterloo i can create four rows next to the product data saying whether or not the image can be loaded using python. I have already finished lots of Web Crawling, Scraping and Automation project using python Scrapy, Bs Daha Fazla

€30 EUR in 3 gün içinde
(8 Değerlendirme)
5.0
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, Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(11 Değerlendirme)
4.6
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 in 7 gün içinde
(12 Değerlendirme)
4.4
dimkazakos

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(23 Değerlendirme)
4.3
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 Daha Fazla

€180 EUR in 3 gün içinde
(8 Değerlendirme)
3.6
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 Daha Fazla

€30 EUR in 3 gün içinde
(10 Değerlendirme)
3.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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(9 Değerlendirme)
3.5
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(15 Değerlendirme)
3.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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(3 Değerlendirme)
3.0
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(10 Değerlendirme)
3.1
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(4 Değerlendirme)
2.8