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