HOME / COMMUNITY Switch to knowledge base

Clydesdale Bank - Error mapping columns when importing csv file


new one on me; I have been importing bank statements from CSV file and now seem unable to do so; this is the error message


Hi @frangipaniannie

Are you able to give me any more details please?

  • What bank was the CSV file for?
  • Did you map the columns yourself?
  • Would you be able to send me a copy of the CSV file by private message at all please (click my name and then ‘Message’)?


Hi there, yes it’s Clydesdale Bank - I epxport transactions to Excel CSV, then upload; yes I map the columns - yes will send now, many thanks for your promptness


In case anyone else is experiencing this issue, the CSV file contains whitespace after amounts that are in whole pounds (e.g. 50, 25, 100 etc.). But the whitespace isn’t a normal space from the space bar.

To fix this, you need to open the CSV file in note pad, highlight and copy one of the spaces with the comma:

Go to Edit > Replace, paste the space and comma in the find box, and replace it with just a comma. This should fix it.

If you need help with this, please let us know :slight_smile:


Sorry can you explain this again, or show what you mean.

I am experiencing problems uploading historical .csv files from clydesdale to QuickFile. I have downloaded the ‘Save as CSV Format(Extended Transaction Narrative)’ version is this the correct versions to download?


We have just joined QuickFile and while I have managed to upload current clydesdale bank transactions (transactions since we have activated Yodlee) I can’t upload historical transactions. I have downloaded csv file but it is giving error message. We have a years worth of transactions to upload, so not something I can do manually.

Yodlee bank feed not working - Clydesdale bank


I will send you a private message to see if we can get this working for you. Please look for a notification in the top right corner.