Automated Data Entry Online using Data from Excel | Auto Fill Forms using Chrome Extension
Ғылым және технология
In this video, you will see how to auto-fill forms online using the data source in a Microsoft Excel file. I have used an extension for the Google Chrome browser; the extension works on the Microsoft Edge browser. The extension is free to use.
Here is the link to download the extension: chromewebstore.google.com/det...
The process is very simple; it detects the form fields automatically. It works with complex form fields like radio buttons, drop-down selectors, etc.
You can add custom form fields in the extension settings. You can fill out any type of form online. It handles the form where the form has multiple pages where you need to click on a button to go to the next section of the form.
Timestamps:
0:00 Intro
0:28 Form with multiple data entry input types
0:58 Install Excellent Data Filler extension
1:28 Set up the form fields in the extension
1:46 Customize the form fields
2:44 Download the template
3:41 Upload the Excel data
4:25 Set up the submit action and the loop
8:03 Handle form entry errors
How to scrape web data: • Scrape Any Website in ...
Subscribe to the channel:
/ @technologiate
Follow and engage on social media:
Facebook: / technologiate
Instagram: / technologiate
#autofill #dataentry #autofillextension #chromedataentry #automateddataentry #formfilling #dataentry #form #chrome #edge
Пікірлер: 17
Sir suckess function is not working please help it didnt detecting any suckess message or any element please help what to do it stoped on suckess page and when i reload it repeat first feeld data
Great video, nice explained! I have this more complicated site (namely, SAP fiori)need to fill. It needs to select a drop down table first, so the site items aren’t populated. I manually added the dropdown table by adding xpath, but somehow won’t enter after reload. Is there any restriction for this extension? Anyway, I’d like to learn more, expect some more videos!
@technologiate
18 күн бұрын
Thank you. When the XPath doesn't work, you can try the #ID. 1. Add a new field 2. Change the type to 'Select' under the 'Edit field' option. 3. Change the Selector type to '#ID' 4. On the form, right-click on the field, select the Inspect option, and find the ID of the field. The ID should be inside the 'id' tag. 5. Put the ID of the field in the 'Selector Query.' 6. Update the settings. Before writing this comment, I tried this, and it worked for me. Here is a screenshot: i.imgur.com/J1Br45n.png Please let me know if this works for you.
I have installed the extension on both edge and chrome but when I tried to insert site it's showing to tell me to install the extension again
Sir, I have data in excel, I want to use it in the given sanction form, so sir, how can I use it?
Can I use this at the VFS website?
@technologiate
5 күн бұрын
Hi, It should work for all websites if they have no restrictions.
*Scrape website data:* kzread.info/dash/bejne/aXth17SRmrCTpNY.html
Hello sir in this video one page form but i need to multiple sections form please sir solve my problem sir please upload a new video how to fill form automatic multi sanction please reply sir i am waiting for your reply
@technologiate
12 күн бұрын
Hi, In that case, you need to manually add the form fields, as I explained at the end of the video. First, add the site, and it will read the fields. Then, add the button on the fields page, which will redirect the form to the new page. Add the new fields manually(check my reply to another comment). Add the button, and so on. You just need to add some manual actions. Hope it helps.
@ananyayadav3900
12 күн бұрын
@@technologiate thankyou sir
@ananyayadav3900
12 күн бұрын
Sir please one example My form is Name Mobile no Email Then submit Then Address
@technologiate
12 күн бұрын
@@ananyayadav3900 Can you email me the form URL (if it is publicly available)? And an Excel file with some dummy data. I will check it out.
@ananyayadav3900
12 күн бұрын
@@technologiate sir what is your email id