ScanSheet
Export how-to

How to export ScanSheet data to Excel (XLSX)

ScanSheet writes a clean .xlsx file with five columns: barcode, quantity, note, first scan time, and last scan time. The file opens in Excel, Google Sheets, and Apple Numbers without reformatting.

Open ScanSheet Free All guides
Standard XLSX (Office Open XML) format, opens in Excel 2007+ Built into every ScanSheet session, no install or signup required.
Quantity as a real number, not text — pivot tables and VLOOKUP work directly Built into every ScanSheet session, no install or signup required.
Formula injection protection on CSV export (=, +, -, @ prefixes escaped) Built into every ScanSheet session, no install or signup required.
On this page (4 sections)
  1. What the exported file contains
  2. How to export
  3. CSV vs XLSX — which to use
  4. How ScanSheet protects your data

What the exported file contains

  • Barcode — the raw value read from the scan (text)
  • Quantity — integer count, starts at 1 per row
  • Note — editable text, blank by default
  • First Scanned — ISO 8601 timestamp of the first scan
  • Last Scanned — ISO 8601 timestamp of the most recent scan

How to export

  1. On the laptop, click the XLSX button in the top toolbar.
  2. A .xlsx file downloads. The file name includes the date and time.
  3. Open the file in Excel, Google Sheets, or Numbers. All columns are ready for further work.

CSV vs XLSX — which to use

FeatureCSVXLSX
Opens inAny text editorExcel, Sheets, Numbers
File sizeSmallerLarger
Numbers stay as numbersSometimes (depends on import)Always
Timestamps as datesSometimesAlways
Formula injection protectionYes (escaped)Yes (cell type set to text)

How ScanSheet protects your data

If a barcode value or note starts with =, +, -, or @, ScanSheet escapes it with a leading apostrophe in CSV and sets the cell type to text in XLSX. This prevents formula injection attacks where a malicious barcode (e.g. =cmd|' /C calc'!A1) could trigger code execution when opened in Excel.

How to export ScanSheet data to Excel (XLSX)

Common use cases

Frequently asked questions

Quick answers to what teams ask before they switch to ScanSheet.

Will the file open in older Excel versions?

Yes. The XLSX format has been standard since Excel 2007. Excel 2003 and earlier cannot open XLSX — those users should use the CSV export.

Can I export only a date range?

Yes. Click Batch Export in the More menu. You can pick a date range and a format. ScanSheet shows how many records match before you commit.

What happens if my data has special characters?

Both CSV and XLSX are UTF-8 encoded. Chinese, Japanese, Korean, and emoji characters round-trip correctly. The CSV includes a UTF-8 BOM so Excel detects the encoding on import.

Related reading

Continue with these ScanSheet guides.

Ready to scan your first barcode?

No app to install, no credit card to start. Pair your phone with ScanSheet in 60 seconds.

Open ScanSheet Free