Excel Workbooks

Reconify supports .xlsx and .xlsm files.

parser:
  type: xlsx
  sheet: "Transactions"
  date_col: "Date"
  date_layout: "2006-01-02"
  amount_col: "Amount"
  multiplier: 100
  ref_col: "Reference"

If sheet is omitted, the first sheet is used.

Unsupported .xls

Legacy .xls files are not supported. Save the workbook as .xlsx or export it as .csv.

Debugging

Run:

reconify parse --source bank --file data/bank.xlsx --format table

If the wrong sheet is read, add sheet. If headers are not found, confirm the first row of the sheet contains the column names.