I’ll be demonstrating csvkit on Ubuntu Server 21.10. Let’s get it installed and see how it works. But what if you’re on a headless server and you need to work quickly? You don’t want to have to SCP the file to your desktop, load the file, save it in the requisite format, and then SCP the file back to the server. If you’re on a desktop, you could always open the file in your office suite of choice and do a Save As. If you’ve ever done any development work or deployed enough networked platforms (such as CMS tools), you’ve most likely run into a situation where you needed to upload data in CSV format. What csvkit can do is convert to and work with CSV. This handy app has saved me a few hours worth of work on a number of occasions. Since we have Linux available to us, you turn to a simple, open-source tool called csvkit. SEE: 40+ open source and Linux terms you need to know (TechRepublic Premium) And you might have a file that was created by another application (such as an app or service that generates JSON files) and you need that file converted to CSV format. But not every application can take care of that export. Even Google Docs allows for such an action with Sheets. Now, some applications make it possible to export a file to CSV format. It’s a flat file of data, each entry separated by a comma. You know what it is: Comma-Separated Value. Oracle Linux checklist: What to do after installation This Linux learning path will help you start using the OS like a proītop is a much-improved take on the Linux top command Open-source repository SourceHut to remove all cryptocurrency-related projects I might have a spreadsheet or JSON file with tons of data, but the system would only accept a CSV file. I can’t tell you how many times I’ve had to work to upload data to a new system (be it a CMS, CRM, HRM … you name it), only to find out the platform wouldn’t accept the file format I had available. When you don't have a GUI to take care of the task, Jack Wallen has the perfect command for the job. Sometimes you just need a quick means of converting a spreadsheet to a comma-separated values file. How to convert XLS and JSON files to CSV in Linux with csvkit
0 Comments
Leave a Reply. |