AUDACITY CONVERT TO .CSV FOR EXCEL
Solved
chrno
Posted messages
576
Status
Member
-
caipirinha Posted messages 1138 Registration date Status Member Last intervention -
caipirinha Posted messages 1138 Registration date Status Member Last intervention -
Hello,
I would like to know if there is a way to convert an audio file with Audacity to a .CSV file for Excel.
Thank you =)
I would like to know if there is a way to convert an audio file with Audacity to a .CSV file for Excel.
Thank you =)
Configuration: Processor: e8400 RAM: Corsair 4GO Motherboard: Maximus Formula Graphics card: 9800GX2 Case: Cosmos Power supply: M850 800w
8 answers
-
-
-
-
Hi,
CSV file = text file.
You cannot convert an audio file into a text file.
Tell us what you want to do and for what purpose?
See you! -
For a senior year SI project, the teacher told me to find a way to convert an audio file to CSV so that it can be read in Excel.
-
Good evening.
Excel is a spreadsheet. Rows, columns, numbers, and letters.
A csv file and a text file defining the ";" as the column separator.
An audio file means nothing. There are a plethora of formats.
But let’s imagine a simple mp3. What do you want to put in a table separated by ";"?
An mp3 is a basically binary file representing a series of numbers that represent a signal at a given time. Nothing that can be put in a table. Moreover, Excel is limited in rows and columns.
And then... what do you do with it? Excel has no tools to process sound. It is made to perform calculations in cells. At best, you retrieve an mp3 directly via a Media player defined in VBA, all in a graphical interface.
What is the purpose of the exercise? What is the goal? What are you studying?
--
In order: Notice - Google - Forum. And not the other way around.
90% of problems are due to what is between the keyboard and the chair.
Computer science and magic are two different subjects.
-
-
We are dealing with sound digitization and the teacher asks us to convert the sound file into CSV format in order to study the sound curve at different points.
-
Ah ok. So, draw a graph of what you have on the screen in Audacity.
It's already clearer.
Nevertheless, you will only be able to obtain a sample. The number of columns is limited in Excel and an mp3 (for example) is way too "large" in terms of data to fit into a spreadsheet.
--
In order: Notice - Google - Forum. And not the other way around.
90% of the problems are due to what is between the keyboard and the chair.
Computer science and magic are two different subjects.
-
-
Yes, I know, but how can I convert it since there is no export option to CSV in Audacity =S
-
I don't know.
The curves you see on Audacity are the pure and simple translation of what is in your audio file.
With the nuance that depending on the format, there is a specific file structure.
But it doesn't matter, let's take an mp3. And look (because it's not my job to do your homework) at how an mp3 file is structured and how to retrieve the purely musical part ('data' I presume)
This part is made up of binary data corresponding to a particular frequency for each time T, knowing that the amount of data per unit of time depends on the bitrate, which must be indicated at the beginning of the file.
Google, Wikipedia, etc., will surely help you.
--
In order: Notice - Google - Forum. And not the other way around.
90% of problems are due to what is between the keyboard and the chair.
Computer science and magic are two different subjects.
-
-
