Skip to content
Henrium
English

Integration & setup

RFID Reader to Excel: How to Read Card Numbers into a Spreadsheet (No Coding)

By Henrium · · 10 min read

Quick answer

Match a keyboard-output reader to the exact card chip and host. Format the card-number column as Text before reading, keep the input cell focused and confirm Enter or Tab behavior. Compare the complete output with the number your system stores. The downloadable English workbook provides a blank text-formatted card log; timestamps are entered manually.

Discuss your reader requirements

You can collect RFID card numbers in Excel without a reader-specific add-in or code when a compatible reader provides keyboard output. It types into the focused cell. Enter can move to the next row when the reader sends that suffix and Excel’s movement setting is Down.

Prepare the sheet before using real cards: preserve complete IDs as text, confirm focus and row movement, then decide whether you need manual logging or software automation. The steps below use Excel; host support, menus, formulas and mobile behavior must be checked for the selected reader and application.

Download the card log starter

Download the English card log workbook (.xlsx). It provides 500 blank rows with the card-number cells formatted as Text, a manual time column and optional person or asset and notes fields. It contains no macros or automatic timestamps. The examples in its instructions are illustrative values, not reader compatibility results.

Use a copy for your first known-card test. Compare the same card in a text editor and Excel before linking IDs to people or existing records. To discuss a reader, use the inquiry form on this page with your chip, application, exact expected output and quantity.

What you need

Scroll horizontally to see every column.

Item What to check
RFID reader with keyboard output Exact chip and protocol support, not frequency alone: EM4100-compatible LF cards or a listed HF chip. Confirm ID/UID reading, full output and host compatibility. See keyboard-emulation readers.
A few known cards Ideally with the number printed, so you can compare
Computer, phone or tablet A free USB port, a USB-C port with OTG, or Bluetooth. Each product page lists the operating systems that model is specified for.
Spreadsheet Excel, Google Sheets or LibreOffice Calc
Optional A separately tested logging application if automatic timestamps or unattended collection are required

Step 1: Match the reader to your cards

Start with the exact chip, protocol and task. A single-band LF reader cannot read HF cards; sharing a frequency still does not establish chip support. Card markings and a phone’s NFC reaction are clues, not proof of compatibility. Confirm unknown cards using supplier information or an actual-card test. The frequency selection guide separates the bands and HF protocols.

The L110-U lists EM4100-compatible 125kHz ID reading. The H110-U lists UID reading for MIFARE Classic and NTAG203. Both provide USB keyboard output with 10-digit decimal output listed by default; H110-U does not read sectors or NDEF records or write NFC tags. A full 7-byte UID cannot fit that 10-digit format. Confirm the full value or an agreed extract and any unlisted chip using your cards. Read the MIFARE and NTAG compatibility guide before ordering.

Step 2: Test the reader in a text editor

  1. Plug the reader into a USB port. No driver is needed; the computer sees an extra keyboard.
  2. Open Notepad or TextEdit and click in the window.
  3. Present a supported card and compare every character with the required value. Beep and LED behavior depend on the model and configuration.
  4. Note two things: the exact digits, and whether the cursor jumps to a new line. A new line means the reader sends Enter.

If the characters look wrong (for example àààè instead of digits), the computer’s keyboard layout is the cause. Set the input language to English (US); the keyboard-wedge guide explains why.

Step 3: Prepare the worksheet

  1. Type headers in row 1: Card number, Time, Name, Repeat.
  2. Select column A and set it to Text: Home > Number Format > Text (or Ctrl+1 > Number > Text). Do this before the first read. Excel does not convert existing entries when you change the format afterwards.
  3. Select the header and input range, choose Insert > Table and confirm that it has headers. An Excel Table can fill the optional lookup and repeat formulas down as rows are added; verify the result in your version.
  4. Check where Enter moves the cursor: File > Options > Advanced > “After pressing Enter, move selection” should be set to Down. On a Mac, the setting is under Excel > Settings (Preferences in older versions) > Edit.

Why Text matters: Excel converts anything that looks like a number, and card numbers are identifiers, not quantities.

Scroll horizontally to see every column.

Reader types In a General column Excel shows In a Text column
0007024461 (10-digit decimal) 7024461 0007024461
12345E67 (8-digit hex) 1.2345E+71 12345E67
0128856043341 (13-digit decimal) 1.28856E+11 0128856043341
1229366394379648 (7-byte UID in decimal) 1.22937E+15, stored as 1229366394379640 1229366394379648

The last row shows Excel’s 15-significant-digit numeric limit. Once a long ID has been rounded, adding zeros or changing the display format cannot restore it. Read it again into a text-formatted cell. Microsoft explains keeping leading zeros and large numbers.

Step 4: Read cards into the sheet

Click cell A2 and present the first card. The number appears and, if the reader sends Enter, the cursor moves to A3. Present the next card.

