To SQL

About

To SQL is a utility for taking tabulated data sets And easily transforming them into a temp table for ingestion into a SQL server. This can be used to help troubleshoot, or perform various-based comparisons of data sets. This is meant to replace the arguers task of creating a well crafted Excel content function, which can be a bit frustrating when counting all those commas, both function argument separators and inside the insert statement.

All processing of data is performed locally. Nothing leaves your machine to be processed by another computer for the data input.

This project is open source. If you want to request a feature enhancement, report a bug, or help out with a Pull Request here.

DISCLAIMER: This is a work in progress and has not been tested entirely. Use at your own risk.

Always check the sql output before executing on an actual server. Sql Injection is a thing. Although there are some basic protections used in this site there is still the ability

Known Issues

Menu

Table Values to SQL Temp Table

back to top


Rows to IN Clause

back to top

Takes a line delimited list and outputs the values as an in statement with ' wrapping it.