ToolpanePractical guides
Spreadsheet & data guides.
Work through a complete task, check the example and choose the right tool for your data.
Convert an Excel column to a SQL IN list
Keep leading zeros and escape apostrophes when preparing a list of identifiers.
Find missing items between two lists
Compare two exports and identify missing codes, additions and shared values.
Convert a spreadsheet table to Markdown
Turn spreadsheet cells into a Markdown table for a README or document.