How to Automatic Data Entry From an Excel Worksheet to a Web Form

How to do automatic data entry from a Microsoft Excel file to a web form?

It is so boring to copy cell by cell and paste into a web form. Is it possible to fill the web form as easy way?

Two images of my case are attached:


1 Like

Hey @Ajmal_Saidy,

Welcome to the forum!  :smile:

If you haven't read this it's worth a couple of minutes of your time.

Tip: How Do I Get The Best Answer in the Shortest Time?

Posting images is good, but we also need to know what software you're using and on which version of macOS.

When dealing with web pages it's best if we can have access to the original page for testing, because these things can get quite complicated.

But – let's go for something quick and dirty for the moment.

Paste Selection in Excel to a Web Form v1.00.kmmacros (6.0 KB)

You'll have to play around with the keystrokes necessary to advance the position in your web form.

With more knowledge it might be possible to insert these values with JavaScript instead of pasting, and that would speed up the macro considerably.

Have fun.


1 Like