Ключевые слова: add-in, excel, match, table, inner join, left join, right join, full join, vlookup function, filename, folder

It is an Excel Add-in that consists of two modules. The 'Join tables' module is specific in querying tables and performing results like in a database environment. This functionality is usually performed by the vlookup function in Excel. The 'Join tables' module enhances the work on querying tables by presenting an intuitive graphic user interface which makes it an easier process. With no need for writing functions or SQL codes, you can get query results in just a few seconds. The query results you can generate are like:
- All rows from both tables as long as there is a match between the columns in both tables.
- All rows from the left table, with the matching rows in the right table. The result is NULL in the right side when there is no match.
- All rows from the right table, with the matching rows in the left table. The result is NULL in the left side when there is no match.
The 'Get filenames from folder' module will help you write filenames in Excel cells. One can write up to 1,048,575 + 1 filenames from the specific folder and/or subfolders into Excel cells. Also you can get extra information along with the filename, such as full path filename, full path directory name, parent directory name, etc.