Extracting data from a spectrometer to Excel

  • #1
14
0
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
 

Attachments

Answers and Replies

  • #2
DrClaude
Mentor
7,554
3,894
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.
 
  • Like
Likes FactChecker
  • #3
14
0
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
213053-66087f6d9d1c248bf3b4f8d358006f23.png

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
 

Attachments

  • #4
DrClaude
Mentor
7,554
3,894
You have to make sure that you are choosing the right file type when exporting from the spectroscopy software.
 
  • Like
Likes berkeman
  • #5
14
0
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.
 
Last edited:
  • #6
russ_watters
Mentor
20,249
6,831
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...
 
  • #7
rbelli1
Gold Member
988
377
The PK at the beginning strongly suggests it is a compressed file. Have you tried opening it with a compression software?

BoB
 
  • Like
Likes harborsparrow, Nik_2213, FactChecker and 1 other person
  • #8
russ_watters
Mentor
20,249
6,831
  • Like
Likes harborsparrow, rbelli1 and FactChecker

Related Threads on Extracting data from a spectrometer to Excel

Replies
20
Views
1K
Replies
5
Views
11K
Replies
10
Views
779
Replies
2
Views
4K
Replies
2
Views
2K
Replies
7
Views
634
Replies
8
Views
44K
Replies
9
Views
983
  • Last Post
Replies
2
Views
3K
Top