Extracting data from a spectrometer to Excel

[Hayool]

Good morning,

I used the Laser beam with HR4000 spectrometer with Ocean View software when saving the files it is saved by (.ocv) format. when trying to extract information to excel I get some unreadable data like (bkg thin sheet gel.png) attached. I used the same instrument and software with the yellow light but used solution of the mix not gelatine sheets, and i was able to convert it using excel but with the laser and gelatine sheet this is what I got I could not convert it.
This is the link i used to convert the data

Please help.
Thanks

 

[DrClaude]

Just a guess, but .ocv sounds like "Ocean View," so it might be a proprietary file format from the company. To import into Excel, it has to be ASCII data, like the .csv (Comma Separated Values) mentioned in the link.

 

[Hayool]

Just a guess, but .ocv sounds like "Ocean View," so it might be a proprietary file format from the company. To import into Excel, it has to be ASCII data, like the .csv (Comma Separated Values) mentioned in the link.

Hi Drclaude.
When I used the yellow light I was able to convert it to from .ocv format to excel from this link
https://www.chem.utoronto.ca/coursenotes/CHM317/pdfs/Import Spectrum to Excel.pdf
but when I used the laser beam I got this

So, I am confused why I was able to have the data when I used the yellow light but could not when using the laser beam

 

[DrClaude]

You have to make sure that you are choosing the right file type when exporting from the spectroscopy software.

 

[Hayool]

You have to make sure that you are choosing the right file type when exporting from the spectroscopy software.

In the spectroscopy software I only have one option of(.ocv) format nothing else.

 

[russ_watters]

In the spectroscopy software I only have one option of(.ocv) format nothing else.

If it worked for one it should work for the other - it's the same software, right? OceanView? On page 44 of the manual it has a picture of the dialog box, with "ascii" selected...

 

[rbelli1]

The PK at the beginning strongly suggests it is a compressed file. Have you tried opening it with a compression software?

BoB

 

[russ_watters]

The PK at the beginning strongly suggests it is a compressed file. Have you tried opening it with a compression software?

BoB

Good catch! (I can't even read the screenshot!) That's the header for zip files; the initials of the inventor.
https://en.wikipedia.org/wiki/Zip_(file_format)#History