Survival analysis in Excel

Question

Hi,

I need to perform a Kaplan_Meier survival analysis in Excel. This test is supposed to be in the Data Analysis ToolPak, but it isn't. I couldn't figure out where can I download this addin and how to install it despite lots of searches online and in Excel help.

Any suggestions?

Thanks!

Answer 1

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link. 

Hello @Elad Chiel,  

Thank you for reaching out to the Q&A forum! 

After receiving your inquiry, I conducted thorough research and testing to provide you with accurate information: 

Excel does not natively support Kaplan-Meier survival analysis in its built-in Data Analysis ToolPak. 

Currently, Kaplan-Meier analysis in Excel can be achieved through three main approaches: 

Option 1: Install a Custom Add-in 

I found a video demonstrating how to download ExcelSurvival (GitHub), an open-source add-in (Survival-Analysis.xlam) that adds Kaplan-Meier functionality to Excel. 

The video link: Kaplan-Meier Survival Analysis in Excel 

However, this solution appears to be quite outdated (around 10 years old).  

Even after following the steps to download and enable the add-in, Kaplan-Meier did not appear in the interface, likely due to compatibility issues with modern Excel versions. 

For reference: GitHub - lukashalim/ExcelSurvival: Survival Analysis Add-in for Excel 

---

Option 2: Use a Paid Add-in 

I then explored another option, and I found this video: Kaplan Meier analysis in Excel - XLSTAT Tips 

I successfully installed the XLSTAT add-in, but the free version only provides basic features. 

To access Kaplan-Meier analysis and the full functionality shown in the video, you need the paid version. 

 You can find more details here: 

• Kaplan-Meier analysis | Statistical Software for Excel 
• XLSTAT | Statistical Software for Excel 

---

Option 3: Calculate and Plot Manually in Excel 

If paying for an add-in is not suitable for you, you can consider creating the Kaplan-Meier analysis manually in Excel. I understand this approach will take more time, but it seems to be the most practical solution at the moment. 

I researched this method, and here are some helpful articles you can refer to for step-by-step guidance: 

• How to Make a Kaplan-Meier Curve in Excel 
• How to Create a Survival Curve in Excel - Sheetaki 

Once again, thank you again for raising this issue; it’s helped broaden my understanding. I hope you understand that I want to help as much as I can within the scope of this forum.    

Looking forward to hearing from you! 

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. 

Answer 2

Hi Tina,

Thanks for your detailed reply!

I managed to create the survival curves, but what I need is to perform a statistical test to compare between several curves, which is not available in Excel (as mentioned in the link you sent in option 3).

So, I will do that in R or SPSS.

Thank you,

Elad