The easiest way would be saving the spreadsheet to .csv format and importing
that to Gnucash.
Id recommend:
- first removing any other text and stuff you have so that the spreadsheet is
just the headings you want and the data you want in columns
- doing the import on a new test gnucash file first if you have a lot of data
already in your gnucash book. Just in case.
Good luck!
Thanks and regards,
Matt
-------- Original message --------
From: Jeff Abrahamson <j...@p27.eu>
Date: 21/2/18 05:00 (GMT+10:00)
To: gnucash-user@gnucash.org
Subject: importing splits
I'm processing check deposits. I have a spreadsheet with lovely columns
like name, check number, amount, and the account to debit. It seems a
shame to retype it all.
I see some old discussion on the list that, essentially, says this is
not well supported if supported at all.
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fpipermail%2Fgnucash-user%2F2014-October%2F056617.html&data=02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636547464489079590&sdata=uG5aM8vQ0%2FJ6JvudouGDUL%2F%2BJaLVQvq%2FOQcX93gD%2BaA%3D&reserved=0
Is there anything since that might help? I'm not sure converting
spreadsheets to QIF to then import into gnucash is better than retyping.
--
Jeff Abrahamson
+33 6 24 40 01 57
+44 7920 594 255
https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fp27.eu%2Fjeff%2F&data=02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636547464489079590&sdata=Y%2FRcHTU8yWdltXDL4zBTAMPN8grAsKCwY7mf%2FQfmhyw%3D&reserved=0
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636547464489079590&sdata=LnIFOxRytZiVO6O4On68c7%2B%2FT6DbEEEOclsFRTwyxyo%3D&reserved=0
If you are using Nabble or Gmane, please see
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Lists&data=02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636547464489079590&sdata=gnCglOKNDVqlWOaz1Wc4ilJcgVFWM9OkBtXcCFXJdWE%3D&reserved=0
for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
