Everything is in one column
Check the source format first. Copied spreadsheet cells usually use tabs, so choose TSV. If the separators change or the columns are aligned with spaces, try Make sense of this and inspect the suggested pattern.
I expected more rows
For a workbook or database, check the selected sheet or table. For JSON and XML, check Row mapping. The table preview shows up to 100 rows and 60 columns. The download uses the full result.
An output refuses the data
Open Formats and read the requirements for the output. Subtitle files need start, end and text columns. TOML cannot store a null value. Use JSON to inspect what came in before choosing how to handle the field.
No pattern was found
Pick a line that resembles several others and use Teach by example. Highlight the changing values and give each a name. Compare the result with an unusually short or incomplete line before saving the recipe.