One of the most frustrating things I have ever done is to get the CVAR (commands) for Steam games on a tidy list. Sure you can just go to the console and type "cvarlist" and copy the text, it sometimes drops half of the list off, among other errors and it look crap on a web page. On your local PC it also registers some values as the default ... like video card settings, anything you have in config files...it ends up too dirty.

So using a game server without any mods, a server.cfg with just a rcon password in it and a host name... You can make a clean one quick, well...after a learning curve! The below requires you have a SRCDS server and know how to use spreadsheets, I never said it was easy, it is accurate and quick.

Make an accurate CVAR list and display on a web page.

1. Only use a SRCDS server. Your client files will be full of your steam and game preferences. (Update: in some newer Source games past 2012 you can do this OK from the game console.

Go to Step 4 now if doing this on games like CS:GO or younger like my example using Military Conflict: Vietnam.)

 
2. Update the server (if using SRCDS or a dedicated game server)

3. Now take out all the items in the server.cfg and leave the host name and rcon password. (just in case it will alter some defaults)

4. Connect via HLSW (or your game using console for newer source games) and place "cvarlist log cvarlist.csv" in the console (using the "~" key)...

5. Go to the game server directory "orangebox\<your game foilder>" like "tf" or "dod" or "cs" and download a file called "cvarlist.csv" in my case it was in my local game folder... "C:\Program Files (x86)\Steam\steamapps\common\Military Conflict - Vietnam\vietnam"

6. To view a .csv file you have to have at least a speedsheet viewer. I advise you use open office CALC instead of MS excel, it is better (in 2012) at making a single HTML file for web site use, newer versions of MS Excel work OK too.

7. Open with CALC or Excel and if the text import screen comes up (in CALC) make sure the "Separator Options" has "Comma" box ticked, press OK.

8. It has all the data there but way too many columns of the CVAR type.

9. Find the last column that hasn't any data in it, ("U" in games like DoD:Source or Counter-Strike Source but that changes game to game and Military Conflict: Vietnam was "Y" ), just after the "Description" or "Help Text" column, place a formula to grab the data from the other columns and combine them in the spare one. I'll use up to Column Y in my example to grab the data from cells "C" to "W" that are the CVAR types.

Note you don't want the "Description" or "Help Text" column values, just the CVAR type values.

The formula looks like this you paste it in the spare cell like "Y"...

=C7&" "&D7&" "&E7&" "&F7&" "&G7&" "&H7&" "&I7&" "&J7&" "&K7&" "&L7&" "&M7&" "&N7&" "&O7&" "&P7&" "&Q7&" "&R7&" "&S7&" "&T7&" "&U7&" "&V7&" "&W7&""

Make sure when you paste that in, press enter and don't click with the mouse!

Clicking with the mouse will select a cell.

Now you can do a "Paste special" on the other cells. Copy the "Y" cell, highlight all the other cells, Right click and unclick the Paste all. Only select "Formulas" and press OK.

 

10. Make a new column beside the "Value" (column B). Select the "C" column right click and "Insert Columns".

 

11. You will notice the spare column has moved, it is now the next letter "T", copy that column.

12. Select column C and right click paste special but ONLY have the "Text" selected.

13. Delete columns that were the cvar types and your special spare column, should be "D" to "W" in my Military Conflict_ Vietnam example and column "Y" but the point is to end up with columns named "Name" in column "A" and "Value" in column "B" with no name yet in column "C" and "Help Text" or "Description" in column "D".

14. Now you should have 4 columns. "Name", "Value", your combined cvar types, (call the column "Cvar types") and the "Help Text".

 

The next bit is how to make that an HTML page.

Just save it as an HTML page, open it, fool around with the background, cell boarders, fonts until you are happy. Upload to your website.