Skip to content

ohenriquesouza/csv_interpreter

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

16 Commits
 
 
 
 
 
 
 
 

Repository files navigation

πŸ“Š CSV Interpreter

Converts messy CSV files into clean, formatted Excel spreadsheets (.xlsx).


πŸ“Έ Example

Blur was applied to the images below to prevent data leakage.

Before β€” raw CSV, no formatting:

Raw CSV

After β€” processed and formatted spreadsheet:

Formatted Excel


πŸ–₯️ Desktop App (recommended)

Just run CSVInterpreter.exe β€” no Python or dependencies required.

CSV Interpreter UI

  1. Click Selecionar arquivo CSV and pick your file
  2. Pick a theme color β€” all spreadsheet colors (header, footer, text) are derived automatically from your choice
  3. Set how empty cells should appear in the output:
    • N/A β€” highlighted in red, italic grey text (default)
    • Vazio β€” blank cell, no formatting
    • Zero β€” fills with 0, no formatting
  4. Click Processar e salvar and choose the output folder
  5. Toggle πŸ”’ before processing to generate a protected (read-only) spreadsheet

Personalization

The theme system derives all spreadsheet colors from a single base color:

Element Derivation
Header fill The chosen color
Header text White or dark, based on luminance contrast
Footer fill 72% lighter tint of the base color
Footer text 45% darker shade of the base color

Image columns (detected by name or file extension) are automatically moved to the rightmost position so data always comes first.


🐍 Running from source

Requirements

Python 3.12+ is required. Install all dependencies with:

pip install -r requirements.txt
Package Version Purpose
pandas 2.2.3 CSV reading and data manipulation
openpyxl 3.1.5 Excel file generation and formatting
pillow 12.2.0 Icon conversion (build only)
pyinstaller 6.20.0 .exe packaging (build only)

tkinter is used for the GUI and comes built-in with Python on Windows β€” no install needed.

Run the GUI

python src/app.py

Run via CLI (batch mode)

Place CSV files in the data/ folder, then:

python src/main.py

Output files will be saved to the output/ folder.

About

CSV interpreter and spreadsheet generator with customizable styling, built to transform CSV data into organized and visually personalized spreadsheets with user-defined color themes.

Topics

Resources

Stars

Watchers

Forks

Contributors

Languages