Excel Data Processing Tool

Upload your Excel file and select the operations to perform.

Select Operations

Preview Results (Limited to avoid UI freezing)

Preview Results (Limited to avoid UI freezing)

Instructions

  1. Upload your Excel file using the file uploader
  2. Select one or more operations to perform
  3. Click "Process Excel File" button
  4. View the results in the preview table (limited to prevent UI freezing)
  5. Download the ZIP file containing all generated Excel files

Operations Description

  • count_daily_registers_by_source_name: Count daily registrations by source name (excluding 'direct')
  • count_daily_registers_by_ref: Count daily registrations by referral (for 'direct' source only)
  • count_users_by_source_name: Count unique users by source name (excluding 'direct')
  • count_users_by_ref: Count unique users by referral (for 'direct' source only)
  • count_users_each_sheet_by_source_name: Count users in each sheet by source name
  • count_users_each_sheet_by_ref: Count users in each sheet by referral
  • count_users_each_sheet_by_date: Count users in each sheet by date

Notes

  • If the UI appears to freeze, don't worry! The processing is still happening in the background.
  • All output files are saved in the 'output' folder even if the UI is unresponsive.
  • For very large Excel files, only a preview of the results will be shown to prevent UI freezing.