Wide tables need more than smaller text
A spreadsheet with many columns can become unreadable if every column is simply shrunk to fit one portrait page.
1into1 keeps a minimum readable column width and treats table width as a layout problem rather than endlessly reducing the text size.
Auto orientation switches wide tables to landscape
The current Auto setting counts the parsed columns. Tables with more than five columns use landscape; tables with five or fewer use portrait.
You can override that decision manually when the content inside the cells makes a different orientation more suitable.
Very wide tables are split into horizontal panels
When the desired column widths exceed the printable width, the renderer groups columns into multiple horizontal panels instead of forcing every column onto one sheet.
For suitable tables with more than two columns, the first column can repeat on later panels as an anchor so rows remain easier to identify.
Headers repeat on continuation pages
Each vertical continuation page redraws the current panel header before continuing the data rows.
The PDF also carries global Page X of Y numbering across all panels and continuation pages, which helps when a large table spans many sheets.
Remember that CSV does not contain workbook presentation
If you exported the source from Excel, CSV carries text and values rather than the original workbook formatting, graphics or objects. Microsoft explicitly warns that formatting is not retained in CSV and text formats.
The PDF theme, widths, wrapping and pagination are therefore generated by the converter rather than copied from the workbook appearance.
Official sources reviewed
- Microsoft Excel — Save a workbook to text or CSVExplains that CSV and text exports preserve delimited values but do not retain workbook formatting.
- Microsoft Excel — Formatting not transferred to CSV/textDocuments formatting and feature loss when worksheet data is saved as CSV or tab-delimited text.