Data Mapping Tool

The client is a German precision engineering company who asked us to create an Excel tool. This tool should automatically read data from individual files located  in a specific folder into an excel spreadsheet. Furthermore, the tool should provide the function to export the data into yet another format.


  • programed in Excel VBA
  • Menu-driven
  • using mapping table for the translation of data
  • translating data from highly bespoke TXT format to Excel
  • exporting files in yet another file format
  • reading automatically all files in a specified folders according to defined rules

If interested in our services, please contact us for a free quote.

Excel Software Solutions