RFID-RC522 with Excel using Arduino (As a attendance system)

Hi, everyone.
In this video, I'm going to show you how to interfacing
RFID-RC522 with Arduino UNO and saving the information about cards in Excel file.
Login system or Attendance system.
For example to ensure all employees in the company come
in time every day and saved the Excel file where the names and each unique number stored when all employees had come.
The Excel file saves Login and Logout time.
Note: The card will detect only once and show you a message if the card already detected and saved.
-----------------------------------------------------------------------------------------------------------
Some guys told me that they have a problem while scanning the Cards
that problem was the Arduino detect many cards as the same with the same name even these cards had different IDs.
So I fixed the problem and Here's the new code,
Using this code you don't have to upload another code to scan the card's ID just upload this code then open the Serial monitor and scan your tags then replace yours with the other in the code.
I hope everything goes as you want.
Please read the comment in the code to better understanding.
Everything you need is here:

-----------------------------------------------------------------------------------------------------------
If you want to use LCD 16x2 with this project and make it more interesting. You can use this code
Arduino code with LCD:
The diagram with the LCD driver and without it:

with only 1 wire using SPI Protocol and Shift Register.
The reason why I used this method because RFID uses SPI protocol and
we could use his pins for another device using the same protocol and
save more pins to use them.
Check it out.
-----------------------------------------------------------------------------------------------------------
If you want to buy the components:
-----------------------------------------------------------------------------------------------------------
In the new video, I've made a professional login system using nodeMCU and RC522 with a web interface and save everything in Database using MySQL.
You can know more information about it in this video, Check it out if you're interesting:
-----------------------------------------------------------------------------------------------------------
Music: Fredji - Happy Life (Vlog No Copyright Music)
-----------------------------------------------------------------------------------------------------------
If you like this video don't forget to Like and Share.
Don't be a stranger, hit the Subscribe button, It will be awesome having you here.
Comment if you have any questions.
Thanks for watching.

[ElectronicsTechHaIs]

Hi everyone.
Recently, There was a problem in the Arduino code while detecting the cards and read many cards as the same.
So I tried to fix that problem and everything went well. If you're interested, now the code is available to download from this link:
Stay close.

[ozan]

I have a question about the system. Students' names will initially write in the excel file. Then when a student reads his / her card, an 'X' will be placed next to the student's name. How can I do that. Please help me.

[internetexplorer]

Hey brother please make a attendance recorder with RFID+Fingerprint Scanner and GSM module

[Producthuntvideos]

sir i have one problem please help me ot sir
i want to scan the card more than 2 time sir what can i do sir?

[panavpatel]

Serial monitor is not showing any outputs? The light on arduino uno and rfid module is working, what should I do

[jeanieelorde]

How about from laundry machine to micrsoft excel sir?

[mrvnmedina]

Hi Electronics Tech! We know that our world is in a world pandemic as of now. Is it possible to have this RFID Attendance System but it also includes the person's temperature? Thank you for your kind response.

[srishivaharikannan]

Sir awesome project. We are planning to implement this project in our school. For student safety purpose. So kindly share your e-mail id

[sarojgauli]

hi sir, we have a project of RFID based attendance system. can you pleasw help me with that.

[pavitraelasha]

hai sir, instead of using excel, how to connect to database and view in website?

[qurt_san]

when i try to upload it go denied.. help, also does this work with 400 holes breadboard?

[sabahlarhlid]

Arduino : 1.5.6-r2 (Windows 7), Carte : "Arduino Uno"

'MFRC522'

rfid_read_personal_data:110: error: 'STATUS_OK' is not a member of 'MFRC522'
rfid_read_personal_data:112: error: 'class MFRC522' has no member named 'GetStatusCodeName'
quoi faire dans ce cas please.'

[urvashipawar]

I have made this project. It is working properly. Every card is getting detected.on first time detection it is showing data in excel sheet and on second time detection it is not adding data in excel sheet. But i want to modify project like on second time detection, data should not display on excel if we are scanning card for second time within 1 minute after scanning for first time. After 1 minute if i scan same card then it should display data. Is it possible!? Please help me ASAP sir.

[christianjaylafiguera]

Hi 😂
I followed all the instruction but when it's time to read the NFC tags it doesn't appear it just only "Name, Number, Date, Time"

[Oirelis]

can i ask how can you modify the nfc to a specific name?

[camilo]

Thanks man, you really save me with this video, thank you so much.

[runebgh]

hey. I can not get my No. 2 card up in excel. what could the problem be?

[saranoor]

thank you for the vedio, please if it's possible to explain to me
meaning of :
mfrc522.PCD_Init()
!
! mfrc522.PICC_ReadCardSerial()

[suetrexd]

Hello, i'm having trouble with the serial monitor, after uploading the code, the serial monitor only displayed string name 1, 2, 4, 5 while 3 and 6 are not.

[habeebsahily]

Arduino: 1.8.13 (Windows Store 1.8.42.0) (Windows 10), Board: "Arduino Uno"

Sketch uses 6562 bytes (20%) of program storage space. Maximum is 32256 bytes.

Global variables use 281 bytes (13%) of dynamic memory, leaving 1767 bytes for local variables. Maximum is 2048 bytes.

An error occurred while uploading the sketch



This report would have more information with
"Show verbose output during compilation"
option enabled in File -> Preferences.

i have checked the upload box in show verbose output during compilation and still error