Skip to content

Troubleshoot a conversion

Resolve a wrong format guess, missing rows or an output that needs different fields.

Open the converter

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.