• Sign in Join CharityConnect
  • About us
  • Terms of Use
  • Community standards policy
  • Privacy Policy

Powered by

Conversations
Back

The charity network that helps you shine.

Join 19,423 professionals and find your community in the UK charity sector.

Join CharityConnect

Transferring data from Excel to ODS

IT

S R Consultant Posted 2 years ago

Close popup

's badges

Helper’s Badge Level Five
Level 5 of 5
Superstar! This badge is awarded to members who have had 30 comments marked as Helpful
Helper’s Badge Level Four
Level 4 of 5
This badge is awarded to members who have had 20 comments marked as Helpful
Helper’s Badge Level Three
Level 3 of 5
This badge is awarded to members who have had 10 comments marked as Helpful
Helper’s Badge Level Two
Level 2 of 5
This badge is awarded to members who have had 5 comments marked as Helpful
Helper’s Badge Level One
Level 1 of 5
This badge is awarded to members who have had a comment marked as Helpful
For donors who have Gift Aided their gifts their data is downloaded from CRM in Excel format.
The HMRC Gift Aid portal then rejects the date (albeit it in their DD/MM/YY configuration) and amount, again pasted in their configuration, so I have to overtype each date and amount in the HMRC ods template which takes time and sends me bogged-eyed. Name / address are accepted without issues.
Can anyone please advise how I can successfully transfer data from Excel to ods without the above errors?
Many thanks
Report
{{postCtrl.totalLikes}} Like
Facebook Twitter LinkedIn Email Whatsapp

Optional. An image can be added at the top of the comment. Images must be in PNG, GIF or JPG format.

No responses yet. Be the first to reply!

{{ctrlComment.postTotalComments}} responses

Load more responses
See previous comments
See new comments

Related posts

Post Office Banking

Anonymous user

Admin, Ops, IT & Finance

Is Caf Bank still worth it for small accounts? (Anonymous post 🤫)

Ocean King

Admin, Ops, IT & Finance

Filing accounts online with Companies House

Kim Mullard

Admin, Ops, IT & Finance

Must directors of a CIC always be payed through PAYE

Vicky Gerrard

Admin, Ops, IT & Finance

What can we do if we’ve lost access to our VAT account after losing our trustee?

Debbie Plant

Admin, Ops, IT & Finance

  • About us
  • Privacy
  • Community standards policy
  • Terms
  • Advertise with us

Powered by

© 2026 JobLadder

Report an issue

Help us keep CharityConnect safe and friendly by reporting spam or abusive behaviour.

What's the issue with this content?

How is this content abusive or harmful?

Report an abusive behaviour

Likes

{{ item.userName }}

{{ item.userName }}

{{ item.userJobTitle }} at {{ item.userOrganisationName }}

Show More

Likes

{{ item.userName }}

{{ item.userName }}

{{ item.userJobTitle }} at {{ item.userOrganisationName }}

Show More
{{ msg }}

Sign in

Like this? You'll love what we've got inside. Sign in to like this post and see more

Forgot password

Don't have an account? Join CharityConnect today.

Likes

{{ item.userName }}

{{ item.userName }}

{{ item.userJobTitle }} at {{ item.userOrganisationName }}

Show More