When a corrupted file has gibberish inside the data, you can remove the unintelligible information by using the Row offset column.

Row offset

To move data to the left, double-click a row in the column and enter a value.