Converting complex excel file into easy to process template

Hi Support team

We receive different Excel templates (Tariffs) with different formats and we need to import the data form each of those Excels into a destination Excel that is always the same.

If the tariff files had the same format the problem could be easily solved with our Python script.

The main problem is importing the data with the Tariff files that are going to be different from the others into the destination template.

Converting the files manually is a very time-consuming operation and I hope that we can solve this problem by using your software.

Thank you

 

Hi Oscar

Welcome to the forum

Please have a look a the following article.
www.etl-tools.com/excel/converting-compl...-simpler-format.html

Please keep us posted on your progress

Thank you, that worked great