How To Easily Import and combine CSV and XLS Files Into Excel + Free Cheat Sheet

In this VBA For Beginners training, I show you how easy it is to use VBA to import any CSV file into Excel in a single click. I also show you how you can import unlimited # of csv files from any folder into Excel.

⬇DOWNLOAD THIS WEEK'S WORKBOOK TEMPLATE HERE:

EXCEL COURSES:

EXCEL PRODUCTS:

Timestamps:
0:00 – Introduction
1:33 – No Experience In VBA? I got You!
3:44 – Import CSV File
13:20 – Import Multiple CSV Files

Follow me on my Social Media Accounts:

About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.

Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:

New Training Video Uploaded Every Tuesday And Saturday!

Thank you very much for your continued support,
Randy Austin

#ExcelVBA #ImportCSV #CSVImport #ExcelCSVImport #ImportCSVIntoExcel

[DerickPitcher]

You know, it seems every time I need a solution to make my apps more efficient here you are sharing exactly what I need. Thanks again Randy.

[keitamoussa]

Finally !!!! I asked for and you deliver.
Thanks for your continuous teaching and sharing.

[carloscrespo-riera]

Randy, once again, thanks for sharing your skills and knowledge.

[SyedMuzammilMahasanShahi]

Thank you so much Randy for this amazing video.

[icryps]

Hi, if possible, can you make a video on Trading Journal (Trading Logbook) | Stock, Forex, Crypto, Futures, options..

[WilliamPilot-prpn]

Hi, do you have any videos on Asset Management, especially on land and property management?

[bigE]

This is awesome! I've used ADODB connections and this seems much more simple to write. Two questions: would this work when importing data from an Excel table in another file? If you set the Background Query to true would it automatically refresh if the CSV file is changed by another user or is that just specifying whether to perform the query when you hit the RefreshAll button?

[RonDavidowicz]

Wonderful video.

2 questions:
1) why didn’t the macro get stuck on the jpg file?
2) why do you use “Set” when defining some variables and not on others?

Thanks

[danp]

Hey Randy. is there a reason why you don't use. rows.count.
LastRow = sheet1.cells(rows.count, 1).end(xlup).row

[nmbranalyst]

Will this work for csv and excel file in the cloud... or only local files?

[barryc]

Randy i have a small issue. This is perfect for what i need Although every time i run the Multiple CSV file import it creates a new connection for each run so i have over 50 seperate connection for 3 CSV files? is there any way to avoid this. Many thanks in Advance

[St.MarkInternationalSchool]

Mr Austin please can you do a tutorial on how to prevent duplicate entries when saving data from one worksheet to another

[esaiepaul]

Hi Randy! is there a reason why you don't use Power query in Excel for this solution instead of vba please?

[ForeclosureGhost]

Is it just for cvs files or will it work for txt files?

[malcolmsokol]

Very informative but a question about a situation that has plagued me in an application. I have a field in my import that is a text label such as 2B18, always four characters. But it could be 1E06 which is also a scientific notation for a number and if the format is General or Number it becomes one million. This behavior also occurs even if the column into which the import is formatted as text. What I get is the text value of or 3E17 if it can't fit in a fixed width number. The problem is the data import process. To get around this in current Excel I need to use the Legacy Widget for importing Text Files which allows me to specify each of the columns format from the default of general. If I specify TEXT in the widget, the imported file will show correctly as the text such as 1E17. I have noticed the same issues occur when you do a text to column conversion but fortunately the Widget pops up and allows for the column to be treated as text. Standard imports without a widget do not work. So hopefully the array of types you use is the same as what occurs in the widget. Not sure about how your apps will work so maybe I will download and check it out.

[kingprovise]

what if sheet1 is already full. hope you could make it transfer to sheet2. thank you

[NhiNgo-upjs]

I try to apply change data type the same as your guildline but it not work :(