Back to all tools
Home/Tools/Excel Tools
DBT OFFICE TOOLKIT

Excel tools
for roster work

Merge rosters from several sections into one file, drop duplicate rows and stray spaces, split names into title / first / last, catch mistyped student IDs, emails, phones and citizen IDs, then sort, reorder columns or split back into one file per section. Built for enrolment lists, application forms and event sign-ups.

  • XLSX · CSV · Paste from Excel
  • Processed in the browser
  • Files never leave your device
4chainable steps
CLEAN NAMES CHECK ORGANISE
STEP 1

Choose source files (pick several and they are merged)

    Files stay in this browser and are never uploaded.

    RESULT

    Choose files or paste data above to begin

      HOW TO USE

      How to use the Excel tools

      Four chainable steps: clean the file, split titles and names, validate the data, then sort and split by section.

      1. Bring in your rosterPick an Excel or CSV file, or several to merge into one, and check the preview table before going further.
      2. Clean it and split the namesRemove duplicate rows and stray spaces, then split "นาย สมชาย ใจดี" into title, first name and last name columns.
      3. Validate the dataIt checks student IDs, emails and phone numbers against the expected format and highlights the rows to fix.
      4. Organise and exportSort by any column, split into one file per section, then download as Excel or CSV.

      Tips

      • Format ID columns as text before saving or Excel will eat the leading zeros.
      • Merging files from several lecturers works in one go — matching headers are lined up automatically.
      • Work one step at a time and glance at the preview — mistakes show up before you export.