Hi all. I'm unable to import the CSV data from my spectra into excel. The formatting of the CSV seems very strange. Usually in a CSV each row is on a new line but the download I'm getting is all one line and I can't get it to import correctly into excel. Can anyone help? I've attached an image of my setting below. Thanks.
Hi, i believe the CSV is set up with a space character instead of a new line: https://spectralworkbench.org/spectrums/latest/251374.csv
If you do a find/replace of the file, you should be able to replace ' ' with a newline character (say, in TextEdit on a Mac, or even in Word) and save it again to open normally in Excel. Hope that works!
Reply to this comment...
Log in to comment