How to Make a Conversion Table in Excel (8 Easy Examples)

Get FREE Advanced Excel Exercises with Solutions!

This tutorial will demonstrate how to make a conversion table in Excel. In our day-to-day life, we need to convert different units. Sometimes we need to convert meters into yards, sometimes we need pounds into grams or kg or sometimes we need the time conversion from minute to second or hour and vice versa. The table that contains most of these conversions is called Conversion Table. So, it is very important to learn how to make a conversion table in Excel.


How to Make a Conversion Table in Excel: 8 Easy Examples

We aim to learn how to make a conversion table in Excel. The Conversion Table is a table that contains most of the daily used conversions in one table. We’ll use a sample dataset overview as an example in Excel to understand easily. If you follow the steps correctly, you should learn how to make a conversion table in Excel on your own. The steps are

Dataset to Make a Conversion Table in Excel


1. Turning Celsius into Fahrenheit in Excel

Now, we aim to turn Celsius into Fahrenheit in Excel. We will use the CONVERT function in Excel for the conversion. The steps of this example are.

Steps:

  • First, insert the following formula in the E5 cell.
=CONVERT(B5,"C","F")

Inserting Formula to Make a Conversion Table in Excel

  • Then, after pressing the Enter button, you will get the result for this cell.

Final Result to Make a Conversion Table in Excel


2. Converting PSI into Pascal in Excel

Another important task is to convert PSI into Pascal in Excel. We will use the CONVERT function in Excel for the conversion. The steps of this example are.

Steps:

  • First, insert the following formula in the E6 cell.
=CONVERT(B6,"psi","Pa")

Inserting Formula to Make a Conversion Table in Excel

  • Finally, after pressing the Enter button, you will get the result for this cell.


3. Transformation of Litre into Cubic Meter in Excel

Next, we will try to transform Litre into Cubic Meter in Excel. We will use the CONVERT function in Excel for the conversion. The steps of this example are.

Steps:

  • To begin with, insert the following formula in the E7 cell.
=CONVERT(B7,"l","m^3")

Inserting Formula to Make a Conversion Table in Excel

  • Finally, after pressing the Enter button, you will get the result for this cell.


4. Turning Pound Mass into Gram in Excel

In this case, our goal is to turn Pound Mass into Grams in Excel. We will use the CONVERT function in Excel for the conversion. The steps of this example are.

Steps:

  • First, insert the following formula in the E8 cell.
=CONVERT(B8,"lbm","g")

Inserting Formula to Make a Conversion Table in Excel

  • Lastly, after pressing the Enter button, you will get the result for this cell.


Similar Readings


5. Converting Meter into Yard in Excel

Afterward, we can also convert Meter into Yard in Excel. We will use the CONVERT function in Excel for the conversion. The steps of this example are.

Steps:

  • First, insert the following formula in the E9 cell.
=CONVERT(B9,"m","yd")

Inserting Formula to Make a Conversion Table in Excel

  • Finally, after pressing the Enter button, you will get the result for this cell.


6. Transformation of Minutes into Seconds and Hours in Excel

In this scenario, we want to transform Minutes into Seconds and  Hours in Excel. We will use the CONVERT function in Excel for the conversion. The steps of this example are.

Steps:

  • To begin with, insert the following formula in the E10 cell.
=CONVERT(B10,"mn","sec")

Inserting Formula to Make a Conversion Table in Excel

  • In addition, after pressing the Enter button, you will get the result for this cell.

  • Next, insert the following formula in the E11 cell.
=CONVERT(B11,"mn","hr")

Inserting Formula to Make a Conversion Table in Excel

  • Finally, after pressing the Enter button, you will get the result for this cell.


7. Transformation of Meter Per Second into Mile Per Hour in Excel

Moreover, we want to transform Meter Per Second into Mile Per Hour in Excel. We will use the CONVERT function in Excel for the conversion. The steps of this example are.

Steps:

  • First, insert the following formula in the E12 cell.
=CONVERT(B12,"m/s","mph")

  • Secondly, after pressing the Enter button, you will get the result for this cell.

  • Thirdly, right-click on the data table and select the “Get Data from Table/Range” option.

  • Lastly, after that, you will get the result for this cell.


8. Turning Numbers into Percentages

Finally,  we want to transform Numbers into Percentages in Excel. We will use the CONVERT function in Excel for the conversion. The steps of this example are.

Steps:

  • First, arrange a dataset like the below image.

Arrange Dataset to Make a Conversion Table in Excel

  • Secondly, insert the following formula in the D5 cell.

Inserting Formula to Make a Conversion Table in Excel

  • Thirdly, after pressing the Enter button, you will get the result for this cell. Then, use Fill Handle to use the formula for all desired cells.

  • Lastly, you will get the result for all the cells.


How to Transform Range to Table and Vice Versa in Excel

Now, we want to transform Range into Table and vice versa in Excel. In our daily work, we need to convert the range to table and table to range a lot. So, it is very important to learn this method. The steps of this example are.

Steps:

  • First, arrange a dataset like the below image.

  • Second, right-click on the data table and select the “Get Data from Table/Range” option.

  • Third, check in the Create Table box, if all the cells are inserted or not. Then press OK.

  • Fourth, after pressing the Enter button, you will get the result for this cell.

  • Fifth, if you want to convert the Table form into the data range then first right-click on the table.

  • Sixth, select the Convert to Range option from the Table option.

  • Seventh, then the confirmation box will appear on the screen. Then press Yes.

  • Last, after pressing the Enter button, you will get the result for this cell.


Download Practice Workbook

You can download the practice workbook from here.


Conclusion

Henceforth, follow the above-described methods. Hopefully, these methods will help you to make a conversion table in Excel. We will be glad to know if you can execute the task in any other way. Follow the ExcelDemy website for more articles like this. Please feel free to add comments, suggestions, or questions in the section below if you have any confusion or face any problems. We will try our best to solve the problem or work with your suggestions.


Related Articles

Zehad Rian Jim
Zehad Rian Jim

Hi there! I am Zehad Rian Jim. I graduated with a bachelor's degree in engineering from BUET. Currently, I am working as a technical content writer at ExcelDemy. You will find all my articles on Microsoft Excel on this site. Outside of the workplace, my hobbies and interests include watching movies, tv series, and meeting new people. I also enjoy sports. My favorite sports are Cricket (to watch and play) and Badminton (play).

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo