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

Powered by

Back

The charity network that helps you shine.

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

Join CharityConnect

Transferring data from Excel to ODS

IT

S R Consultant Posted 1 year ago

Close popup

{{badgesCtrl.userFirstName}}'s badges

Helper’s Badge Level One
Level 1 of 5
This badge is awarded to members who have had a comment 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 Three
Level 3 of 5
This badge is awarded to members who have had 10 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 Five
Level 5 of 5
Superstar! This badge is awarded to members who have had 30 comments 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. Unsplash.com is a great source for royalty free and high quality photos.

No responses yet. Be the first to reply!

{{ctrlComment.postTotalComments}} responses

Load more responses
See previous comments
See new comments

Related posts

Cyber security advice

Milly Moss

Admin, Ops, IT & Finance

No fee credit card for charities?

Phillip Abbiss

Admin, Ops, IT & Finance

Experiencing difficulty locating our Gift Aid number (Anonymous post 🤫)

Ocean King

Admin, Ops, IT & Finance

Rental office space suggestions in London

Farhaanah Patel

Admin, Ops, IT & Finance

How many signatories on the bank account?

Edward Bainton

Admin, Ops, IT & Finance

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

Powered by

© 2025 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.

{{ rootCtrl.infoModal.getTitle() }}

{{ rootCtrl.infoModal.getBody() }}

Likes

{{ item.UserName }}

{{ item.UserName }}

{{ item.UserJobTitle }} at {{ item.UserOrganisationName }}

Show More