Need to import transactions as CSV/Excel file, but Xero does not import it or requires to change th file first? Try the ProperConvert app at https://www.propersoft.net/ and convert a CSV/Excel file to the OFX format and import into Xero.
00:00 Xero import options
00:45 Start the convert app
01:50 CSV Mapping
04:00 OFX Settings
06:42 Import OFX into Xero
07:13 Review imported transactions