Easily combine text or csv files
I am totally nerding out. I admit it. I had a folder full of text files, and I wanted to dump them all into a single Excel worksheet. It turns out there is a super-easy way to do this, provided you're willing to open up a command line and type in a few DOS commands!!
Here's where I found the instructions: https://www.rondebruin.nl/win/s3/win021.htm
In my case...
- I put the .log files (which are all really text files with a fancy extension) in a folder named "logs" on my desktop
- I clicked on the Windows Start button and typed cmd to open a command prompt
- My path showed that I was already in my user account.
- I typed cd desktop/logs to navigate to the "logs" folder on my desktop
- I typed copy *.log all.txt to copy ALL the .log files into a single text file titled "all.txt"
- Then I opened Excel, chose File->Open and navigated to the all.txt file
I am ridiculously excited about this trick!
Comments