'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Incomplete Barcode Scanning in Excel for iPad
Question details
An external barcode scanner inputs incomplete barcodes or splits the data across multiple rows when used with Excel on an iPad.
- Product
- Microsoft Excel
- Device & OS
- iPadOS
- Scenario
- Importing inventory or tracking data into a spreadsheet using a Bluetooth or Wi-Fi barcode scanner.
- Observed behavior
- The scanned barcode is cut off or split into two separate rows on the iPad, despite functioning perfectly on an Android device.
Locate the physical or digital user manual for your specific barcode scanner model, as you will need it to scan configuration codes.
Reduce Scanner Keyboard Transmission Rate
Lower the scanner's data transmission speed so Excel on the iPad can process the keystrokes without splitting the data.
The iPad version of Excel may process external keyboard inputs slightly slower than its Android counterpart. If a scanner transmits characters too rapidly, Excel cannot keep up, resulting in split rows or missing characters.
Retrieve the user manual for your external barcode scanner. If you don't have the physical copy, search for the PDF version on the manufacturer's website.
Look for a section in the manual titled 'Keyboard Transmission Rate', 'Intercharacter Delay', or 'Data Transmission Speed'.
Use your scanner to scan the specific configuration barcode that reduces the transmission speed or adds a slight delay (e.g., 20ms or 50ms) between characters.
Open your spreadsheet on the iPad, select an empty cell, and scan a test barcode to verify the data now appears completely in a single cell.
Try WPS Office for Smooth Data Entry on iPad
If Microsoft Excel continues to struggle with processing rapid external inputs on your iPad, consider switching to WPS Office. It offers a lightweight, highly responsive environment that excels at data entry tasks without compromising on format compatibility.
- 1. Download the App: Visit the Apple App Store on your iPad and search for WPS Office.
- 2. Install and Launch: Install the application for free and open it on your device.
- 3. Import Spreadsheets: Open your existing Excel files within WPS Office and continue scanning your barcodes smoothly.
Frequently Asked Questions
Why does my barcode scan across two cells?
This happens when the scanner reads the barcode and sends an 'Enter' or 'Return' command before the spreadsheet app has finished processing the characters. Slowing down the transmission rate fixes this sync issue.
Can I remove the automatic 'Enter' after scanning?
Yes. Most external barcode scanners have a configuration barcode in their user manual specifically for disabling the 'Carriage Return' or 'Enter' suffix.
Why does the scanner work on Android but not iPad?
Android and iPadOS handle Bluetooth keyboard inputs differently. An Android device may have a faster polling rate or buffer for rapid keystrokes, whereas the iPad requires a slightly slower input speed to process characters without dropping them.
