Review a PDF inventory table before export
Admin ·
The inventory sheet contains quantities and digit strings serving as identifiers. Review their spellings and choose the export type before opening the data in a spreadsheet.
Read the tagged inventory table on page 1
Download the sample inventory PDF from the workspace and open it. Set Pages to 1 and keep Existing text. Read PDF tables. The tagged table has five rows and four columns. Compare cell A1 with the source heading North shelf inventory.
Open View original PDF page 1 and compare the grid. Cell B3 reads 00427. Cell B4 reads 12345678901234567. Keep both as identifiers.
Keep the bin codes while typing the quantity
Choose Numbers where exact for columns B and C. Set cell C3 to 19. The bin codes retain their text type even though column B allows exact numbers.
Choose JSON and create the export. In tables, check the physical page number, sourceLabel and merges. The third row contains the string 00427 and the number 19.
Choose the file that matches the next application
Choose Excel workbook and create a new export to open the table in a spreadsheet with the merged title and typed columns. Use CSV if you only need the displayed table and its cells.
In CSV, the field that starts with =A1 has a leading apostrophe. The spreadsheet import treats it as literal text. Set the identifier column to text when importing the CSV.
Common questions
How do I review a table that comes from a scan?
Choose the English OCR mode and read the selected page. Compare letters and digits with the retained page preview before saving.
What is the number beside a table in the review list?
It identifies that table within its physical PDF page. JSON also records the page label from the source PDF.