How to I programme the excel such that it will automatically import all the
Text file generated from the measuring equipment and arrange them in a
particular format that I want.?

If your text file has a filename with an extension .txt, then start
Excel and do File | Open with "All files (*.*)" selected as the file
type - identify your file and click open. Excel will automatically take
you into the Text Import Wizard, which has 3 stages:

Stage 1: specify if fixed-width or delimited
Stage 2: specify the character used as delimiter
Stage 3: specify the data type for each column

When you click <finish, the file will be loaded into Excel.

You should practice this a few times, then you could record a macro
while you do it, so that in future you would only need to invoke the
macro to do it for you automatically.

Hope this helps.

Pete