Skip to content

Dear Internet Explorer user: Your browser is no longer supported

Please switch to a modern browser such as Microsoft Edge, Mozilla Firefox or Google Chrome to view this website's content.

Python logo

SQL to CSV via Python, with Headers

Posted 7th June 2019

1 comment

Nifty Python code that converts a SQL database file into a CSV file and includes column headers.

Read the full story...

PowerShell logo

Merge multiple CSVs with PowerShell

Posted 28th June 2016

9 comments

Use this simple PowerShell script to merge multiple CSV/TSV/TXT files into one.

Read the full story...

Convert CSV to XLSX via PowerShell

Posted 9th March 2016

38 comments

A nifty PowerShell script that will take a delimited CSV file and convert it to a XLSX file.

Read the full story...

VBA: Convert text to columns for all worksheets in Excel

Posted 26th November 2015

7 comments

A small Visual Basic for Applications (VBA) script which will loop through all sheets in an Excel workbook and convert text to columns.

Read the full story...

PowerShell logo

Combine multiple CSVs into one XLSX via PowerShell

Posted 25th November 2015

17 comments

A convenient PowerShell script that will detect all of the CSV files in a directory and merge them into a single XLSX file. Each CSV becomes a worksheet in the XLSX.

Read the full story...

PowerShell logo

Batch rename files using PowerShell and a CSV

Posted 23rd November 2015

8 comments

Use this simple PowerShell script to change hundreds or thousands of file names automatically, based on a CSV.

Read the full story...

PowerShell logo

Automatically delete files listed in a CSV

Posted 26th September 2014

2 comments

A PowerShell script that reads a list of files in a CSV and deletes them from a computer drive automatically.

Read the full story...