Skip to content

dgraversen/pi-tools

Folders and files

NameName
Last commit message
Last commit date

Latest commit

ย 

History

1 Commit
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 

Repository files navigation

Excel Analyzer Web App

A simple, browser-based Excel file analyzer that processes and analyzes Excel files entirely in your browser - no server required!

Features

  • ๐Ÿ“Š Upload Excel Files: Drag & drop or browse to upload .xlsx or .xls files
  • ๐Ÿ“ Multi-Sheet Support: Automatically detects and allows switching between multiple sheets
  • ๐Ÿ“ˆ Statistics: Calculates row/column counts, filled/empty cells, and data type analysis
  • ๐ŸŽจ Modern UI: Clean, responsive design with gradient styling
  • ๐Ÿ”’ Privacy: All processing happens in your browser - no data is uploaded anywhere

Usage

  1. Open index.html in a web browser
  2. Either:
    • Click "Load Sample File" to analyze the included migration-overviewSIMPLE.xlsx
    • Click "Choose File" or drag & drop your own Excel file
  3. View the analysis results and data preview

Customization

The app is designed to be easily extended with custom parsing rules. You can modify the analyzeSheet() and calculateStats() functions in index.html to add your specific analysis requirements.

Technical Details

  • Uses SheetJS (xlsx.js) library for Excel parsing
  • Pure HTML, CSS, and JavaScript - no build process required
  • Works in all modern browsers

About

Tool regarding PI and SAP

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published