messy csv export to a clean invoice, no spreadsheet

csv_hell · 2 months ago

our booking system exports a csv with like 30 columns and I need 4 of them. every month I open it, delete columns, fix the date format, group by client, paste the totals into an invoice. takes an hour and Ive got it wrong at least twice. dont want a data pipeline. want to upload the same shaped file every month, tell it once which columns matter, get invoices out. and the mapping should stick so next month is one click.