I have data files that are for some reason in .wav format. I was able to open them in audacity and want to export them to a csv or txt file. Any type of file that I can open in excel.
I followed the steps shown in the help section and I was able to export the data. The problem is that the values are not the same. Something isn’t right and I have no idea what to do. I tried setting up export to “dB” and also tried “linear”. What am I missing?
Any help would be appreciated!
Not the same as what?
With “linear” you should be getting floating-point values. With floating-point audio, positive and negative peaks of 1.0 represent 0dB (or “100%”, but floating-point can go over “100%”).
You could convert to 16 or 24-bit integer values in Excel by multiplying. With integer, 0dB is the highest (positive & negative) that you can “count to” with a given number of bits. 16-bit integers can go from −32,768 to 32,767 so you multiply by 32,767 to get the integer values.
…And I think you don’t get the full 32-bit floating-point resolution.