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.
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.
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.
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.
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.
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.
Batch rename files using PowerShell and a CSV
Posted 23rd November 2015
9 comments
Use this simple PowerShell script to change hundreds or thousands of file names automatically, based on a CSV.
Automatically delete files listed in a CSV
Posted 26th September 2014
3 comments
A PowerShell script that reads a list of files in a CSV and deletes them from a computer drive automatically.