Save your data in a clean Excel file named xrd_data.xlsx . Put the
Excel is a common tool for manual data entry, cleaning, or merging, but it is not a native format for diffractometers. XRDML, an XML-based format developed by PANalytical, holds essential metadata (wavelength, sample details, instrument settings) along with intensity and angle data.
Below is a production-grade Python framework using pandas and xml.etree.ElementTree to achieve a clean conversion:
Open your Excel file and save the data sheet as a or Tab Delimited Text (.txt) file. Download and open the PowDLL Converter utility. Set your input format to Raw Text (X-Y) or CSV . Set your output format to Panalytical XRDML . Click Convert . convert excel to xrdml high quality
Your Excel file should have two columns:
"angle": "2theta", "intensity": "counts", "dspacing": "d", "sampleId": "sample/name", "timestamp": "measurement/dateTime"
If the software does not know your X-ray source wavelength, it cannot calculate accurate -spacings via Bragg's Law ( Save your data in a clean Excel file named xrd_data
Sort the 2θ column in strict ascending order. Micro-steps must be uniform (e.g., exactly 0.02-degree increments).
Dr. Aris knew that for his findings to be truly impactful, he needed to present them in a high-quality XRDML format, the industry standard for X-ray diffraction data. But how could he convert his intricate Excel data into a flawless XRDML file without losing any of the precious details?
) values after conversion to ensure the step size was correctly interpreted. How can I convert Excel file to XRDML file? - ResearchGate Below is a production-grade Python framework using pandas
: Ensure your intensity counts are written as plain integers or explicit floating-point decimals. Scientific notation ( 1.2e31.2 e 3 ) can crash older XRD analysis programs. If you need help formatting your data, tell me:
df = pd.read_excel('legacy_data.xlsx', header=None, names=['tt', 'intensity'])