+ Reply to Thread
Results 1 to 4 of 4

Viewing sound waves in excel?

  1. #1
    Registered User
    Join Date
    02-17-2015
    Location
    Philippines
    MS-Off Ver
    2007
    Posts
    89

    Viewing sound waves in excel?

    Hi

    Is there a way to view and log times from sound waves?!
    For example.. Let's say I watch a video on YouTube of a dog barking, I'd like to start recording or live monitor the video for audio and log timings of the barks

    Is it possible?!

    Thanks

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Viewing sound waves in excel?

    You would need some other applications to first extract the audio track, then convert the audio track of the video into data. Excel cannot do any of that.

    First you have to extract the audio. There are free web sites that allow you to convert YouTube videos to MP3 files. This may violate YouTube user agreements so I am not going to provide links here.

    Once you have an audio file you can use a tool like Audacity, which is a free audio editor. It shows you a volume trace over time that would allow you to see timing of audio events graphically.

    If you need to do further analysis of those events you can enter them into Excel by hand. I do not know if Audacity, or any other tool, provides an export to some other data format that can be used by Excel.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    02-17-2015
    Location
    Philippines
    MS-Off Ver
    2007
    Posts
    89

    Re: Viewing sound waves in excel?

    Thanks Jeff ive looked at many programs like Audacity which I could indeed use to record audio and then take timings, but it wont automatically log them into excel 'live' which is ultimately what id hoped for.

    thanks for the reply

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Viewing sound waves in excel?

    You may find this helpful. Audacity can export to CSV, which can be read by Excel:

    http://manual.audacityteam.org/man/s...ta_export.html

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Read a Row and catch the maximum and minimum points
    By ropbasuel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-27-2014, 09:42 PM
  2. Greetings fellow waves
    By Surfboard in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 05-14-2013, 09:23 AM
  3. [SOLVED] Help with a formula to help count # of Waves in Progress, # Completed
    By karryan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-27-2013, 04:56 PM
  4. *Waves Hello*
    By spoonedmango in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 11-15-2012, 09:05 AM
  5. Play Sound in Excel
    By nguyennb in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-14-2009, 04:19 AM
  6. using sound in excel
    By vxhybrid in forum Excel General
    Replies: 6
    Last Post: 09-14-2008, 08:57 PM
  7. How to add sound to excel
    By robert111 in forum Excel General
    Replies: 4
    Last Post: 04-29-2008, 09:11 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1