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

Рет қаралды 50,391

Күн бұрын

In this video, I will show you how to combine multiple CSV files from the folder and get the data in Excel using Power Query.
Since most of the time the database download format is CSV, this will allow you to create a query and combine all CSV files in a folder. Now, if you get new files in the future, you can easily update the data in Excel by refreshing the query
✅ Power Query Course Download files: bit.ly/power-query-download
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzfaq.info...
#Excel #PowerQuery #ExcelTips

Пікірлер: 39

@zaheersamuel6128 27 күн бұрын

great stuff mate ..

@nealehudson7350 Жыл бұрын

Wonderfully simple and clear guidance - thanks very much!

@maheshpawar7169 3 жыл бұрын

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 2 жыл бұрын

Thanks so much for another great lesson.

@GameReviewsMIX 2 жыл бұрын

Very helpful video thank you!

@RhiannonWild 3 жыл бұрын

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

@ahmedehab6960 2 жыл бұрын

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

@silvestrecamposano6317 2 ай бұрын

Thank you for the knowledge gained...

@stevennye5075 3 жыл бұрын

very useful!

@nevado. 4 жыл бұрын

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?

@msiddi01 2 жыл бұрын

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.

@alndr4u 3 жыл бұрын

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

@nevado. 4 жыл бұрын

Can Power query combine TSV files?

@akashdeshmukh116 4 жыл бұрын

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

@meaningoflifewithkavi 3 жыл бұрын

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

@abiodunsotannde 4 жыл бұрын

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

@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?..

@imranali-iy5wk 3 жыл бұрын

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).

@asmitasubedi8215 3 жыл бұрын

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!

@pranaymaheshwari1555 4 жыл бұрын

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 4 жыл бұрын

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 2 жыл бұрын

@pranay I was thinking the same.

@parahiamin6765 2 жыл бұрын

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.

@datascientistoflife8550 2 жыл бұрын

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..

@richardborde170 2 жыл бұрын

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

@FromBrooklyn2024 3 жыл бұрын

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?

@puspajitnayak Жыл бұрын

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

@julianinbathayalan 7 ай бұрын

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

@AshokKumar-qh5vc 4 ай бұрын

how can we add both xlsx and csv

@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?

@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 .