Well, what do you know, I fixed the issue!
The page that shows your output is just showing the data in a browser container, so doing “view source” in your browser shows the actual CSV/TSV/XML data in that window, which I then did the following with:
1. Show Source
2. Copy and paste source into text editor
3. Save file as something.csv
4. run “sort something.csv | uniq > something_else.csv”
5. Import into spreadsheet, and it works!
The sort is to get all blank lines in a group, and then uniq removes all non-unique data lines from the file, mine had about as many blank lines as data lines.
Hope this helps everyone.
Ross
