Have you had the following experience when combining a folder full of CSV files? Open a file, hit control A, hit control C, switch windows to the master file, find the point where you left off, hit control v, go back to the original file, close that file, select "no" when asked if you want to save the changes you made, locate the file in windows explorer, delete the file. Rinse and repeat for however many files you might have. Which could be up to 100 - or even more.
Does that sound like enough to make you insane? It is. However, it doesn't have to be that way. You can use the windows platform to merge a folder of CSV files more easily than you think! It's not complicated, and it can be done in a few easy steps. Just follow these instructions, and you'll be combining CSV files like a pro in no time!
A lot of people think that merging CSV files is going to be difficult or complicated because you have to access the RUN dialogue. But nothing could be further from the truth! It's actually incredibly simple. All you need to do is go to the start menu and choose run. Then type "cmd" into the dialogue box and hit enter. On the command line, type the command "copy" and then type the path where the CSV files you want to merge are located. Next type the path and filename where you want the merged file to appear. Hit enter, and windows will create a combined file! Easy as that.
|
For a video tutorial on how to merge CSV files, go to http://melaniedejonge.com/merge-files-and-combine-files-a-quick-way-to-combine-or-merge-csv-files. |

Published:2009/11/23
LONDON (Reuters) - British police investigating possible criminal behaviour in a parliamentary expense scandal said on Monday they had sent files on four legislators to prosecutors......
Published:2009/11/23
Scotland Yard detectives have passed files to prosecutors on MPs and peers facing criminal charges of fraud over their expenses claims.......
Published:2009/11/23
FOUR MPs and peers could face charges after cops hand files on expenses to CPS......
Published:2009/11/23
Scotland Yard said four files of evidence relating to members of the Commons and the Lords have been handed to officials at the Crown Prosecution Service.......
Published:2009/11/23
Scotland Yard detectives have referred four cases of potential fraud by parliamentarians to prosecutors. Four files of evidence were handed to officials at the Crown Prosecution Se......
Digg
|
Reddit
|
Mixx
|
del.icio.us
|
Stumble it! |