Exporting measurements?

[jahamel]

Hi there,

I am using Audacity to measure the durations and rates of sounds. (A great many sounds.)
Right now, I am laboriously selecting each sound on the track and then typing the start and end points into an Excel spreadsheet.
Is there a function that will let me just copy and paste these measurements?
Boy, that would be *extremely* helpful.

Thanks

[kozikowski]

The numbers inside the time and duration panels don't cut and paste, do they? There's a feature request for the next Audacity.

Koz

[steve]

You could try using the "Silence Finder" from the Analysis menu in Audacity 1.3.x, and then exporting the resulting label track. This may or may not help you.

[jahamel]

Thanks - Silence Finder will not help me this time (too much wind noise, they are field recordings), but maybe in the future.

[waxcylinder]

Building on Steve's reply:

1) switch to Audacity 1.3.5
2) create al label for each track - find them by hand as you are doing now, as you point out the silence finder wil probably not hepl you
3) Use the File > Export Labels function
4) This will give you a text file (which on Windows you can open with Excel - don't know how or if this works on MACs)

There is still some typing involved (i.e. the labels) but probably less than you are doing now ....

WC

[jahamel]

Hi waxcylinder,

Thanks - this looks extremely helpful. One more question: Is there a way to set the export format to hh:mm:ss.000 (the same format that the time and duration panels use)? I do not see an easy way to do this, but maybe I am missing something...

Cheers,
Jen

[waxcylinder]

Jen,

no I don't see a way to do this either - the ouput is in seconds and that's it.

I can see a feature request coming from you ......

WC

[steve]

Since you are putting them into an Excel document, you could probably use a formula in Excel to convert from seconds into your desired format.