Keep the Excel window in front. A keyboard reader types wherever the cursor is, so a chat window or browser that takes focus will receive the next number instead. If your reader does not send Enter, press Enter after each read yourself; otherwise the next number is appended to the same cell. The keypad readers (L310-U, H310-U) and the H510-B Bluetooth reader send Enter after the number by default; for other models, ask for an Enter suffix, confirmed in your quotation.

Step 5: Record the time of a read

Use a static time value for a manual log. =NOW() is a recalculating value, not the original read time. The starter workbook leaves the time column blank for manual entry.

Scroll horizontally to see every column.

Host Static date and time entry Check
Excel on Windows Ctrl+; for date, a space, then Ctrl+Shift+; for time Confirm the workbook and keyboard layout
Excel on Mac Ctrl+; for date, a space, then Command+; for time Reader support on the actual Mac must also be confirmed
Web or mobile spreadsheet Enter a date and time as values Check the app’s date interpretation and display

Format column B as yyyy-mm-dd hh:mm:ss when entering date-time values; this changes their display and does not add seconds missing from your entry. See Microsoft’s static date and time instructions.

For automatic or unattended records, use a logging application or separately tested desktop automation. Check accepted reads, focus loss, duplicate reads, edits and the system clock. A keyboard reader still sends input to the focused field; a spreadsheet alone does not create a verified attendance or access log.

Step 6: Match names and flag repeat reads

Create a second sheet named Cards with the card number in column A (formatted as Text) and the person or asset in column B. Then add to the log sheet:

  • Name (C2): =XLOOKUP(A2,Cards!A:A,Cards!B:B,"Unknown card") in Microsoft 365 or Excel 2021 and later. In older versions: =IFERROR(VLOOKUP(A2,Cards!A:B,2,FALSE),"Unknown card").
  • Repeat (D2): =IF(SUMPRODUCT(--($A$2:A2=A2))>1,"Repeat","") marks the second and later reads of the same card.

Both sheets must store card numbers the same way. The text 0007024461 does not match the number 7024461, a common reason for a lookup to return “Unknown card”. COUNTIF also works for 10-digit numbers. It converts number-like text and compares only 15 digits, however, so long IDs can show false repeats; the SUMPRODUCT version avoids that.

For a daily attendance view, insert a PivotTable with Name in rows and a count of Card number in values, filtered by date.

Convert the number inside Excel

If your printed cards, access-control software or database use a different format from the reader, convert in the sheet instead of re-reading every card. With the reader’s 10-digit decimal in A2:

Scroll horizontally to see every column.

Goal Formula Example result
10-digit decimal to 8-character hex =DEC2HEX(A2,8) 0007024461 → 006B2F4D
8-character hex to 10-digit decimal =TEXT(HEX2DEC(A2),"0000000000") 006B2F4D → 0007024461
Reverse the byte order of an 8-character hex =MID(A2,7,2)&MID(A2,5,2)&MID(A2,3,2)&LEFT(A2,2) 006B2F4D → 4D2F6B00
Wiegand 26 facility code =MOD(INT(A2/65536),256) 0007024461 → 107
Wiegand 26 card number =MOD(A2,65536) 0007024461 → 12109
Pad a known 10-digit ID whose digits are intact =TEXT(A2,"0000000000") 7024461 → 0007024461

These formulas use English Excel names and comma separators. Adapt the syntax for your application’s language and version. The padding example assumes a known 10-digit format and intact digits; it cannot recover rounded values or missing UID bytes. Conversion changes the representation, not the card or reader capability.

The Wiegand 26 examples extract the low 24 bits of a complete 32-bit value using an 8-bit facility code and 16-bit card number layout. Confirm the controller’s actual format; these formulas are not a universal conversion for every Wiegand system or a longer UID.

HEX2DEC accepts up to 10 hex characters, but returns a negative number for values of 8000000000 and above; 8-character hex values are always safe. For what these formats mean, see RFID card number formats, or check a single card in the Wiegand 26/34 calculator.

Keep IDs intact when sharing or importing

Keep the working log as .xlsx so its cell formats remain available. CSV stores text values, not Excel cell-format settings. When importing CSV into Excel, use Data > From Text/CSV and set the card-number column’s data type to Text before loading. Check leading zeros, hex strings containing E and long IDs after import. Do not rely on opening the CSV by double-clicking.

Compare an exported and re-imported value with the original text using the same known card. If the value has already been rounded or truncated, return to the original source or read the card again; display formatting cannot reconstruct it.

Troubleshooting

Scroll horizontally to see every column.

Symptom Likely cause Fix
Leading zeros missing Column was General when the number was read Set Text before re-reading; pad only a known 10-digit format whose digits are intact
Values like 1.2345E+71 Hex number read as scientific notation Set the column to Text and read again
Two numbers in one cell Reader does not send Enter Press Enter after each read, or order an Enter suffix
Cursor moves right instead of down Reader sends Tab, or Enter direction is set to Right Check the suffix first: change a Tab suffix or navigate manually; change Excel’s direction only for Enter
Symbols instead of digits Non-US keyboard layout Switch the input language to English (US)
Same card not logged twice Card left on the reader Lift it away and present it again
Number differs from the card print Different number format Compare both numbers in the card number converter
Nothing happens Chip/protocol mismatch, connection or missing focus Work through the troubleshooting checklist

