Exporting csv file

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.