Need excel macro to fill the web forms

December 27, 2018 at 05:03:38
Specs: Windows 10
Hi All,

I am need of excel macro which can help me to copy the data from an excel file and paste it on website.

In my excel sheet there are approx 15 columns and 2000 rows with data such as name, address, phone number, city, etc. I have the same fields on my web page. I have to copy the data from an excel and paste it in web form and then I need to click submit on web page so that new form comes in. Then again I have to do the same process.

Can anyone help me to have macro for this or any other best solution to do this activity. Please advise.


See More: Need excel macro to fill the web forms

Reply ↓  Report •

#1
December 27, 2018 at 05:59:44
Save the excel file as .csv, open the file, remove the delimeters( , and " ) with ctrl+H and ctrl+C, ctrl+V into the form?

or am i thinking too simple?

i5-6600K[delid]@4.7GHz/@1.392v LLC=6 | 2x4GB Crucial-DDR4-2133CL15@14-14-14-30 1T 2666MHz@1.35v | MSI Armor RX 570 4GB@1415Mhz core@1.2v/1920MHz


Reply ↓  Report •

#2
December 27, 2018 at 07:35:44
Thanks for your reply.
But, I am doing the same process now. In this method I have to copy each data and paste into each field on web form. I want to set Macro who can copy and paste the data on web page on my behalf at one or two clicks.

Reply ↓  Report •

#3
December 27, 2018 at 09:29:14
Okay, here's the problem with what you're asking for. There are three ways to do what you want:
1) Scrape the webpage's DOM, find the input fields, and insert the desired input.
2) Use website's developer API to upload that data directly, assuming website has a public developer API.
3) Reverse engineer the website enough that you can pretend to be a web browser, and upload the desired input directly as Chrome / Firefox / Internet Explorer would.

All three methods have their individual strengths and weaknesses, but a weakness they all share is that they must be done on a page-by-page basis, and not generically for every page. (I.e. this page vs. a page.)

How To Ask Questions The Smart Way


Reply ↓  Report •
Related Solutions


Ask Question