Google Sheets, phones and tablets

  • Google Sheets: set the ID column to Plain text before reading and confirm focus and row movement in your browser or app. Check imported formats and application-specific formula syntax.
  • LibreOffice Calc: set the ID cells to Text before reading or importing. Check the separator, function names and lookup support in your version rather than assuming English Excel formulas paste unchanged.
  • Android: H220-C and L220-C list USB-C keyboard output for their supported HF and LF cards respectively. Confirm USB OTG, power, focused cell, complete output and row movement on your phone and spreadsheet app. See the OTG checklist.
  • iPad and iPhone: H510-B Bluetooth card reader lists iOS keyboard operation, with 8-character hex and Enter by default; its USB cable is for charging only. Test the pairing, focused cell and complete output in the actual app. Confirm reader support before applying these steps to a Mac or another unlisted host.

Checklist: choosing a reader for spreadsheet logging

  1. Frequency and chip match your cards (see Step 1).
  2. Keyboard output, not RS232 only. RS232 readers need software to read the port.
  3. The output format matches the numbers you already hold: card print, access-control database or payroll system.
  4. Enter after each number, so reads land one per row.
  5. The right connection: USB-A, USB-C with OTG, or Bluetooth.
  6. The logging PC uses an English (US) input layout.
  7. A form factor that suits the desk: a slim pad, a USB stick, or a keypad reader where staff also key in a code.
  8. A sample tested with your own cards before a volume order: request samples.

Use the reader quotation checklist to confirm the model, supported output, Enter or Tab suffix, host, sample quantity and commercial terms in writing. If the chip or existing number format is unclear, describe it in the inquiry form rather than choosing from frequency alone.

When a spreadsheet stops being enough

A spreadsheet can suit a staffed collection desk. Multiple stations, automatic timestamps, auditing or door control need a workflow designed for the actual application. Confirm its input interface, accepted card value and reader support before reusing a device. See time and attendance and POS and membership for selection considerations.

One last point: once card numbers are linked to names, the workbook holds personal data. Store and share it the way your privacy rules require.

Frequently asked questions

Why does Excel remove the leading zeros from my card numbers?

Format the card-number column as Text before reading. =TEXT(A2,"0000000000") adds padding only when the required width is known to be 10 digits and the stored digits remain correct. It cannot recover a rounded long ID or bytes the reader omitted. Read the card again into a text-formatted cell and compare the full output.

How do I add a timestamp automatically when a card is read?

The starter workbook uses manually entered, static timestamps. =NOW() updates when the workbook recalculates and is not a record of the original read. Automatic timestamps require a separately tested logging application or desktop automation, with accepted reads, focus and editing behavior checked on the actual host.

Can I read RFID cards into Google Sheets or LibreOffice Calc?

A keyboard-output reader can type into a focused, editable cell when the host and application accept its keyboard input. Set the ID column to Plain text in Google Sheets or Text in LibreOffice Calc before reading. Check the imported workbook, formula names and separators in your version; Excel menus and formulas do not transfer unchanged to every application.

Why do all my card numbers end up in one cell?

Check the reader terminator, Excel editing state and movement after Enter. Without a terminator, the next read may be appended to the same cell. Press Enter manually or confirm an Enter suffix for the selected model. A Tab suffix moves to another column and must be changed separately from Excel's Enter direction.

Does this work on an Android phone or iPad?

Confirm the reader, card and actual app together. H220-C lists Android USB-C operation with USB OTG and supported HF card UID reading. H510-B lists Bluetooth keyboard operation for iOS and Android; its USB cable is for charging, not USB keyboard data. Test focus, full output and Enter behavior on your device before ordering.

Readers mentioned in this guide

Choose a reader for your spreadsheet workflow

Card and existing value
Name the exact chip and provide an anonymized same-card example of the reader output and stored ID, including leading zeros and UID length.
Host and spreadsheet
Name the device, operating system, spreadsheet app and keyboard layout. State whether the input cell can remain focused.
Output and logging
Specify Enter or Tab, required full value or agreed extract, manual or automatic logging needs, and sample and order quantities.

Request a quote

Describe your requirements and quantities. Mark any undecided details as unknown.

Include your card or tag type, host/software, expected output and approximate quantity. If something is unknown, describe the task.

Need to share a card photo or output screenshot? Use the email or WhatsApp link below; this form accepts text only.

No spam, no newsletter. Your details are used only to answer this request.

Prefer email? sales@henrium.com · WhatsApp

Tell us your card, interface and quantity

Send the card or tag type, the host system and your volume. We reply within 1 business day with a suggested model and sample options.

Get a quote Email us