importing splits

[Matt Graham]

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 <jeff at p27.eu>
Date: 21/2/18 05:00 (GMT+10:00)
To: gnucash-user at 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 at 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.