How to convert scientific measurement units across excel columns in one pass
- Step 1Upload your research dataset — Drop the .xlsx or .csv with columns using mixed or inconsistent measurement units.
- Step 2Define conversion rules per column — For each column: name, Multiply or Divide, factor (e.g. 0.000001 for nm to mm), and optional new column name.
- Step 3Download the converted dataset — All conversions applied in one pass. The summary shows how many cells were converted per rule.
Frequently asked questions
What factor do I use to convert nanometres to millimetres?+
Divide by 1,000,000 (or multiply by 0.000001). 1 nm = 0.000001 mm.
Can I round the converted values to a specific number of decimal places?+
The tool outputs full floating-point precision. Round within Excel using the ROUND() function after conversion, or set cell number format.
Does it work with scientific notation values (e.g. 1.23E-6)?+
Yes. JavaScript's parseFloat correctly reads scientific notation strings stored as text in cells.
Privacy first
Every JAD Excel tool runs entirely in your browser using SheetJS and ExcelJS. Your spreadsheets, formulas, and data never leave your device — verified by zero outbound network requests during processing.