Is there an easy way to copy-paste a channel lineup on PC into an Excel spreadsheet, so that I can do so with 2 different providers that I currently subscribe to, and compare active channels for each (Philo and YouTube TV)?
Why not just go into Rescan Channels, highlight and copy
then paste (Match Destination Formatting) into Excel
Just need to do some minor cleanup
1 Like
The whole purpose is to simply compare which service has which channels available with the package I have today, without a bunch of screwing around in Excel.
Is this the only way, or is there an accessible file somewhere that might make quick work of this, or a simple export of the data? Especially if the channel number could be separate from the other info.
1 Like
Not sure if this is exactly what you're looking for but this might help:
1 Like
This function is also included in OliveTin for Channels, which has been super helpful! I highly recommend for any CDVR enthusiast.
1 Like
You need to use the Excel Paste Option "Match Destination Formatting (M)"
If you use "Keep Source Formatting (K)", you get the result you're showing.
I prefer my Windows command file that lists them.
TVE all channels.cmd
SET "tab_char= "
echo Channel%tab_char%Name%tab_char%Available> "TVE all channels.txt"
curl http://192.168.1.4:8190/devices/TVE-Comcast_SSO/channels?all=true | jq --raw-output ".[] | \"\(.GuideNumber)\t\(.GuideName)\t\(.ScanResult)\"" >> "TVE all channels.txt"
EXIT
My Excel doesn't have that paste option. I'll try the command option. I can just open a command prompt and paste that in?
Hi, Jay. I don't completely understand how that helps. There seem to be a whole bunch of "check availability" options there that circumvent the intent.
Is someone in the community already keeping something like this up, so a user can actually see what service provides which options?
It doesn't show that Excel Paste Option unless you have the data copied to your Clipboard first.
No.
It needs to be copied/pasted into the windows command file TVE all channel.cmd and then run.
And you have to modify it for your IP, PORT and TVE DeviceID.
You also need to have curl and jq on your system.
To put this into perspective, how would a brand new Channels DVR user that finally wrapped their head around TVE view a thread like this? It seems quite complicated.
Most Channels users install and add their HDHR or sign in with their provider and…just use the app. Ya’ll cray 
2 Likes
You're the one that asked how to get it in Excel.
I told you how.
maddox totally solved it. Thanks a bunch.
lol fat fingers.
You did, thank you. I do appreciate that.
Just out of total curiosity, what's jq again?
jq is like sed for JSON data - you can use it to slice and filter and map and transform structured data with the same ease that sed, awk, grep and friends let you play with text.
I don't know what any of that means, but I'll brush up on it when I have a few hours this week. Thanks.