Imports are fiddly. Since Import templates define the sequence and format of the data coming into Adagio, and the data file itself can be generated from another source, you need to carefully match the two.

Try and create a single record that imports properly. Or, check out the import examples in the general ledger sample data. If you say "CSV" and are importing an account and department code - these are text fields and need quotes around the values. If the data is coming from Excel, then import directly from the Excel spreadsheet, rather than saving the table as a CSV. Make sure that the account-department column is formatted as text.