A realistic source document followed by the actual Image to CSV document state or output artifact.
Inventory Sheet to CSV — Prepare Stock Count Records — table image to CSV converter with a cell review grid — After
Inventory Sheet to CSV — Prepare Stock Count Records — table image to CSV converter with a cell review grid — Before
Image to CSV

Inventory Sheet to CSV — Prepare Stock Count Records

Choose a count-sheet image showing SKU, location and quantity columns

Extract an inventory sheet image into CSV stock rows. Check SKU text, bin locations, count units and quantities before adapting the file for an import.

  • Preparing a cycle-count import
  • Combining counts from separate locations

Upload your table image

Choose a count-sheet image showing SKU, location and quantity columns

All image formats (JPG, PNG, WEBP, HEIC, TIFF…)

Convert an inventory sheet image to CSV for a stock import template

This inventory sheet to CSV page reads the count table on a photographed or scanned stock sheet into a grid you can correct, then saves comma-separated rows. It suits a cycle count that has to land in an inventory system, a purchasing sheet or a script. The tool reads the entries written on the sheet. It does not count products in a picture, and it never changes stock by itself.

Match the columns your import template asks for

Import templates want exact headers such as SKU, Location, Quantity and Unit, and often a count date. The first row of the grid becomes the CSV header, so compare it with the template and type over the header cells until the names agree. A sheet printed in another language is the usual reason a heading is misread, so set Language in Settings to the printed language before you convert.

  1. Photograph the flat sheet with the location and date header in frame.
  2. Convert the file and read the grid beside the photo.
  3. Rename the header cells to match the import template.
  4. Fix SKUs, bins and quantities, then choose See result and Download.

Protect SKUs and bin codes from becoming numbers

A CSV file is plain text, so 00417 is safe in the file and at risk in the program that opens it. A spreadsheet that guesses a number type drops leading zeros and can turn a code such as 1E5 into scientific notation. Import SKU, bin and batch columns as text, and compare a few codes with the sheet after the import rather than before it.

Handle handwritten counts and strike-throughs

Counted quantities are often handwritten, with a new number beside a crossed-out one. The reader may return the old figure, the new one or both, so check every unusual quantity against the photo. Amber cells are the reader's own doubts, and a cell showing Unreadable must be replaced by you. A blank count and a zero mean different things in a stock count, so leave a cell empty only where the sheet is empty.

Combine sheets from several locations

Each image produces its own CSV. Before you merge sheets from different bins or aisles, add a Location column to every file, or identical SKUs from two bins become indistinguishable rows. Then stack the rows under one header once the column order matches. For a workbook that keeps each saved sheet with its date and file name, use the Excel version of this page.

Before you load stock numbers into a system

  • Confirm every file has one header row and the same columns in the same order.
  • Keep counted quantity and system quantity in separate columns.
  • Import five rows as a test before you load the whole sheet.
  • To keep the photographed sheets as evidence, put them in one searchable PDF.

Stock imports need verified codes, locations and count units

Move a photographed count sheet into a CSV that you can review and map to an inventory import. Preserve item and location identifiers as text, and resolve count-unit differences before any file is used to update stock.

Preparing a cycle-count import

Recover sheet entries, verify the bin and SKU mapping, and adapt the reviewed columns to the inventory system's import template.

Combining counts from separate locations

Add verified location context to reviewed files before combining them, keeping identical SKUs from different bins distinguishable.

Prepare count-sheet rows for your system's template

  1. Capture the whole count table with its location and unit labels.
  2. Correct codes, handwritten counts and any rows affected by strike-through marks.
  3. Export CSV, match the target template and review the proposed stock changes separately.

Leading-zero SKUs, mixed units and crossed-out stock counts

Does inventory sheet to CSV overwrite stock quantities?
No. It produces a downloadable file. Updating inventory is a separate operation in your own system after validation.
How do I preserve SKUs with leading zeros in CSV?
Review the extracted characters and configure the destination importer to treat SKU fields as text rather than numbers.
Can case counts and individual units share one quantity column?
Only if their meaning remains explicit. Keep a unit column or normalize quantities yourself using verified pack sizes before an inventory import.
Will crossed-out counts be interpreted as the corrected value?
Recognition may read either mark or both. Check each correction against the original sheet and confirm the intended quantity manually.
How do I add a location column to an inventory sheet CSV?
The grid cannot add columns, so open the CSV in a spreadsheet, insert a Location column and fill it with the bin or aisle. Do this before you combine files from several sheets, so identical SKUs in different places stay as separate rows.
What does an empty quantity cell mean after conversion?
An empty cell means nothing was read in that position, which can be an uncounted line or a mark the reader skipped. Rows are also padded to the widest row, so a short row can get empty cells at the end. Check the sheet before you treat an empty cell as zero.
How do I compare the CSV with system stock before importing?
Open both lists in a spreadsheet, match them on SKU plus location with a lookup, and show the difference between counted and system quantity. Check large differences against the sheet first, since one misread digit looks exactly like a stock error.
Which language should I pick for a sheet with product names in two languages?
Choose the language of most of the printed text, because one language applies to the whole image. Changing Language or Engine clears the grid, so convert again after switching. Look closely at product names with accents or special characters, since that is where a wrong setting shows.
Is there a batch option for a stack of count sheets?
Premium accounts can switch to Batch mode and convert many sheets with the same settings, receiving one CSV per image in a ZIP. Batch mode has no review grid, so open each file and check the quantities yourself before you import anything.
Free to use · No signup required · Without watermarkUploads are encrypted in transitRemoved under our retention policy

Watch each transformation land

Every photo crosses the slash untouched and comes out the other side finished.