#HowTo import multiple CSV files from a folder with their filenames in #MSExcel using #PowerQuery

More than 80% companies worldwide, use Excel for doing daily tasks. It is an incredibly powerful tool in business. Learning excel helps to climb the career ladder comparatively faster.

To learn MS Excel and enhance your skills, enrol in our upcoming Excel course.

*Duration*: 20 Hours
_*Starting from 23rd Nov 2020*_
_*Mon – Fri: 7:00 am – 8:30 am IST*_
*Live on Zoom (NO PRE-RECORDED)*

*Investment:*
MRP : ₹ 7,999 + GST
*Diwali Offer Price: ₹ 3,999 + GST*
(Use promo code *DIWALI*, Limited Period Offer)

To know more about the course, click on the below mentioned link:

Power Query is an add-in for MS Excel. It is regarded among the most Powerful Data Tools and is used to boost the Business Intelligence (BI) in Excel by helping to manipulate data by identifying, simplifying and refining it. The data can be obtained from a wide variety of sources including relational, Web, Hadoop and structured data. It helps us to create and share queries and help a wide variety of users in a shared environment.

We can also connect data from multiple sources, pull data from data sources like XML and File folders. The sources of power query data are many and include Excel or CSV files, XML files, Web pages, folders, Sybase, Access database, MySQL database, and Sharepoint.

In this video, we can see how we can import multiple CSV files from a folder using Power Query in MS Excel.

Please give this video a Like and subscribe to our channel to Learn more on MS Excel. In the comments section, please share your thoughts and let us know about things that you wish us to cover in our forthcoming videos.

Connect with us on:
#excel #microsoftexcel #exceltutorial #learnexcel #shortcuts #importmultiple #powerquery

[nehabaradia]

Keep sharing such time saving videos and tips too

[nehabaradia]

Useful video.. saves a lot of time for my routine tasks.

[praveenkumar-gyke]

Thanks ExcelinExcel team for this Power query video.. amazing video 🤩..

[rajukhatri]

That's what you call step by step learning..#happyXLearning

[aravindhravichandran]

Absolutely amazing and helped me to accelerate my routine work efficiently.. expecting more vedios😃😀

[priyankagulecha]

It saves a lot of time for consolidating our branch reports too

[prasadsivaprakasam]

Well thought out video, with good explanations and spaced out well to give the viewer time to comprehend the subject.

[nazaarshadir]

I often have multiple csv files and need to bring them into 1 excel workbook but place each csv file on its own sheet. How may I do that? Thanks.

[andrewcaniglia]

This really helped me out, many thanks. Is there a way to make changes to the data in this new dataset and then export each file's new contents individually? Say there's the same errors in multiple files that I could change in this new dataset using find and replace, could I export the modified datasets as the files they originally came from?