Skip to content

Tool for converting a Santander Business Banking "Excel" file into a CSV

License

Notifications You must be signed in to change notification settings

fishpercolator/santander-csv

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 
 
 
 
 

Repository files navigation

santander-csv

This is a tool for converting a Santander Business Banking "Excel" file into a CSV.

Overview

Santander Business Banking in the UK generates statements in a format it calls "Microsoft Excel", with a .xls extension, but are actually HTML files.

My accountancy application Clear Books requires files in CSV format. This tiny Ruby script converts the file to that format using Nokogiri.

Usage

./santander-csv.rb Statements11111111111111.xls > output.csv

About

Tool for converting a Santander Business Banking "Excel" file into a CSV

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages