All work
Product Engineering/2020
CSV Extractor
Upload a CSV, see it as a queryable table
- Role
- Front-End Developer
- Year
- 2020
- Discipline
- Product Engineering
- Stack
- 7 technologies
A Next.js application that extracts data from an uploaded CSV file and visualises it as tables in the browser.
01The problem
CSV is where data goes to become unreadable. Opening one to answer a single question means a spreadsheet application and a lot of scrolling.
02The approach
A Next.js front end with Tailwind handling upload and table rendering, over Node/Express with Hasura and GraphQL against PostgreSQL, so extracted data is queryable rather than just displayed once.
03The outcome
Uploaded CSV data rendered as browsable tables in the application.
04Decisions worth noting
- 01
Extracted rows persisted through Hasura and PostgreSQL rather than held only in browser memory.