Created attachment 203516 [details] example CSV with 3 columns, label row and 100 records Download the attached csv file to your PC. Start a new spreadsheet. Define a database range "myImport" for range $Sheet1.$A$2:$C$101 and make sure that "contains column labels" is unchecked (that is in Options). Menu > Data > Data Provider. In that dialog do these: * in section `Source` select the database range "myImport". * Click on the `Browse` button and select the downloaded csv file. * in section `Transformations` select entry `Split Column` and click on `Add` button. You get additional fields. * In field `Separator string` insert a pipe symbol, that is | . In field `Column index` enter 1. Click the `Apply` button below the Preview. * in section `Transformations` click on `Add` again to insert the next `Split Column` transformation. * Enter the pipe symbol in the field `Separator string` and value 2 in `Column index` field. Click the `Apply` button below the Preview. * In section `Transformations` select entry `Delete Rows` and click on `Add` * In field `Lookup value` enter text `Rank`, in field `Column index` enter 1. Click the `Apply` button. The preview looks good. Click on OK button. You should have got a list with 100 popular male and female English names without header row. Make sure you save to extended ods format. Save the document. Reload the document. Your data shows the deleted row: Rank, Males, Females Reason is, that the transformation type DELETEROW_TRANSFORMATION is not handled in the switch in https://opengrok.libreoffice.org/xref/core/sc/source/filter/xml/xmlexprt.cxx?r=73a6735652dc5bbb4ac51743f41bbed3fe5d1060#4212