Currently, Wallet only supports CSV files. Please make sure of the below given minimum requirements before you import a data file:
Minimum required information
For Wallet to generate a Record from your data, it must at least have information about the Amount and Date for every transaction. Wallet may not support your file if it doesn’t contain relevant data to match these fields.