E.T.L (Extract, Transform, Load) Software
A full-stack ETL application built for a private Spanish law firm that enables users to upload, validate, process, and manage Excel files through an intuitive web interface.
Problem
The client needed a centralized solution to simplify Excel-based data processing, reduce repetitive manual tasks, and provide an efficient way to manage uploaded files and export processed data.
Solution
Developed a full-stack application using Next.js, PostgreSQL, and Server Actions. Implemented secure file uploads, Excel parsing with SheetJS, database persistence, file management, CSV export, pagination, and a responsive interface optimized for desktop and mobile devices.
Highlights
- Excel upload and parsing with SheetJS
- Next.js Server Actions
- PostgreSQL integration
- CSV export
- Responsive design
- File management (upload, view, delete)