Advance Excel Analysis

Advance Excel Analysis is a Streamlit app for fast, practical Excel and CSV analysis. It helps users inspect datasets, compare files, clean data, filter records, and export results without writing code.

The app opens directly to the analysis workspace and does not require login.

Features

• Upload and analyze Excel and CSV files from the browser
• Compare files and identify common or missing records
• Filter, clean, and transform tabular data
• Generate summaries for numeric and grouped analysis
• Visualize data with charts and interactive plots
• Export processed results back to Excel or CSV
• Faster export and download flow with cached Excel generation for repeated exports

Use Cases

• Business reporting and spreadsheet review
• Data cleaning before analysis
• Comparing two sheets or files for mismatches
• Quick exploration of uploaded datasets
• Exporting filtered or summarized results for sharing

Run Locally

streamlit run main.py

Deploy on Streamlit Community Cloud

1. Push this project to a GitHub repository.
2. Open Streamlit Community Cloud.
3. Create a new app and select your repository.
4. Set the main file path to main.py.
5. In Advanced settings, choose Python 3.12.
6. Click Deploy.

Requirements

• Python 3.12 recommended for Streamlit Community Cloud
• Dependencies are listed in requirements.txt

Performance Note

• Excel export generation is optimized for faster repeated downloads
• Large files avoid unnecessary extra browser-side encoding to keep downloads responsive

Main Files

• main.py contains the Streamlit application
• requirements.txt contains Python dependencies
• .gitignore keeps local and build artifacts out of Git

Author

Developed by Md. Yusuf Ali