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

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.

Download Practice Workbook

You can download the practice workbook from here.

8 Easy Examples to Make a Conversion Table in Excel

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

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.

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

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.

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

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

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

Similar Readings

• How to Create a Table with Merged Cells in Excel (4 Easy Methods)
• Create a Table with Headers Using Excel VBA (2 Methods)
• How to Create a Table in Excel with Multiple Columns
• Make a Table in Excel with Lines (with Easy Steps)
• How to Create Excel Table with Row and Column Headers

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.

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

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

• Next, insert the following formula in the E11 cell.

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

Read More: How to Create a Table Without Data in Excel (2 Easy Methods)

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.

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

Read More: How to Create a Table with Existing Data in Excel

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.

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

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

Read More: How to Create Table from Data Model in Excel (With Easy Steps)

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.

Read More: Excel VBA to Create Table from Range (6 Examples)

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

• How to Make a School Time Table in Excel (with Easy Steps)
• How to Create a Descriptive Statistics Table in Excel
• Create a Table in Excel Based on Cell Value (4 Easy Methods)
• How to Make a Correlation Table in Excel (5 Handy Ways)
• Create a League Table in Excel (4 Easy Methods)
• How to Create a Sensitivity Table in Excel (2 Effective Ways)