Hi, I would like to take a JSON feed, convert it to CSV and save it to a designated FTP location every 24 hours. I know there are JSON to CSV converters online, but I would like to eliminate the ...

And that’s how we can manipulate XLS, JSON, and CSV files with csvkit. This tool might not be used very often, but when you need it, you’ll be happy it’s around.

The task of converting JSON to an Excel CSV file won’t take a long time. We suspect it can take less than a minute if you move fast enough and have the relevant knowledge.

Popular BI tools like Qlik and Tableau let people export certain data in CSV format. Microsoft’s Power BI app does, too. AWS launched QuickSight in 2015 and brought it out of preview in November.