Import txt file in Excel

I am new to macro ad want to import a text file into excel

1. Text file = test.txt
2. Want to import text file to a certain worksheet (sheet1) start at row 0 and column A
3. All data from txt file must be imported.


Go to the Data Menu and Import text file

Importing text file into excel sheet

(for formulas, depending on your country, you might have to change ; with , or the opposite

Other excel answers



You can find similar Excel Questions and Answer hereunder

1) How can I get users to select a folder to save the output of my macro?

2) How can I clear cell after activating a routine when there is a change in value of a cell?

3) How can I extract file name from a full path including folder path and file name?

4) How do I copy a Table from one location to another and retain all formulas, formats and columnwidths?

5) Vba code to password protect workbook in Excel

6) How can I set Page orientation, Zoom % , Title Rows and footer using VBA?

7) How to disable ability to insert Rows and Columns in Excel (using VBA)?

8) Here an explanation about the file dialog and how to control in with VBA

9) How can I export a WorkSheet as a PDF using VBA?

10) Is there a way I can recover unsaved work?


Here the previous and next chapter