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

Read More: How to Create Table from Another 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.

Read More: How to Make a Decision Table in Excel 


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.

Read More: How to Create a League Table in Excel 


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. 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


<< Go Back to Make a Table | Excel Table | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Zehad Rian Jim
Zehad Rian Jim

Zehad Rian Jim is a dedicated professional with a BSc. Degree in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. He's good with Microsoft Office and has written more than 80 helpful articles for ExcelDemy in the last year. Now, he makes fun and easy-to-follow Excel tutorials for YouTube as part of the ExcelDemy Video project. Zehad loves figuring out Excel problems, and his passion for learning new things in Excel shines through in... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo