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

Batch rename files using a CSV in Python

Posted 19th January 2023

No comments

Use this simple Python script to change hundreds or thousands of file names automatically, based on a CSV. This procedure will work on all operating systems.

Read the full story...

Easily create QR Codes in Word

Posted 16th May 2018

18 comments

Did you know that it is possible to generate fully-functional QR codes in Microsoft Word using mail merge without the need for third-party plugins?

Read the full story...

Add comments to Excel formulae

Posted 29th September 2016

2 comments

Are your Excel formulas getting out of control? Here’s an easy method to insert comments, so that you can keep track of what’s what.

Read the full story...

PowerShell logo

Merge multiple CSVs with PowerShell

Posted 28th June 2016

11 comments

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

Read the full story...

Duplicate Excel cells multiple times

Posted 13th April 2016

No comments

Use this Visual Basic script in Microsoft Excel to duplicate cells a specified number of times.

Read the full story...

Rearrange Excel columns via Visual Basic

Posted 16th March 2016

22 comments

A simple VBA script for rearranging the order of columns in an Excel spreadsheet.

Read the full story...

Convert CSV to XLSX via PowerShell

Posted 9th March 2016

51 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

19 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...

VBA: Delete all Excel columns except those named

Posted 16th September 2015

2 comments

Use this simple VBA script to delete all columns in a worksheet except those that are specifically named.

Read the full story...