PDF data guides

Print a CSV stock table without losing identifiers

·

A stock table needs a printable version for the warehouse without changing the way each bin code is written. Make the table searchable and check that the values fit at the page size you need.

CSV to PDF

Select Load example and check that Separator is Comma. Keep A4 and Landscape, then select Prepare PDF preview. Read the station name Café, east as one cell. The notes show the quotation marks in Hold “dry” as literal characters.

Look for both bin codes, 00427 and 12345678901234567. Select Print or save PDF and choose Save as PDF. Search the saved file for either complete code.

RFC 4180 — Quoted fields and line endings

Repeat the headers on later pages

To test a longer report, paste the stock row repeatedly underneath the header. Keep Use first record as repeating header selected. The in-page preview shows up to 24 data rows. Use the print preview to inspect the actual page breaks.

Print on A4 landscape with the default margins and turn off the browser’s date and URL headers. On a later page, find Station and Bin identifier above the data rows.

Check a quoted field before changing the separator

In the example, the comma between Café and east lies inside double quotes. Keep Comma selected for this example. When the source uses tabs or semicolons, change Separator and prepare the preview again.

RFC 4180 — Quoted fields and line endings

Common questions

Is the PDF created from a screenshot of the table?

The browser prints the cells as searchable text. Select a code in the saved PDF to verify it.

What should I change when the table is too narrow?

Use landscape orientation, a smaller text size or narrower margins, then check the print preview again.

Sources

Put it into practice.

Related guides