Share via

I need a qr code scanning

Ahmed Kutty 120 Reputation points
2026-06-02T08:27:02.46+00:00

I run a computer institute. When my staff enter into the Institute each staff have to scan the qr vode. This qr code will be only one for everybody. I want this scanning report in msexcel or in similar one.

Microsoft 365 and Office | Microsoft Forms | For education
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Julie Huynh 1,530 Reputation points Independent Advisor
    2026-06-02T09:58:53.5166667+00:00

    Dear @Ahmed Kutty,

    Good day! Welcome to Microsoft Q&A forum!

    Based on your description, I understand that you run a computer institute where staff are required to scan a single shared QR code when they enter. You would like to capture and maintain a report of these scans in Excel or a similar format for tracking attendance.

    To understand the situation better and provide you with the most suitable support, could you confirm the following information: 

    • Will each staff member have their own unique QR code, or do you prefer a single shared QR code for everyone?
    • Should staff identify themselves manually (e.g., typing name), or should the system identify them automatically?
    • What information should be captured when they scan?
      • Just name and time?
      • Or additional details (e.g., staff ID, department)?

    Your confirmation would be very helpful in ensuring you receive the most suitable support!

    Would you be okay with a simple way where:

    • Staff scan a QR code that opens a Microsoft Form
    • They enter their details manually (e.g., name or ID)
    • Each submission is automatically recorded with a timestamp
    • You can click “Open in Excel” to view and download the report

    This option is ideal if you want a fast deployment, there is no need a dedicated scanning app and you mainly want data collection & Excel reporting.

    Or would you be okay with a more robust way where:

    • Each staff has a unique QR code (with staff ID embedded)
    • Staff use a Power Apps mobile app to scan QR codes (camera-based)
    • Each scan automatically logs:
      • Staff ID
      • Name
      • Scan time
      • Location/branch
      • Notes/status
    • Data is stored in Microsoft Lists (or SharePoint)
    • You can export or sync to Excel for reporting

    This option is suitable if you want true QR scanning, accurate logging and automation, structured reporting and to validate staff identity automatically.

    Kindly let me know when there are updates or if you need further assistance. Any updates you’re able to share would be really helpful. I appreciate your time and look forward to hearing how things are going! 

    Thank you for your time and patience.

    If you have extra questions about this answer, please click "Comment". 

    Note: Please follow the steps in [our documentation] to enable e-mail notifications if you want to receive the related email notification for this thread. 

    Was this answer helpful?

    1 person found this answer helpful.

  2. AI answer

    2026-06-02T08:27:25.9533333+00:00

    Microsoft Forms plus Excel can be used to capture each scan as an entry in a spreadsheet, but the context only provides detailed QR guidance for specific Microsoft products (Entra QR authentication, Power BI, Universal Print, Authenticator) and not for a generic “one QR for everyone” attendance system.

    From the available information, the only QR-related flows described are:

    • Entra ID QR code authentication for frontline workers, where each user has a unique QR code and PIN for sign-in on shared devices.
    • Power BI mobile app QR codes, where scanning a QR code opens a specific report or tile.
    • Universal Print secure release with QR code, where users scan a printer’s QR code from the Microsoft 365 app to release print jobs.
    • Microsoft Authenticator account setup by scanning a QR code from the Security info page.

    None of these flows match the requirement of a single shared QR code that logs each scan into Excel as an attendance list.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

    1 person found this answer helpful.
  3. Senthil kumar 800 Reputation points
    2026-06-02T08:56:39.7133333+00:00

    Hi @Ahmed Kutty

    • First need to generate QR code from Excel below the API its to generate QR Codes from online, Its free only. attached the screenshot for your attention.

    =IMAGE("https://api.qrserver.com/v1/create-qr-code/?size=200x200&ecc=H&data=" & A2)

    User's image

    once you generated QR code printed in cards or something. in the same excel scan the QR code then match with your Staff ID.

    Thanks.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.