View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default how do I merge multiple csv files in one Excel file?

Copy all .csv files to a folder
Suppose you have copied that to c:\temp\

From command line within C:\Temp\ use COPY command as below to copy all to a
single file with a different extension...

COPY *.csv MyTest.txt/b

Open the newly create MyTest.txt in Excel and open as comma delimiter file....

If this post helps click Yes
---------------
Jacob Skaria


"Nedulous" wrote:

I have 200 csv files with data that I want to merge into one Excel file for
sorting purposes.