A simple copy-paste of data from Excel into a text file and renaming it .xrdml will likely fail. High-quality conversion means: Keeping scan parameters intact.
The following Python structure demonstrates how to parse the spreadsheet and assemble a valid XRDML hierarchy:
A newer, web-based platform developed by researchers at CVUT that allows users to batch-convert files like .xy directly into .xrdml for use in online diffraction calculations. convert excel to xrdml high quality
Use the "Save As" function to select the XRDML format.
By ensuring your XML tags match the schema definitions and properly mapping your metadata parameters, you can seamlessly bridge the gap between simple Excel utilities and advanced crystallographic analysis engines. If you want to tailor this process further, tell me: A simple copy-paste of data from Excel into
Several Python libraries can assist with this, such as xrdtools (which can read .xrdml files, but may have limited writing support) and fairmat_readers_xrd (which can read XRDML and other XRD formats).
: Typically set to 2Theta for standard powder diffraction. wavelength : The X-ray source wavelength (e.g., 1.5405981.540598 Å for Cu-K α1alpha sub 1 Use the "Save As" function to select the XRDML format
Column A must contain the independent variable (usually Angle 2θ in degrees). Column B must contain the dependent variable (Intensity in counts).
Before we discuss the how , we must address the why . A "low quality" XRDML file is worse than useless—it risks invalidating your phase identification.
High-quality XRDML formats do not explicitly write the 2-Theta value for every single data point. Instead, they optimize data density by defining a start position, an end position, and the number of steps. The intensities are then written as a continuous, space-delimited string. 2. Preparing and Formatting Your Excel Sheet