Export a reviewed PDF inventory table as CSV
Admin ·
A scanned room inventory needs a character-by-character review before import. Work with one table at a time so a spreadsheet or database can read a consistent number of fields on each row.
Read the scanned inventory on page 2
Download the sample inventory PDF and open it in the tool. Enter 2 in Pages and read it with Existing text. The source preview shows a table, while the review reports no detected table. The page is an image.
Select English OCR on every selected page and read again. Review the four columns Item, Code, Count and Room against the original. The Bolt row should read Bolt, 00124, 14 and West. Enter 00124 in B2 to correct any missing zero.
Download the three-page inventory example PDFTesseract, improving recognition quality
Check the records in the downloaded CSV
Create and download the CSV for this table. Inspect the first data record in a CSV reader and check for four fields, including 00124 in the second field and 14 in the third. The CSV contains the characters you reviewed.
When importing into Excel, choose UTF-8 and set the code column to Text before loading. Import settings determine how a spreadsheet interprets digit strings. For several tables in one file, use the Excel converter and keep each table on its own worksheet.
IETF RFC 4180, CSV record and quoting conventionsMicrosoft, keeping leading zeros when importing CSV
Check quoting and formula-like text on page 1
For a text-based example, select page 1 and choose Existing text. The Shelf, steel item contains a comma, and its note contains quotation marks. A CSV reader should show each as one field. The merged title occupies A1 and the remainder of that row has three empty fields.
The =A1 note in the Clamp row receives a visible apostrophe in the CSV export. Keep that prefix if you open the file in a spreadsheet. Other consumers can see the prefix as part of the field.
IETF RFC 4180, CSV record and quoting conventionsOWASP Foundation, spreadsheet formula interpretation in CSV
Common questions
What if OCR puts numbers in the wrong column?
Use the source preview to move the values into the correct cells. Add a missing row or column in the grid before exporting.
Why does a displayed record have more than three commas?
A quoted field can contain a comma. Read the export with a CSV parser that recognizes quoted fields and doubled quotation marks.