14 - Combine CSV Files (or Text Files) in a Folder Using Power Query

[@nealehudson7350]

Wonderfully simple and clear guidance - thanks very much!

[@maheshpawar7169]

Thank you sir, I was struggling to combine data in to 1 excel for last 2 day and you resolved my issue within a minute, Thanks A lot

[@margad-erdeneboldbaatar4704]

Thanks so much for another great lesson.

[@GameReviewsMIX]

Very helpful video thank you!

[@zaheersamuel6128]

great stuff mate ..

[@RhiannonWild]

This was perfect! Do you know how many hours and hours of text file scouring this saved me!? Omg thankyou

[@silvestrecamposano6317]

Thank you for the knowledge gained...

[@akashdeshmukh116]

Hi Sir, Why we have not used the formula that we have use in previous video.?

[@meaningoflifewithkavi]

EvEN i HAD THE EXACT SAME DOUBT. i AM NOT SURE ABOUT THIS BUT CSV FILES ARE COMMA SEPARATED TEXT VALES WHICH MEANS THEY DONT HAVE THOSE OBJECTS EMBEDDED WHICH WE NEED TO SEPARATE IN CASE OF XLS SO WE CAN SIMPLY COMBINE IN CSV

[@ahmedehab6960]

Thanks a lot for the video. Do we have a limitation in the number of files to be combined?

[@nevado.]

Dear Trump, What is the difference if I filter the CSV files using a normal filter and if I filter the data using the Text filter. Would this be the same? if I add some files on the future, would, either way, affect the output data?

[@AshokKumar-qh5vc]

how can we add both xlsx and csv

[@alndr4u]

Make a video on incremental refresh on these csv files which are located in a folder 🙏🏻

[@pranaymaheshwari1555]

Hi Trump Excel I would like to thank you for this series of power query. I wanted to know why did you not use =Excel.Workbook([content]) for csv files as you did for the excel files.

[@mohitmanwani5298]

Hi Pranay he didn't use Formula bcz csv files doesn't have Objects like Excel..so we can combine directly without using custom column

[@study4734]

@pranay I was thinking the same.

[@nevado.]

Can Power query combine TSV files?

[@msiddi01]

Great video and very clearly explained. Can you also please show how to combine multiple .csv files so the files are combined side by side instead of adding rows at the bottom. What I mean is that if there are 4 .csv files, each with 4 columns and 100 rows the combined file will have 16 columns with 100 rows. Thanks in advance.

[@stevennye5075]

very useful!

[@yaxbhagdev5540]

Thanks for the video...just a one question. The problem of different table name will be there only in case of combining Excel files and not while combining CSV files is it? Any reason...is it just because in CSV we do not have table?..

[@ganesans3586]

if i have multiple csv files in a folder need to have access for only a few files, can we restrict

[@puspajitnayak]

if all the header present in 1st column the how to combine ??

[@tanveerabbas3271]

hello. then why is it different from combining xcel files with same steps?? plz let know

[@abdkabirsotannde]

Is it compulsory that all files to be combined have the same headings?

[@julianinbathayalan]

You did an additional steps "custom column" when you combined excel files but you had not done for csv files why?

[@richardborde170]

Its getting rid of the name column as well, when I combine. Is there anyway I could keep the name column mr. trumexcel sir?

[@asmitasubedi8215]

What can I do to combine CSV files by column and not by row? I want more than 300 files combined side by side. I would appreciate it if you could answer. Thanks!

[@minadev1]

So COMBINE function works on CSV file no matter if names are different for each sheet, but it does not work for EXCEL file if sheets name are different, am I correct?

[@datascientists0]

Sir I have 4 files containning 10 lacs rows and 6 Columns of data i have to cleaned and combined the data which is the best tool that i can use and analysised my data pls suggest Power Query Power BI Mysql Python Pandas pls suggest which is best tool to used to handle 40 lacs of rows data when i combined..

[@MissionHealth08]

Hi.. I am unable to load PDF data ..error ..file corrupt shows in screen

[@FromBrooklyn2024]

In East Data.csv, starting in row 210 to the end of the file, the date is wrong. It goes from 12/7/2018 to 13-07-2018. This generates an error in Power Query. Is this for a reason that is explained later on or is this a data error?

[@meaningoflifewithkavi]

Why could we combine binary for csv but for xls we had to go through the elaborate method

[@reanalytics1863]

Because excel files can hold different objects like tables, sheets, named ranges etc but csv files don't

[@parahiamin6765]

Rather than combine files that gives additional code a cleaner way is to add a custom column, name it "Tables" and write the custom formula "=Csv.Document([Content])" then expand this column.

[@hafizhaidari5691]

Hello to Every one, when I click on combine option it shows me error that is DATA from.error: the input couldn't be recognized as a valid excel document .

[@ettimehra]

I have applied the same steps but it's not working plz help me

[@imranali-iy5wk]

I have a folder containing 19 Excel worksheets with each worksheet containing 16 sheets inside it. While the name of the excel files are different, the name of individual sheets inside them is same i.e. they start from "Sheet 1" and go till "Sheet 16". What I have to do is append each sheet at the end of the next one and continue the same to get a new excel file containing only one sheet. (In other words, sheet 1 from file two (say, B) will be appended at the end of sheet 1 from file one (say, A) and sheet 1 from file three (say, C) will be appended at the end of the above two files containing sheet 1 from files A and B, respectively and so on untill every file is added).

[@minadev1]

You said you cannot COMBINE if the name is not consistence, while here names are not consistence?

[@prakashkafle454]

Works but spitted onto multiple row

[@skdaveskdave9798]

हिन्दी मे बताए

[@Alexis.Sanchez730]

***imp