J
J
jfresearch2022-02-09 22:35:35
Parsing
jfresearch, 2022-02-09 22:35:35

How to parse a site by Excel value and return the found text to a table?

Hello, I wanted to know if it is possible to somehow implement it or if there are already ready-made programs / sites / codes, for the task:
There is a column with numbers in the Excel spreadsheet
And there is a site in which, when this number is inserted into the search bar, a page pops up, on which there is a line a la "Phone: ..."

And now, you need this phone to go to another corresponding column of the file ..

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
datka, 2022-02-10
@datka

Here I clicked on ready-made solutions by type and everything worked.
If you know the Python programming language, then you can try to do this: Install the libraries openpyxl , requests
Through openpyxl, you can pull data from your excel file.
Through requests, you can pass the retrieved data to your site. and get back the data you need. After that, you can again write the extracted data from the site to excel through openpyxl. Depends on the site. If the site has access to the API, then you can do all this through json. If not, then the beautifulsoup library will help.
If you have no programming knowledge, then you are here. https://freelance.habr.com/ I think it will cost about 2 bottles of beer)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question