Create a Script/Utility/Web Code etc. to scrape some data from a website

Requirements:

1. We shall upload some csv sheets in your utility/script that have a column called "Product_Description_1" . It contains description in HTML format. Some sample sheets have been attached (refer column K in the sheets)

2. Now these HTML descriptions should be pasted on website one by one: [login to view URL]

3. There is a button the website " Cleanup my HTML" that converts the HTML pasted in the Clean version HTML(accepted on marketplace website like Amazon)

4. So we need that cleaned version of HTML . Now script should copy that clean HTML and paste that in a new column(say after 'K' , namely "CLEANED HTML"---can also put in the end/beginning as well). Rest all other columns/data remain the same

5. Another column NAMELY "LENGTH" to be inserted after "CLEANED HTML" column. This captures length(no. of characters including spaces) of CLEANED HTML and highlights those which are larger than 2000

6. We should finally get a csv/excel file which has all the same data as original file plus additional "CLEANED HTML" and "LENGTH" column. CSV is preferable

7. A Sample RESULT file has been attached. Refer "Column L" (Cleaned HTML) and "Column M' (Length) for the result

8. The script should be easy to use and preferably without needing installation of any other frameworks. Best would be web based(can provide domain and space for upload if needed)

HTML JavaScript PHP Softwarová architektura Sběr dat z webových stránek

Identifikační číslo projektu: #18156925

O projektu