Data preparation
Converts a table from a report, a spreadsheet or the PDF table extraction into the format used by the analysis tools: one row per sample, a Label column, text columns such as site or context, and one numeric column per oxide or element. Header rows, orientation, units, uncertainties and values below the detection limit are detected automatically and can be adjusted.
Source
Select a table
Excel, CSV or text. The workbook from PDF table extraction can be used directly.
Settings
Header rows
Rows at the top that contain column names.
Auto
Orientation
Values below the detection limit
Applies to entries such as n.d., b.d.l. and <0.05.
Iron
Automatic converts Fe2O3 to FeO (× 0.8998) when FeO is not reported. Ternary diagrams require FeO.
Result
Updates automaticallySelect a table, paste one, or open a result from PDF table extraction.
Columns Change the role or the output name of a column if the detection is not correct.
Preview
Continue with the prepared table: