Skip to content

Instantly share code, notes, and snippets.

@tomhodgins
Last active Dec 4, 2021
Embed
What would you like to do?
Paste this function into your JS console on CIBC's online banking website to scrape your account ledger into a CSV formatted file the browser can save that can be imported into Excel
function cibc2csv() {
var table = document.querySelector('table.smart-account')
var csv = ''
var head = []
var row = []
// read header cells
table.querySelectorAll('thead th').forEach(th => {
head.push(`${trim(th.textContent)}`)
})
// add header cells to CSV
csv += `${head.join(', ')}\n`
// read body table cells
table.querySelectorAll('tbody tr').forEach(tr => {
tr.querySelectorAll('td').forEach(td => {
row.push(`${trim(td.textContent)}`)
})
// add each row's table cells to CSV
csv += `${row.join(', ')}\n`
row = []
})
function trim(string) {
return string
.replace(/,/g, '') // remove commas
.replace(/^\s+/, '') // remove leading whitespace
.replace(/\s+$/, '') // remove following whitespace
.replace(/\s+/g, ' ') // collapse adjacent spaces
.replace(/[\n\t]/g, ' ') // convert tabs and newlines to spaces
.replace(/Free transaction$/, '') // remove specific text
.replace(/³$/, '') // remove specific text
}
function format(string) {
return trim(string)
.replace(/\s/g, '-') // convert whitespace to dashes
.replace(/[\(\)]/g, '') // remove brackets
}
function download(file) {
var link = document.createElement('a')
var header = document.querySelector('.search.row header h3').textContent
link.download = `cibc-${format(header)}.csv`
link.href = `data:text/csv;${file}`
return link.dispatchEvent(new MouseEvent('click'))
}
return download(csv)
}
// Download CIBC data as CSV file
cibc2csv()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment