Cosmovex/tools

Scan barcodes to Excel on an iPhone in Safari, with no app to install

Excel on iPhone with Scanlist

This page opens with the camera first, Excel (XLSX) as the export and repeat scans adding to the quantity. It runs in Safari on the iPhone: allow the camera once, scan, then hand the .xlsx to the Excel or Numbers app from the Share sheet, or save it to Files. Codes are written as text, so an item number with zeros at the start opens in Excel exactly as printed.

  1. Open this page in Safari and tap Start scanning. When Safari asks, tap Allow for the camera. If you tapped Don't Allow earlier, open the page settings menu at the left of the address bar, choose Website Settings and set Camera to Allow, or go to Settings > Apps > Safari > Camera.
  2. The first Start on an iPhone fetches the barcode reader (about 400 KB), so give it a moment on mobile data; after that it is cached and the camera opens straight away.
  3. Point the camera at each barcode. A beep and a new row confirm the read; the same item scanned again adds 1 to its quantity. Use the light button in a dim store room if the camera supports it.
  4. Press Export, keep Excel (XLSX) selected and tap Share XLSX. In the Share sheet pick Excel or Numbers to open the file straight away, or Save to Files to keep it in iCloud Drive or On My iPhone.
  5. If you tap Download instead, Safari puts the file in the Downloads folder of the Files app (Settings > Apps > Safari > Downloads chooses where); tap it there and share it to Excel.
  6. To keep the scanner handy, tap Share then Add to Home Screen. It opens full screen like an app and your list is still there.
scan barcodes to excel on iphone iphone barcode scanner to excelbarcode scanner iphone spreadsheetscan barcode to excel iossafari barcode scanneriphone qr scanner to excel
Open Scanlist Free to start · no account

What to know

Safari asks for the camera per website, and the answer is remembered, so a Don't Allow from last month is the usual reason the camera does not open; Website Settings in the address-bar menu or Settings > Apps > Safari > Camera resets it. The page uses the rear camera and keeps the video on the phone. iPhones have no built-in barcode detector for web pages, so the page loads its own reader on the first Start, which is the short wait the first time only. Chrome and Edge on the iPhone use the same engine as Safari, so the camera permission and the export behave the same way.

Share XLSX uses the iPhone Share sheet with the file attached. Choosing Excel opens the .xlsx in the Excel app with the Code column as text; Numbers converts the file on opening and keeps the codes as text too; Save to Files puts it in iCloud Drive or On My iPhone; and AirDrop in the same sheet sends it to a Mac. Download goes to the Files app instead, in the Downloads folder Safari is set to use, where tapping the file shows a preview and the Share button opens it in Excel. Pick Share for a one-off file and Download when you want the file kept in Files.

The list is saved in Safari's storage for this site after every scan, so switching to another app, a phone call or a reload does not lose it; open the page again and tap Continue. Two things do clear it: clearing website data in Safari settings, and Safari's rule that a site's saved data can be removed after seven days of using Safari without visiting the site. Export at the end of each count, and add the page to the Home Screen if you count every few weeks, because a Home Screen web app keeps its data. Private Browsing keeps nothing between sessions. Free allows three exports a day of 25 rows each; Pro lifts both limits and writes Qty and the scan time as real number and date cells.

Updated · Cosmovex

Questions

Why does Safari not show the camera?

The camera was refused for this site earlier, another app is using it, or you are in Private Browsing with the camera blocked. Open the page settings menu at the left of the address bar, choose Website Settings and set Camera to Allow, or change it in Settings > Apps > Safari > Camera, then reload.

How do I get the file into Excel on my iPhone?

Press Export, keep XLSX selected and tap Share XLSX, then choose the Excel app in the Share sheet. If Excel is not listed, tap Save to Files and open the file from the Files app with the Share button.

Where does Download put the file?

In the Files app, in the Downloads folder Safari uses: iCloud Drive > Downloads by default, or On My iPhone if you changed it in Settings > Apps > Safari > Downloads. Tapping the file there shows a preview; the Share button opens it in Excel or Numbers.

Will my codes keep their zeros in Excel on the iPhone?

Yes. The XLSX writes every code as a text cell, so 0012345678905 stays as typed in Excel for iPhone, Numbers and Google Sheets. A CSV can be converted when opened, so use XLSX for Excel.

Does it work in Chrome on the iPhone?

Yes. Chrome, Edge and Firefox on the iPhone use the same engine as Safari, so the camera prompt, the Share sheet and the saved list behave the same way. Add to Home Screen is a Safari feature.

Will my list still be there tomorrow?

Yes, unless you clear website data, use Private Browsing, or do not visit the page for seven days of Safari use, after which Safari can remove the site's saved data. Export when a count is done, and add the page to the Home Screen for counts that come round every few weeks.

The free plan covers everything on this page. Scanlist Pro ($5/mo, billed monthly) is described on the Scanlist page.