Table methods

You can choose from among the following options for extracting tables:

method	based on	description	comments
NLP Table	large language models (LLM)s	Extracts a table based on your prompt to an LLM.	Low code, doesn't require an anchor. Slowest table method.
Fixed Table	layout	Extracts tables with a fixed number and layout of columns.	Faster than NLP Table method.
Text Table	layout	Extracts tables based on column coordinates in inches.	Fastest table method.

method	multiple pages	merged cells	variable column formatting	checkboxes in cells	Tables-in tables, labeled rows, and other complex formatting
Fixed Table	✅ Omits repeating column headings from output.¹	✅ If you specify the Stop parameter, Sensible populates "empty" spanned cells with the spanned value. For an example, see Merged cell example.	❌	✅ If you specify the Stop parameter, Sensible returns the selection status for checkboxes in table cells as `"[true]"` or `"[false]"`.	❌ Use Sections as an alternative
Text Table	✅ Supported if you specify the Stop parameter. Omits repeating column headings from output.¹	❌ Sensible returns the first merged cell's value, and returns subsequent spanned cells as nulls.	❌	❌	❌ Use Sections as an alternative
NLP Table	✅ To troubleshoot intervening non-table text, use the Page Span Threshold parameter.	Indeterminate. Usually supported without additional prompting.	✅	Indeterminate.	Indeterminate. Use Sections as an alternative.

For multi-page tables, the Text Table and Fixed Table methods omit any rows that precede repeated column headings after the first page. To prevent Sensible from omitting these rows, use the Text Table's Y Offset parameter to ensure the first row of table data is one that doesn't repeat in the table. For example, use a negative Y Offset parameter value to capture the table's title as the first row.
The Table method is deprecated. To duplicate this method's function, use the NLP Table method and set the Rewrite Table parameter to false. For information about the Table method, see (Deprecated) Table method.
For large spreadsheets that contain tens of thousands of rows, use Cell Rows as an alternative to table or section methods.

Updated 3 days ago