May 15, 2019 Mac (Old versions of Excel) Go to the Data tab and click on From Text and find the.csv file to open. Find the CSV-file you downloaded from WISEflow in your file system and click Get Data. This opens the Text Import Wizard. Make sure that File Origin is set to Unicode (UTF-8). What would make things easier is being able to merge a number of text files into one single file, this makes the files easier to handle, the data faster to read through and more efficient to search. This is especially useful for multiple logs or report files which could otherwise be spread across dozens or even hundreds of files.
![](/uploads/1/2/6/6/126654299/926266475.png)
Have you ever received a text file that contains a lot of data you'd like to analyze? Rather than copy-and-paste it, item by item, into your spreadsheet app, here's another solution. In my case, I wanted to look at Apple's downloaded application stats for iPhone Developers.
![Search multiple csv files for text machine Search multiple csv files for text machine](/uploads/1/2/6/6/126654299/926491256.png)
Unfortunately, there are in an ugly pure text format. To make them more useful, open then in TextEdit and convert them to CSV files. This is relatively easy to do:. Find a tab character in the file.
This isn't too hard to do, because that's how info is separated. Make sure it's only one tab and not two tabs.
Copy the character. (Alternatively you could open up any new document, type a tab character, and copy it.). Open Find and Replace (Command-F). For the Find value, paste the tab character. You must paste it, as typing Tab jumps to the next field. Set the Replace vale to a comma (,). Hit Replace All.
You'll see plenty of places where there are now multiple commas (especially with Daily reports). Ignore this; everything will be fine. I use Save As mostly as a precaution, but Save will work. All you need to do is change the extension to.csv for Comma Separated Value.
If no extension is showing, type it on you own. When prompted, say that you do want to use CSV as the format. Open the CSV file in Numbers or Excel, etc.
Not only is the layout nice, but you can now run math functions on the data, if that's your thing.Unfortunately, download stats files don't come like this, but it's only a few seconds per file. Also, you could potentially write an Automator/AppleScript solution to handle the work. robg adds: Excel is pretty good at parsing many pure text files, so you could also try asking Excel to simply open the downloaded file first, to see what you get.
![](/uploads/1/2/6/6/126654299/926266475.png)