RFM Analysis Application for Microsoft Excel. RFM for Excel allows you to perform RFM Analysis of your customer data with a click of a button in Excel. RFM for Excel is automated excel application which converts your data into RFM groups / segments and assigns RFM scores for each of your customers. RFM for Excel requires the following customer information: customer name, last purchase date, number of purchases made by each customer, and the amount spent by each customer. Once you enter / update your customer information with a click of a button RFM for Excel creates RFM analysis and filter options so you can easily see all RFM groups / segments or filter the RFM groups you want to analyze and work with.