CSV Upload Tool

April 10, 2020

Upload and match CSV data. Simple, but practical! Check out the project for yourself, here.

Background

This project was made for Artesian software, to be used in a more large scale project.

Usage

A user can upload a CSV file with any data, and then can match their “headers” (the columns) to the one’s anticipated by the app. With these pairings, the app then “reassigns” the user’s data with the new headings and saves it to a SQLite database.

Check out some screenshots below!

Upload data
Upload data

Upload success
Upload success

Upload failure
Upload failure

How it’s made

The project was made using React, Flask, and SQLite. I used Bootstrap to style the components.

Challenges

I struggled a decent amount to get SQLAlchemy to accept JSON data. Turns out they have a column type specifically for JSON. Consider this your friendly reminder to read the docs carefully!

Accomplishments

I think the user experience is really smooth, and the app is visually quite appealing!

Future

It’d be great to implement drag and drop.


Michael DeMarco

Written, designed, and programmed by Michael DeMarco an aspiring computer scientist completing his undergrad at the University of British Columbia (UBC) in Vancouver, BC.⚡🦅
See his thoughts in 140 characters 280 characters or less.

© Michael DeMarco 2022

Built with love, sweat, tears, oh and of course Gatsby.