• 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,288 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

'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

No luck with opening a bank account

Marina Barham

Admin, Ops, IT & Finance

Using paypal to take payments at multi sites

Michelle Hamilton

Admin, Ops, IT & Finance

Beacon review

Veronica Ghobert

Admin, Ops, IT & Finance

Looking for Expense and Travel policies

Anonymous user

Admin, Ops, IT & Finance

Cost of living increase for 2026/27

David Partridge

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