Automated Data Entry Online using Data from Excel | Auto Fill Forms using Chrome Extension
Вставка
- Опубліковано 31 лип 2024
- 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 - Наука та технологія
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
Thank you sir for you explanation to do this work I am really thankful to you to do my project in time
🎉
Sir, I have data in excel, I want to use it in the given sanction form, so sir, how can I use it?
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
Did you get the solution, I am also stuck with the same
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!
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.
Will it work for a website and if it works does it show to the owner that data has been entered automatically
The owner can not detect.
Can I use this at the VFS website?
Hi,
It should work for all websites if they have no restrictions.
does it works in private network ?
It should work.
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
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.
@@technologiate thankyou sir
Sir please one example
My form is
Name
Mobile no
Email
Then submit
Then
Address
@@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.
@@technologiate sir what is your email id
This is not working on Flipkart website 😢
Hi, what are you trying to achieve on the Flipkart website?
@@technologiate I am doing product listing
*Scrape website data:* ua-cam.com/video/7G-uRXjM-ts/v-deo.html
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
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
yes me too. i can not use please someone help, i cant find a solution
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
Yes, I have faced the issue a couple of times. Can you disable any ad blocker extension you have and try again. It worked for me.
@@technologiate what is ad blocker how i disable it