Excel macro to combine CSV files (Using Excel VBA)

preview_player
Показать описание
In this Excel automation tutorial, I will show you how we can write a macro (using Excel VBA) to combine multiple CSV files.

Imaging your boss asks you to combine 10 or 50 CSV files by the end of the day, and you only have couple hours left. If you are going to do this task manually, it will takes a few hours. However, if you can automate this task, then everything can be done in let's say 5 minutes.

Buy Me a Coffee? Your support is much appreciated!
----------------------------------------------------------------------------------------------------------------
Venmo: @Jie-Jenn

Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------

#ExcelVBA #MergeCSV #CombineCSV #ExcelAutomation
  1. Jie Jenn
Рекомендации по теме
Excel macro to 0:12:01

Excel macro to combine CSV files (Using Excel VBA)

Use This Trick 0:00:44

Use This Trick to Merge CSV Files Together Instantly

Combine multiple CSV 0:07:06

Combine multiple CSV / Excel files into one file

Excel VBA Automation 0:01:21

Excel VBA Automation : Combine Multiple CSV file data

Create A Macro 0:06:02

Create A Macro To Import Multiple CSV Files To Microsoft Access

How To Easily 0:20:08

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

Export Multiple CSV 0:01:10

Export Multiple CSV and Merge w Excel Macro

Import CSV file 0:01:38

Import CSV file in excel with macro simple steps

How to Merge 0:09:04

How to Merge Excel Files (Without Using VBA) - 4 Easy Ways

Automated Text Import 0:23:20

Automated Text Import in Excel with File Selection - The Easy Way - VBA

Import Multiple CSV 0:07:33

Import Multiple CSV Files with FileDialog in Excel VBA

How to Import 0:05:07

How to Import Multiple CSV Files into Separate Worksheets in the Same Workbook in Excel

Combine 120 CSV 0:02:11

Combine 120 CSV Files

How to Combine 0:03:16

How to Combine Multiple CSV Files into One Excel Workbook

Append CSV Files 0:02:13

Append CSV Files Into An Excel File With VBA / Macro

Convert Excel Files 0:10:28

Convert Excel Files To CSV Files Using Excel VBA (Excel Automation)

How To Merge 0:02:39

How To Merge Multiple CSV Files Into One Excel File？

Combine CSV Files 0:03:27

Combine CSV Files in Seconds with Command Line

Easiest way to 0:10:29

Easiest way to COMBINE Multiple Excel Files into ONE (Append data from Folder)

Create a Macro 0:32:09

Create a Macro To Spit a CSV File Into Multiple CSV Files with Excel VBA

Combine CSV files 0:03:49

Combine CSV files using Python

VBA to BROWSE 0:10:00

VBA to BROWSE & COPY Data from SELECTED File in Excel

Import Multiple CSV 0:01:32

Import Multiple CSV Files Into Separate Worksheets With VBA Code

Import CSV Data 0:01:39

Import CSV Data in to the Worksheet using Excel VBA

Комментарии
Автор

The line 1, xlNo isn't working correctly for me. Instead of removing duplicates, it removes everything after the first CSV that was imported. Any Idea why?

IcanCwhatUsay
Автор

Hi Jie, can you change the delimiter in VBA from, to ;?

markamadeus
Автор

Thanks Jie! I'm a beginner with Visual. My question is if I add additional CSV files to the folder, do I run the macro again to add the new CSV info? Will it duplicate the files I already merged into the Excel worksheet?

tj
Автор

Hi Jie, how can you use this macro but also have it add a column with the name of each CSV file you combined?

rachelhoams
Автор

Csv files not found comes out what should i do? Please help me

ochirgereltbyambasuren
Автор

Hey, why do i get Subscript out of range? Can you please help? on this

Set data_sheet =

namanjain