This online tool will make it easy to exchange data between the business and IT.
The business can deliver a list of key numbers from an Excel sheet as an IN string to be used in a SQL query in the database.


A view optoins are added for different transformation purposes and types of data.

  • No table data insert needed in production databases
  • No ODBC connection with database needed
  • No Excel scripting macro functions needed
  • Just email your key list and get corresponding data back from IT
  • Leading zeros that drop off in Excel can be restored

Put your list here and in return you will get an IN() string for the SQL database query.
 With quotes for VARCHAR  
 Remove the dots from the numbers  
 Only distinct values  
 Left padding with 0   to # positions

Need more options? Please let us know!