I have a dataset consisting of more than 50k .csv files, all files are in the same format now and I need to perform some procedures on all of these files (text to columns, basic calculation - summary of certain columns, etc.). I googled some codes, but none worked for me, could you pls help me?
Maxxino,

Let me be the first to welcome you to VBA Express, IMO, the best site for help on all Microsoft Office Questions.

Unfortunately, you did not provide enough information for us to get started. Can youGive a 5 line sample of real data from one of the CSV files?
Then add another sheet to the (xlsm) workbook to show what you need as a summary.

Be sure to use the actual data in the five rows on the CSV sheet. Make the example complete, that is use all the formulas needed, although we might be using VBA code to accomplish the same things.

With only 5 rows used, there will be plenty of room for notes so we understand exactly what is needed.