2SQL

A simple tool for working with CSV/TSV data

Oct 10, 2024

2SQL lets you easily import several data files that are instantly available as SQL tables. You can then write queries using the tables.

While my day job revolves around creating and managing AD and Google users (and creating amazing logo’s like above), 2SQL can be used for any scenario where you have CSVs, TSVs or Fixed Width data files.

A Quick Look

In this screen capture below, we’ve taken exports from AD and our SIS to write a Powershell script for creating AD accounts for new students. This script is one of the more complex examples.

(This demo data is included with the 2SQL download)

In the demo, three new students were found. A ready to paste Powershell script was created like this:

For a less complex example, I’ve created a short walkthrough video. In this example, we’re suspending Google accounts for students no longer in our system.

2SQL is written in XOJO Professional 2024. It has SQLite built in, so no other SQL software is required.

This is freeware, and is a public beta.

The software does not have or need an installer. Just unzip it anywhere, and start using it. To get rid of it, just delete it.

Two folders are created on first launch.

‘2SQL Projects’ is created in your Documents folder.

‘2SQL’ is created in your AppData folder.

This page barely scratched the surface. I will be creating several more pages detailing how to get the most out of 2SQ, and linking them from this page soon.