Question: CSV import to excel

by greenalastair | August 02, 2022 05:25 | #34818

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.

image description


Hi, i believe the CSV is set up with a space character instead of a new line:

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