Find User here you can look for a user

Importing .csv Data Into EZ Register

2y
#1
I had a request from an EZ Register user to be able to import data from a now defunct Android app called simply Checkbook, created by Digital Life Solutions, LLC. I looked into the Checkbook app, and saw that when you exported the account data as a spreadsheet, you were actually given a standard .csv file. EZ Register v1.14.0 and above now has the ability to import this .csv data directly into an account. Although this feature was designed specifically to import data from the Checkbook app, it can be used to import any data that is saved in .csv format, so long as the data is arranged in the same way.

The only real requirement is that your .csv columns (fields) be arranged in the following order: "category","description","value","date","check number","memo". The export on the old Checkbook app does this automatically, but you can also create data in a standard spreadsheet application like Excel or Libreoffice Calc and save it as a .csv file, and EZ Register will be able to import it, so long as the columns are arranged in the same order. Below is some sample .csv data:
"category","description","value","date","check number","memo"
"Starting Balance","Starting Balance","20.23","Mon May 31 09:09:41 CDT 2021","","null"
"Allowance","a cool deposit","52.0","Mon May 31 09:39:41 CDT 2021","",""
"Food","mcdonalds","-16.25","Mon May 31 09:40:41 CDT 2021","13",""
In a spreadsheet application, the same data may look like this:

categorydescriptionvaluedatecheck numbermemo
Starting BalanceStarting Balance20.23Mon May 31 09:09:41 CDT 2021
Allowancea cool deposit52.00Mon May 31 09:39:41 CDT 2021
Foodmcdonalds-16.25Mon May 31 09:40:41 CDT 202113

Either way, once you have your *.csv file, importing it into EZ Register is fairly straight forward. Create a new account in your ledger for the data, and then once in the account, select Import .csv from the menu, and choose your data. Your account will be populated with your exported transactions.

That's all there is to it! If you have issues or questions with this feature, feel free to reply to this thread.
Owner of Ape Apps, LLC
Welcome
Ape Apps, LLC is an independent software development company founded in 2010 by Brandon Stecklein. Over the years, Ape Apps has published over 400 apps and games across various platforms. You can get in touch with Brandon on Twitter or by leaving a post on his wall @bastecklein
App of the Day