 You're probably thinking, Chris, you're getting a little repetitive, because we're looking again at converting spreadsheet files, in this particular case, Microsoft spreadsheet files to CSV files in the shell. I've already done two videos on this, and I know some people are probably going to complain, but I just want to separate out these three different programs. First one we did was LibreOffice, then we did GenoMaric. Now we're going to look at a program I haven't tried yet, but it's in the repository, so we're going to go through the process of installing it and using it. Now converting spreadsheets to a plain text file such as CSV is very useful, so then you can script out, grabbing information from those files, and two other options. You probably have LibreOffice or GenoMaric installed in your system. Most people do, because you're going to have to work with spreadsheets at some point in a GUI environment, and that is a, you know, two common things that are installed. So I figure why install something when you already have something installed. But if you don't, or if you just want to go really lightweight, there is a command line only tool that's just for converting spreadsheets to CSV. So first of all, let me list out here, let me go ahead and remove from the previous tutorials the CSV file. Now, I'm going to do PseudoAppt, actually let's just do, I'm going to do aptitude search, that's just the package manager I'm using, use whatever package manager you prefer. See a program called xlsx2csv, hit enter, and there you go, you can see it's right there, you can see it converts these files to CSV format, that's all it does, and you can see I don't have it installed yet, otherwise this would be an I, and now I'm going to use PseudoAppt install and install this application, type in my super secret password, and there you go, I mean, additional disk space, 72.7 kilobytes, super duper small, so especially if you're going to want to run this on a server, this is definitely a way to go over the other formats, although the other programs can convert multiple formats into multiple other formats, and again you probably haven't installed, but if you're just looking to set something up just for doing this, this application is probably your best bet. And so now it's installed, you might also ask, just someone's going to ask why did I use aptitude and apt, I like the formatting when you're searching files that aptitude gives you, everything is all on one line and it's very easy to see whether it's installed or not, and then apt I just feel I like the progress bar it gives you when you're installing it, so I just use two different applications, but whatever package manager you prefer. Now that that's installed, I should be able to type in xlsx2csv, and I should be able to give it our file format here, of course we want to give it our spreadsheet file, and if I do that, let's see what happens, I type something wrong, yes change that, okay. It's saying this looks like a zip file, it's not supported, it looks like a zip file or officer later not supported, aha. So it's saying that the office file that I'm using, the spreadsheet file is too new of a format, so again I've never used this program, and so now we're learning something together. Let me go ahead and say gnumeric and actually let me use, no let's do gnumeric, gnumeric I'll give it that file, and I will say save as, and what formats are here, I'll give it a Microsoft Excel XP format, which doesn't have the x at the end, but let's see if it can do it here, now let's go ahead and try converting that file, there we go. This is nice because it gives us, look it put quotation marks around each of our fields, which could be nice depending on what you're going for, and also put it right to standard out. So with the other formats, files using LibreOffice or gnumeric, I don't know if there was a way to do standard out. So here we didn't create a new file, I mean we created a spreadsheet file, but if I have the spreadsheet file already, I can use this and I don't have to create a CSV file, I'm just outputting that, so then I can use fzf or grep, so I'll do this and I'll say jones and I'll do paula, there she is, and there's paula's information, like put that into cut, dash d comma dash f, let's get her birthday, which I believe is field seven. So now let's just do brown, Sarah, there we go, and I got Sarah's birthday. So that's super useful, but it doesn't have to go into a file, but if you wanted to put it into a file, you can just redirect it, I can just redirect it with a greater than symbol into people.csv, and now I can cat out that file, I can use grep whatever I want. Let's go ahead and look at the man page for this, and you see you do have some options here on how things work, formats, and I'm looking here real quick, cell separator character, default is going to be a C, so let's say I wanted to, so let's say one of these addresses had a comma in it, that's why the program puts quotation marks around this, and when it comes to converting other formats, that's useful, but if I just wanted to use the cut command, those commas could throw me off, so sorry, excuse me, I'm getting over being sick. If I wanted to, I should be able to, after reading that man file, C and give it this pipe character, no dash C, let's see, again I have not used this program, it says cell separated by default C, so you'd think it would be this, maybe let me try something like this, let's do period, okay that worked, it may just need to be a backslash pipe character, there we go, I like using the pipe character because that's not going to be in an address and most people are going to type that in there, so now I don't have to worry if there is a comma somewhere in one of those addresses, it's going to throw off my cut command, I can now do this and I can say cut with a delimiter of pipe, and I can say field again, seven if I want the birthday, and I have everyone's birthday, but of course I would want to grep before that or use fuzzy finder, Jones, Eric, and there's Eric Jones' birthday, so again that's the program we're looking at is XLS to CSV, and I believe there's another program that is up on GitHub, which is originally what I heard of that has XLSX to CSV, actually what I installed, what if I do this, does that work? Okay, no, there is an application, so this particular program that's in the repositories for Debian is going to be for older spreadsheet files, and if you're going to be doing this with just that format, this is a great option, it's super small, super lightweight, designed for the shell rather than being a GUI program that has a shell interface, again it was 70 some kilobytes, so super small, but very limited on the file formats it can work with, where Genumeric and LibreOffice both convert from and to many, many different formats, so it's just one of many options, but again people use spreadsheets of all the time, especially Microsoft Excel spreadsheets, and if they were smart they would use open documents spreadsheets, but all these office formats, which are useful if you're having fancy formatting, but if you just need the information to be able to convert to plain text and manipulate it that way is super duper useful, you can script out anything you want now, you can make your own GUI interface that uses the shell as the back end, and with this particular program you can pipe the standard out and go right into, you don't even need to create a CSV file separately. Anyway, I do thank you for watching, please visit filmsbychrist.com, that's Chris at the K, there is a link in the description, as always I thank you for watching, check out my Patreon page, and I hope that you have a great day.