LEARN THIS Advanced Excel Trick in 5 Min! How to Import Multiple CSV Files into Separate Worksheets

In this tutorial you will learn how to import multiple CSV files into separate worksheets in the same workbook in Excel. Instead of combining the CSV files into one worksheet, you can use a Visual Basic Script in Excel to import multiple CSV files into different tabs. The VB Script will name each Microsoft Excel tab with the same name as the CSV file. Once you have imported the CSV files into the worksheet they can be saved and formatted like any other Excel workbook.

Visual Basic code: It would not let me put it in the description so I put it as a pinned comment.


Support me with your amazon purchases: https://melcompton.com/recommends/ama...

Check out these programs I use for YouTube
Bluehost discount: https://melcompton.com/recommends/blu...
Canva Pro Trial: https://melcompton.com/recommends/can...
Adobe: https://melcompton.com/recommends/adobe/
Filmora: https://melcompton.com/recommends/won...

Follow me on social media:
Facebook:   / therealmelco.  .
Twitter: @melissaecompton
Instagram: @melissaacompton
LinkedIn:   / melissa-c.  .


This description contains affiliate links and I may be paid a small commission should you purchase using these links.


_________

LIKE. SHARE. SUBSCRIBE.

Give this video a thumbs up if you enjoyed watching 👍

#tutorial #howto #exceltips

Thanks for watching the video LEARN THIS Advanced Excel Trick in 5 Min! How to Import Multiple CSV Files into Separate Worksheets