Batch unit converter
Paste a column of numbers from a spreadsheet. Convert weight, length or temperature, then take the results back to your sheet.
One number per line, up to 200 numbers and 20,000 characters. Omit headers, unit labels and thousands separators. Select the decimal separator above.
Your numbers are processed only in this browser, not sent to a server, saved or included in shared links. Ads and existing visit statistics are separate.
Conversion results
Copying the results column preserves blank-line positions. Fix errors first. The full table and CSV include original line numbers and errors. Numbers use your chosen decimal separator; very small values may use scientific notation.
| Line | Input | Result | Error |
|---|
Using this with a spreadsheet
- Copy one numeric column without its header and paste it here.
- Choose the units and decimal separator, then convert. Use the line numbers to find errors.
- When all rows are valid, copy the results column beside your original data. Download CSV if you need the full record.
Prefer a formula in Excel?
Use this formula when your source value is in A1, then fill down. Depending on your Excel settings, replace argument commas with semicolons. Unit codes are case-sensitive.
=CONVERT(A1,"kg","lbm")Example: convert a kg column to lb
| kg | lb |
|---|---|
| 1 | 2.204623 |
| 10 | 22.046226 |
| 23 | 50.70632 |
Definitions and limits
1 lb = 0.45359237 kg and 1 in = 2.54 cm are exact definitions. Temperature conversion is for temperatures, not temperature differences. Results are rounded to your chosen precision. Inputs with absolute value above 10¹⁵, calculations outside the numeric range, and temperatures below absolute zero are rejected.
Official references
The page share link does not include your numbers.