Automated Text Import in Excel with File Selection - The Easy Way - VBA

200+ Video Tutorials - 200+ Downloadable Excel Reference Files - 50+ Hours of Content

How to import a text or csv file into Excel using an automated macro and vba - this is the easier, yet robust, way to import text using a macro, with user-selected files or hardcoded file names.

This tutorial teaches you how to import text using a macro with a file selection popup window that lets the user choose the file to import and also using a predefined file name so that you can quickly import the file without having to choose it from the computer.

All code in this tutorial is commented and fully explained and I take you step-by-step through the process of building the import macro and showing you how to change it to meet your needs.

This tutorial combines many VBA features, including:
- GetOpenFilename()
- OpenText
- IF Statements in VBA
- Copying values between workbooks in Excel.

Excel Courses:

#msexcel #howto #tutorial

[philipboakes]

Really helpful. The explanation is absolutely clear, have been a subscriber for a while now and glad I found your channel. Thanks.

[pj]

Superb! Well documented and explained. Thank you

[BUSINESSRESOURCES]

Thanks so much for this excellent video. I create Excel systems for subscribers and usually I have them copy/paste input data. Now I can have them import directly from CSV/Text. What I want to know is how to append newly imported data to the first empty row (on the master) automatically. I imagine this might be a more advanced topic.

[DuyenLe-ktxx]

A very informative and helpful tutorial ever, I'm truly thankful.

[vishptel_]

Thank you so much. Great explanation. This is my first time writing any sort of code and this helped me greatly with my task. Keep up the great work. 😊

[jackiebanta]

Hello, i love this video! Very helpful. Is it possible for you to add one more to this coding? Add the CSV file name that was selected in any cell. So when anybody else is looking at the excel file, they know where the data came from.

[kannanmassey]

Very well explained. Thanks a lot
Current range selects only column A

[darrylmorgan]

Great Tutorial!! Really Enjoyed The Explanation For The Cool VBA Code...Thank You Sir :)

[mateomontoyanaranjo]

Thanks mate, this really helped me heaps

[satishloke]

great, simple, complete, to the point,

[roor]

Excellent Tutorial! Well put together and thorough. I do have a quick question. Is it possible to bring the data in without disrupting the formatting with Workbooks.OpenText? I've tried to figure out a way but and getting stuck. Thanks!

[TeachExcel]

200+ Video Tutorials - 200+ Downloadable Excel Reference Files - 50+ Hours of Content

[lucabottini]

Thank you so much! No other words to say! =)

[harycan]

Unbelievable fantastic, supper, thank you .❤❤❤❤

[robertkaniewski]

Thank you so much.. Is it possible to import data to a specific row, e.g. no. 10?

[juliopaniagua]

I am learning a lot from you... but I still need to find a way to keep adding data (from more text files) to the same table... do you have a video about that?

[omarrahim]

Great work, respected sir. Please export code for txt paper, as well as import code from txt paper. Thank you

[diwakarsingh]

for forward slash (\) what we take ?? Delimiter

[christopherlindsay]

This is awesome, but the code will not allow me to select where the file comes from (location). when I run the code, it automatically pulls up all the files on my computer, not just the text files in the location I put in originally with the "fileToOpen = "location of text file.txt". Do you have any advice on that?

[jcgaming]

This is an amazing tutorial, though I’m having issues with the leading zeros in numerical data in the CSV file not appearing and then not importing through to the destination file. Any tips on how I can fix this in the VBA code at all?