: Go to File > Save As and select Excel Workbook (.xlsx) to enable features like LAMBDA and advanced formatting. How to Download Global Earthquake Magnitude Data for Free

: In Excel, go to the Formulas tab and select Define Name .

: Enter a name (e.g., CALC_ENERGY ) and your LAMBDA formula in the "Refers to" box. Example Formula : To calculate seismic energy ( ) from magnitude ( ) using the formula : =LAMBDA(mag, 10^(4.8 + 1.5 * mag))

A "helpful feature" for analyzing this data in modern Excel is the function, which allows you to create custom, reusable formulas without using VBA. How to use LAMBDA with Earthquake Data

: Visit the USGS Search Catalog and set your parameters (date range, minimum magnitude, and geographic region). Select Output : Choose CSV as the output format.

: Open the downloaded CSV in Excel. Use Text to Columns under the Data tab if the data is not automatically separated into columns.

: In any cell, you can now simply type =CALC_ENERGY(A2) (assuming magnitude is in cell A2) to get the result. Steps to Download and Prepare Data