Turn a PDF stock sheet into an Excel workbook
Admin ·
A printed stock sheet may show quantities alongside codes that happen to contain digits. Set the worksheet column types during the review so the quantities can be used in calculations and the codes keep their exact characters.
Open the native table on page 1
Download the sample inventory PDF. Open that file in the tool, enter 1 in Pages and select Existing text. Read the tables and open View original PDF page 1. The five rows and four columns include a merged title across the first row.
Compare the two Clamp and Washer rows with the source. They contain stock codes 00427 and 12345678901234567. Leave column B on Text so both values keep their digits.
Download the three-page inventory example PDFPDF Association, ISO 32000 PDF specificationMicrosoft, keeping leading zeros and large numbers
Store the units as numbers
Set Column C value type to Numbers where exact. Cells C3 and C4 should be marked Number for 18 and -2.5. The column heading stays text. To correct a verified count, replace 18 in C3 with 19 and check the new value.
Leave the Note column as Text. D3 begins with =A1 in the PDF. The workbook stores that value as literal text so it can be read as written.
Microsoft, keeping leading zeros and large numbersMicrosoft Open XML, spreadsheet cell types
Check the values and merged title in the worksheet
Select Create Excel workbook and download the file. Open Page 1 Table 1 in your spreadsheet application. The title spans A1:D1, B3 displays 00427, B4 contains all 17 digits and C3 contains the revised number 19. D3 displays the literal text =A1.
If a table comes from a printed scan, read it with English OCR and compare every digit with the original page before export. The worksheet keeps editable data and recognized merges. The PDF remains the reference for its page design, images and typography.
Microsoft Open XML, structure of a SpreadsheetML documentMicrosoft, keeping leading zeros and large numbers
Common questions
What happens to a quantity such as 12.50?
It stays text because the conservative numeric option preserves decimal spellings that would change. Enter 12.5 during review if that spelling and a numeric cell suit the workbook.
How do I omit a grid that was inferred from prose?
Select that grid in the page review and clear Include this table in the workbook. Each remaining table appears on its own worksheet.