Excel macro to fill web form using excel data

[jdelano]

I think that this can best be solved by using the automation tool Selenium, check out this article Selenium VBA Excel Tutorial: Chrome Web Scraping Example (guru99.com)
edit: forgot thse urls as well How to Set Text Value in TextBox In Selenium WebDriver - MySkillPoint Seleniumbasic (florentbr.github.io)