DEV Community

Jefri Bulo'
Jefri Bulo'

Posted on • Edited on

From Data to Insight: Turning Spreadsheets into Visual Understanding

DEV's Worldwide Show and Tell Challenge Submission 🎥

What I Built

I built a web-based tool that helps users understand their data by turning raw spreadsheet files into clear visual summaries.

The tool accepts data from both local Excel files and Google Sheets. Many people already have data stored in spreadsheets, but reading and interpreting that data is often harder than expected—especially for non-technical users. Rows and columns alone rarely tell a story.

This project focuses on solving that problem.

Instead of asking users to manually analyze tables or design charts from scratch, the application automatically processes the structure of the data and presents it through visualizations, tables, and concise summaries inside a web interface. The goal is to help users quickly grasp what their data is saying.

Users can upload or select their data, and the system will:

  • Analyze the data structure
  • Detect patterns such as numeric, categorical, and time-based fields
  • Map the data into appropriate visual representations
  • Present the results in a clean, easy-to-read web UI

The visual output stays live and updates automatically when the underlying data changes.

To support users from different regions, the interface also includes multi-language support. At the moment, several languages are available, with more planned as the system evolves.

This tool is designed for a broad range of users—from beginners who are new to data analysis, to business users and organizations that need fast insights without relying on complex BI tools.

Demo & Testing Access

The public web testing link is currently being configured and will be shared soon.

In the meantime, the pitch video below demonstrates the full workflow and core functionality of the application, including data ingestion, analysis, and visualization output.

My Pitch Video

Here is the link for the judges:
[https://sheets-analyzer.vercel.app/]

In this short pitch video, I demonstrate:

  • A raw dataset from Google Sheets
  • How the system analyzes the data structure
  • How the same dataset is transformed into multiple visual summaries
  • How users can immediately explore and understand their data

The Story Behind It

Many people store important information in Excel or Google Sheets, but understanding that data often requires experience with charts, formulas, or analytics tools.

The real challenge is not collecting data—it’s making sense of it.

I built this project to reduce that gap by making data interpretation more accessible. By automating visualization, summaries, and presentation—while supporting multiple languages—the tool helps users focus on understanding their data rather than struggling with technical barriers.

Technical Highlights

  • Data ingestion from Excel files and Google Sheets
  • Automatic schema detection (numeric, categorical, time-based columns)
  • Logic for mapping data structures to charts, tables, and summaries
  • Live, reactive visual output in a web-based UI
  • Multi-language interface support
  • Clear separation between data interpretation and visual rendering, making the system easier to extend in the future

Use of Mux (Additional Prize Category Participants Only)

Mux is used as the video infrastructure for this project’s pitch and demo presentation.

I uploaded the final edited pitch video to Mux and embedded it directly into this DEV submission. Mux provided reliable video hosting and playback, allowing the focus to remain on clearly communicating the project within the one-minute format required by the challenge.

❗ By submitting this project, I confirm that my video adheres to Mux's terms of service:
https://www.mux.com/terms

Top comments (0)