Skip to main content

Research Repository

Advanced Search

Structure Analysis from Powder Diffraction Data: Rietveld Refinement in Excel

Evans, John S.O.; Radosavljevic Evans, Ivana

Structure Analysis from Powder Diffraction Data: Rietveld Refinement in Excel Thumbnail


Ivana Radosavljevic Evans



Powder diffraction is one of the most widely used analytical techniques for characterizing solid state materials. It can be used for phase or polymorph identification, quantitative analysis, cell parameter determination, or even full crystal structure analysis using the powerful Rietveld refinement method. As with much of modern crystallography, the software used for Rietveld refinement is frequently treated as a “black box” that produces often poorly understood outputs. This paper shows how it is possible for students to perform a full Rietveld refinement against experimental powder diffraction data from scratch using a simple spreadsheet like Excel. It starts by reviewing the basic ideas of least-squares fitting a straight line, develops these into fitting simple functions to peaks in simulated experimental data, and then combines these ideas with crystallographic equations to enable Rietveld refinement of the structure of an inorganic material (rutile, TiO2). At each stage, students can self-learn different fundamental aspects and pitfalls of data analysis that are widely reapplicable. The ideas can be taught as an online learning exercise or could be incorporated in a laboratory class where students collect and analyze their own experimental data.


Evans, J. S., & Radosavljevic Evans, I. (2021). Structure Analysis from Powder Diffraction Data: Rietveld Refinement in Excel. Journal of Chemical Education, 98(2), 495-505.

Journal Article Type Article
Online Publication Date Nov 25, 2020
Publication Date Feb 9, 2021
Deposit Date Jun 3, 2021
Publicly Available Date Nov 25, 2021
Journal Journal of Chemical Education
Print ISSN 0021-9584
Electronic ISSN 1938-1328
Publisher American Chemical Society
Peer Reviewed Peer Reviewed
Volume 98
Issue 2
Pages 495-505


Accepted Journal Article (921 Kb)

Copyright Statement
This document is the Accepted Manuscript version of a Published Work that appeared in final form in Journal of Chemical Education, copyright © American Chemical Society after peer review and technical editing by the publisher. To access the final edited and published work see

You might also like

Downloadable Citations