I have CSV file and I can view it in excel. Here is example data:

**ID** **Product Name**   

75 dale-earnhardt-jr-adult-costume   

77 dale-earnhardt-jr-adult-costume-2  

79 plastic-jeweled-crown  

81 dollar-ring  

83 the-wizard-of-oz-shoe-covers-child  

1) I need to add '.html' at the end of product name like dollar-ring.html   

2) I want add new column with value 'custom\_permalink'

Output should be like:

**ID New Column Product Name**  

75 custom\_permalink dale-earnhardt-jr-adult-costume.html   

77 custom\_permalink dale-earnhardt-jr-adult-costume-2.html  

79 custom\_permalink plastic-jeweled-crown.html  

81 custom\_permalink dollar-ring.html  

83 custom\_permalink the-wizard-of-oz-shoe-covers-child.html  

I've 30K records and want to add this using some easy way of excel?