How To Calculate Fast Fourier Transform (FFT) Using Microsoft Excel

Microsoft help

what is Fast Fourier Transform

FFT or Fast Fourier Transform is the easiest way to distinguish the frequencies of multiple signals. The FFT method using Microsoft Excel can be effectively used to solve differential equations as well as for compressing audio, video and image files. The Data Analysis pack included in the Excel program can be used to create graphs demonstrating the frequencies of a signal. You can contact Microsoft help team for your clarifications regarding the Data Analysis. You have to enable this tool first as it is disabled by default.

Instructions to calculate FFT using Microsoft Excel:

  • First thing you need to perform is, enable the Data Analysis pack on your Microsoft Excel program. Select the Office button and then click on Options. Select Add-In from the list and mark Analysis ToolPack and hit Go button. Perform the same procedure in the next window as well.
  • Create a new spreadsheet file in Excel. Set the Column A with Time title and column B with Data, FFT frequency, FFT complex and FFT magnitude.
  • Now you need to enter the details of your sample signal into your data field and the sampling rate used.
  • You can determine the time at which each data point was selected in the time column by diving the time with the data points.

    Fast Fourier Transform

    calculate FFT using Microsoft Excel

  • Now navigate to the Data tab and choose Data Analysis. Now you should select Fourier Analysis from the list of options and press Ok to continue. Use the information in the data column as the input range and FFT complex as the Output column.
  • Now set the column F data from column A. With the equation “=(S/2)/ (N/2)”, create a new cell where S is the sampling rate and N is the number of samples.
  • Navigate to the first cell of the FTT Frequency column and enter the equation “=F2*SG$4,” which will drag the equation to halfway.
  • Now use the FTT Frequency column as the x-axis and FTT Magnitude column as the y-axis, to plot the graph for your input signal. This graph can be used to display the frequency peaks.

We hope you are clear with the instructions. Contact Microsoft help support team if the above method of calculating Fast Fourier transform didn’t work out for you. Thank you for visiting and have a good day!

One thought on “How To Calculate Fast Fourier Transform (FFT) Using Microsoft Excel

  1. Paulo

    I don’t know where this piece of drivel originated, but it’s been widely copied as a ‘how to do FFT with Excel’.

    It contains several mistakes
    “=F2*SG$4,” should of course be “=F2*$G$4,” tho the instructions forgot to say that you must put the equation in Cell G4.
    equation “=(S/2)/ (N/2)” ??? WHAT?? why not =S/N ??


Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>