The exhibit room log arrives in Fahrenheit, while the site report uses Celsius. Keep the original readings next to the converted column so the next reviewer can check the import.
Label B1 Temperature (°F) and C1 Temperature (°C). Enter 77 in B2. In C2, enter =CONVERT(B2,"F","C"). The source unit comes first. Expect 25.

Example layout. Put units in the headings and keep the cells numeric.
Check the offset with two known readings
Try 32 and -40 in the same input column and fill the formula down. Expect 0 and -40 in Celsius. The freezing point helps catch a conversion that used a multiplier but omitted the offset. If a source cell includes the unit as text, extract the numeric reading before converting it.

Example checkpoints. Check the unit order and the temperature offset.
Keep missing readings visibly missing. Limit the filled range to recorded values or use an explicit blank check.



