 Hello, and welcome. You may be looking at the title of this video and say, Chris, didn't you just do a video about this the other day? Well, there is a slight difference in the title. Last time we used LibreOffice. Today we're going to be looking at doing the same thing, but with GNumeric. If you're not familiar, GNumeric is a lightweight spreadsheet type application. Last time we did LibreOffice, which is kind of a big and bulky. It's a full suite. If you're looking for something lighter weight, GNumeric would be an option. So here again, we have two spreadsheet files, one in open document spreadsheet and the other one's a Microsoft Excel file. And if you have GNumeric installed, GNumeric, if you don't use your package manager, sudo apt install or whatever package manager you use, but GNumeric and then we can give it the name of one of these files. We'll say people. We'll go with the Microsoft doesn't matter. They're both the same file. It's giving me a formatting issue just from because I converted it from LibreOffice. It was saying there's something wrong with file, but it's okay. So here is the file. Now in LibreOffice, you go to file and you go save as and then from the dropdown list, you can choose a CSV file, but you'll notice there's no CSV file as an option inside GNumeric. I'm not sure. GNumeric is what I'm going to call it. You would think there'd be some sort of export option in here. Maybe I don't know. No, it's not there. It's all the way over here under data, export data, which I think is a little odd, which is one of the main reasons I'm doing this video is because I had looked up where it was. I knew it had the functionality because pretty much every spreadsheet application does. But here you can go export as a CSV file. Again, that's a comma, separated value, but you can use whatever value you want. We'll save it as a people.csv. We'll click save. It doesn't give us the options that LibreOffice did as far as what you want to use as delimiter. We will go ahead and now close this window and now we should be able to cat out our people.csv. And here we go. This is it. Now you'll notice it does do it a little different than LibreOffice did. Where LibreOffice asked you for string, what's the word I'm looking for? Anyway, using quotations around the strings here, which it did for the address, I'm assuming one of these addresses probably have a comma in it. LibreOffice didn't put that in there. So that does make a little bit of a difference if you were like trying to cut through all this, but very little. So anyway, that is exporting from the GUI. But how do you do it from the shell using GNU Merit? Let's go ahead and remove our people.csv file. Once you have GNU Merit installed, it actually has a shell command called SSConvert. So once you have GNU Merit installed, SSConvert is installed and you can do that to convert. And all you have to do is SSConvert, the name of the file you want to convert. In this case, we'll use the open document spreadsheet and give it the output name that you want, people.csv. And not only is it quicker, not that LibreOffice was super slow, LibreOffice I think took at least a second, second and a half where this is like a half a second. So a bit faster. Like I said, GNU Merit is definitely a lighter weight application. The command is a lot shorter. You don't have to do LibreOffice dash dash headless dash dash convert dash to csv. This you just give it SSConvert, the file name and then the output. And I'm assuming it's looking at the extension here to know what to convert it to because I'm sure it probably does. Actually, I know it does because if you, first of all, let me show you that it did convert it just as the GUI did. But if you were to give it a format, let's say I just did that. Okay, it's going to give you an error. It doesn't know what a cs file is. So then you can use this command SSConvert dash dash list dash exporters. And it gives you a list here of all the different formats that it will convert to. You can convert to Microsoft spreadsheets. You can convert to HTML, LaTeX, and of course csv files. So a lot of different even PDF. So you can convert, I guess, any of these formats to any of these formats, which is super nice. But again, we're working with the csv files. And again, now we can do what we did last time. We can grep for something. We can grep for like, Jones from people.csv. And then I can look up again and say, Oh, I want to see Alice. There's Alice. And then I can use cut dash with a delimiter of a comma. And then we're going to go field four comma five comma six. And we have our address. And if we want to, we can even go field seven. There's Alice's birthday. So now we can again do that same thing. If you have a fuzzy finder installed, fzf, which is most likely in your repositories. If not, it's very easy to install from GitHub. And then we can just say cat people.csv into fzf. And now it gives us this. And now we have this real time list so I can do, you know, brown. And then I can go, Oh, I want Owen Brown. There he is. Or if it's not Owen, I can go up to Thomas Brown. And I'll hit enter. And I should get his birthday as the output. So that is using GNU Merrick from the shell and the GUI to convert to csv files or other formats as well, which makes again, super easy to then use grep and cut and awk and whatever tools you use to manipulate text to accomplish tasks. So I hope you found this useful. Please visit filmsbychris.com. That's Chris of the K. There's a link in the description of the video. Again, you can use this. You can use LibreOffice. This is a bit lighter weight, smaller program, runs a little bit faster, especially on lighter weight machines. Thank you for watching. Search through my videos there. Check out the links in the description of video. I'll put a link to the csv file so you can download it. And you can use it as an example. You can convert it to whatever format you want and play around with it. Also, the links in the description is my Patreon page, patreon.com forward slash mil X 1000. I would appreciate some support if you enjoy my videos. You can also do a one time support over at filmsbychris.com. Again, the link in the description under support. There's PayPal link. I do thank you for watching as always. I hope that you have a great day.