How to use the Windows command line (DOS).How to get to an MS-DOS prompt or Windows command line.Type dir to view the files in the folder and ensure all the files are there. Open the Windows command prompt and navigate to the folder containing the CSV files. For ease, place them in a folder in the root of the C: drive (e.g., c:\csvfiles). In the Save as type drop-down list, select CSV (comma delimited) (*.csv) from the list.ĭo this for each Excel file you want to merge, then place all the CSV files in the same folder. Open the Excel files and in the menu bar, click File, then Save As. To merge Microsoft Excel files together, it is best to save them as CSV files first. If there are multiple files you want to merge at once, you can select multiple files by holding down the Ctrl and selecting each file you want to merge.
