Export Triton Results as CSV

djbetterly · Mar 18, 2015

Has anyone figured out how to import the results into excel? The file downloads fine, but I can't figure out how to import the results into a legible form in excel. If there are any excel wizards out there I'd love to do this so I can keep it in my log.

Thanks!

Sangheili · Mar 18, 2015

You will need to use the Text to Columns feature in Excel. Google it and play around.

I dont have exact directions as I only tried this once when I wanted to format the data for something.

djbetterly · Mar 18, 2015

That does make sense, but the problem with text to columns is, the data is already in columns. I've attached a snipit of what it looks like in excel.

Sangheili · Mar 19, 2015

You can transpose it to rows if you'd like. Copy it, select a cell below, and hit the little dropdown arrow next to the Paste button, select Transpose.

You may need to use the Text to Columns twice to split it more. Or a better option may be to find some fancy formulas that can pull out each consecutive values after the delimiters.