Spreadsheet

This tool converts Excel (.xlsx) files into PDF documents, preserving tables, fonts, and basic formatting. Ideal for developers and office workers who need to automate report generation from spreadsheet data. Works entirely offline from the command line. Features Convert single or multiple Excel sheets to PDF Preserve cell formatting, borders, and text styles Set page orientation, margins, and scaling options Support for custom header and footer text Batch process entire folders of Excel files Usage python excel2pdf....

Fixes common date parsing issues when importing Excel files into databases or data pipelines. Ideal for data analysts and engineers who need clean, consistent date formats from spreadsheets with mixed or ambiguous date strings. Works with any Excel file (.xlsx, .xls) and outputs standardized ISO 8601 dates. Features Auto-detect and parse multiple date formats (e.g., ‘22/05/2026’, ‘05/22/2026’, ‘2026-05-22’) Handle timezone offsets and named timezones (e.g., ‘13:26 EDT’, ‘13:26 UTC-4’) Output to CSV or new Excel file with consistent datetime columns Configurable fallback for ambiguous dates (e....

A Python CLI tool that fetches data from published Google Sheets using only the sheet ID and API key. Ideal for analysts and developers who need to pull live spreadsheet data into local files without browser automation or OAuth. Features Fetch entire sheet or specific range by A1 notation Output to CSV, JSON, or Excel format Support for multiple sheets within one spreadsheet Automatic handling of pagination for large datasets Configurable via command-line arguments or config file Usage python gsheets_scraper....

This tool uses OCR and computer vision to detect and read form fields in a photo, then outputs the data to an Excel file. It’s for researchers, field workers, and office staff who need to digitize paper forms quickly. The key benefit is automating manual data entry from images. Features Extract text from form photos using Tesseract OCR Detect checkboxes and radio buttons via image processing Map extracted data to structured Excel columns Process multiple photos into a single consolidated Excel file Handle common form layouts like tables and labeled fields Usage photo_to_excel --input-form-photo survey_photo....

This tool processes Instagram data you’ve exported to JSON files and converts it into clean, structured Excel workbooks. It’s for analysts and marketers who need to analyze Instagram insights, posts, or audience data offline. The key benefit is turning messy JSON exports into ready-to-use Excel sheets with charts and tables. Features Parse Instagram JSON export files (posts, profile, insights) Generate separate Excel sheets for posts, followers, and engagement metrics Auto-calculate summary statistics (likes, comments, engagement rate) Create pivot tables and basic charts for visual analysis Export to XLSX with custom formatting and date filters Usage instagram_to_excel --input exported_data....

Reads a CSV of user signups and activity logs, then generates a formatted Excel workbook with a retention cohort matrix. For Python developers analyzing product usage without BI tools. Saves hours of manual spreadsheet work. Features Reads user signup dates and activity logs from CSV Calculates weekly or monthly retention percentages Generates a formatted Excel workbook with a cohort matrix Applies conditional formatting to highlight retention trends Exports a summary sheet with key metrics (e....

Transforms Excel spreadsheets into clean CSV files with customizable column selection and row filtering capabilities. Perfect for data analysts and developers who need to extract specific data subsets from large Excel files. Works offline without requiring Excel installation. Features Convert XLSX/XLS files to CSV format preserving data types Select specific columns by name or index position Filter rows using custom conditions and value matching Support for multiple worksheets within single Excel files Output to console or save filtered results to new CSV file Usage python excel_filter....

A Python tool for analysts and developers to combine Excel files for reporting. It merges data from multiple workbooks and sheets into a single, organized file, saving hours of manual copy-paste work. Features Merge multiple .xlsx and .xls files into one workbook Combine all sheets or select specific ones by name Preserve original formatting and data types Handle large datasets with efficient memory usage Command-line interface for batch processing Usage import excel_merger merged_df = excel_merger....