Import a text file into Excel
Did you try to import a text file into Excel before? Sound simple but there's much more to it than just copy and paste.
In this how-to tutorial, we will see three ways to import a CSV file into an Excel workbook. The three was as below:
Open CSV in Excel directly
Using Power Query
3. Using AlchemyJ Extended Function (ajReadFile)
By using the above method, there's no need to manually copy and paste the data anymore.
Have a look and let us know what you think.