Utility Mill

Have ever been working in a spreadsheet and thought "I wish I could just use SQL on this"? Do you have create table privileges on a database somewhere? If so you can now explore your spreadsheet in SQL.

This utility will let you turn this:

into this:

DROP TABLE IF EXISTS `pet_store`;
CREATE TABLE `pet_store` (
`ID` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
    `class` VARCHAR(255) NULL,
    `owner` VARCHAR(255) NULL,
    `location` VARCHAR(255) NULL,
    `last_ate` DATETIME NULL,
    PRIMARY KEY(`ID`))
ENGINE = InnoDB;
INSERT INTO `pet_store` (`class`,`owner`,`location`,`last_ate`) 
VALUES 
('Alligator','Lucy','NC','2008-01-01'),
('dog','Allen','NY','2008-10-10'),
('cat','Josh','NM','2008-10-10'),
('stork','Jenny','AZ','2008-10-10'),
('canary','Alfred','AZ','2008-10-10');

Which you can then run in your database to generate a table with the same data as your spreadsheet or other CSV source.

Just paste in the values from your spreadsheet or other CSV source with the first row being the column headers into the INPUT box.

You can now run useful queries on it now like:

select class as WATCHOUT from pet_store where class='alligator';