Transformation files allow administrators to set up the rules for reading data from an external source and putting it in the proper form for your BPC database. Transformation files are Microsoft Excel files that contain one worksheet, named Instructions. The Instructions worksheet has three sections named options, mapping and conversion.