DEV Community

Cover image for CSV Viewer and Converter - Powered by Flask & Simple-DataTables JS
Sm0ke
Sm0ke

Posted on • Originally published at blog.appseed.us

CSV Viewer and Converter - Powered by Flask & Simple-DataTables JS

Hello Coders!

This article presents a simple Data Converter codebase powered by Flask and Simple-DataTables JS Library. This experimental project can be used to visualize CSV files using data tables, export in different formats, and edit the information using the console. The source code, published on Github under the MIT license, will be updated to support charts and other conversions (to PDF, to data frames.. etc).

Thanks for reading!


✨ Project Features

  • 👉 Minimal set up
  • 👉 CSV files upload / Visualization
  • 👉 Search, Pagination, Export to JSON, SQL, and Text
  • 👉 Edit (via console): Update/Remove/Add columns

New columns can be provisioned using data with different formats: Random Strings, Integers, and Timestamps (UNIX format).


Data Converter - CSV Load in Data Tables.


✨How to start the project

This tool can be compiled and started in any environment that has Python3 and GIT installed.

Step #1 - Clone the sources

$ git clone https://github.com/app-generator/devtool-data-converter.git
$ devtool-data-converter
Enter fullscreen mode Exit fullscreen mode

Step #2 - Install the dependencies

$ virtualenv env
$ source env/bin/activate
$ pip install -r requirements.txt
Enter fullscreen mode Exit fullscreen mode

Step #3 - Start the app

$ flask run 
Enter fullscreen mode Exit fullscreen mode

If all goes well, we should be able to visit the app in the browser and visualize the default CSV files shipped with the code (samples directory).


✨Helpers

The project comes with a few basic helpers for CSV data format:

  • csv_print() - print a CSV file to the console
  • csv_col_remove() - remove a column (by name)
  • csv_col_update() - update a column with generated data
  • csv_col_add() - add a new column (generated data)
  • csv_to_json() - CSV to JSON converter

Generated data is generated in different formats: random strings, random integers, and UNIX timestamps.


Print a CVS file

Data Converter - CSV Print


Delete Columns from a CSV file

Data Converter - CSV Delete Columns


CSV Add Content - New column provisioned with random integers

Data Converter - CSV Add Data


Thanks for reading! For more resources, feel free to access:


Top comments (0)