Getting a list of installed program in your windows to text file and arranging in google sheet as drop down list

Open command prompt then type 
wmic 
Now add this line to get installed program list , this will saved to D drive location with file name as Installedsoftwaelist.txt
then type
/output:D:\Installedsoftwaelist.txt product get name,version
This means that save a text file with Installedsoftwaelist.txt containing the data with program name and its version

Now open your google sheet from drive.google.com
I  created Sheet1 to get all assets of my office and also
created new sheet2 and paste data from text file to Sheetlist1 (i renamed Sheet2 to Sheetlist1)

to get the list of application installed in each computer can view simply by adding data validation , i will show you todo it
now create asset sheet like this

Now we have data in in Sheet2 as renamed to Sheetlist1

Now we want all list of program in one cell here it is V4 cell

select v4 cell and goto data menu ->data validation->

criteria is select
List from a range-> fill with the data as
Sheetlist1!A1:A25

press OK
 now you can see list of program as a droplist manner

Here you can see the sheetlist1 data in V4 cell as like droplist menu