Category Archives: Excel

Excel Lookup Lists with Tables

Good article on Excel lookup validations using a table column as the value source:


Build SQL from Excel sheet

Use this Excel function to build insert statements from Excel data:

=”insert into [table name] select max(id)+1 , ‘”&A2&”‘ from [table name]”

Excel row formatting rules

A great tutorial on different formatting rules: