App Version : V.5.0 Welcome Back: ()
School Management System

Download Excel Format



Download Excel Format

Note: Excel file ki headings niche diye gaye kisi bhi naam se milti-julti honi chahiye:
IDs: srn, sr no, admission_no, id, student_id, nic id
Personal: name, fname, father name, mother name, dob (DD-MM-YYYY), gender, blood group
Government: aadhar, jan adhar, pan no
Contact: mobile, alt mobile, email, address, city, pincode, state
School: class, section, medium, type, status
Health/Other: religion, caste, disability, bpl, rte, height, weight, tc no, percentage.



Download Excel Format

Excel Mein Dates Ko Fix Karne Ka Guide

Excel mein dates alag-alag formats (DD/MM/YYYY, MM/DD/YYYY, text format, ya numeric serials) mein hone ki wajah se Custom Formatting hamesha kaam nahi karti. Jab tak Excel ko yeh pata na chale ki cell ke andar ki value ek real date hai, tab tak format change nahi hota.

💡 Tip: Excel mein sabhi dates ko ek hi standard format (YYYY-MM-DD ya DD/MM/YYYY) mein badalne ke liye niche diye gaye tareeqon ka istemal karein:
Tareeqa 1: Text to Columns (Sabse Best & Fast Method)

Agar dates text format mein hain ya mix ho gayi hain, toh yeh sabse aasan tarika hai:

  1. Column Select Karein: Us poore column ko select kar lijiye jisme dates kharab aa rahi hain.
  2. Text to Columns par jayein: Upar menu mein Data tab par click karein aur Text to Columns par click karein.
  3. Ek chhota box khulega, usme Delimited par select karke Next dabayein.
  4. Agle step mein sabhi check boxes (Tab, Semicolon, Comma, etc.) ko uncheck karke Next dabayein.
  5. Last step mein Column data format ke andar Date wale option ko select karein aur dropdown se DMY (Day-Month-Year) ya jo format aapko chahiye woh select karke Finish kar dein.

✔ Ab aap us column ko normally koi bhi format de sakte hain, sabhi dates ek jaisi ho jayengi.

Tareeqa 2: Excel Functions ka Use Karein (DATEVALUE ya TEXT)

Agar aap formula lagana chahte hain, toh ek naya column banakar yeh formula use kar sakte hain:

  1. Agar Date Text format mein hai, toh formula lagayein: =DATEVALUE(A2)
    (Yahan A2 aapka original date cell hai).
  2. Iske baad formula wale column ko copy karke purane column par Paste as Values kar dein aur fir cells ko format kar lein.
Tareeqa 3: Excel Flash Fill (Magic Trick)

Excel khud-ba-khud pattern samajh kar dates theek kar deta hai:

  1. Apne data ke paas ek naya column banayein.
  2. Pehli row mein manually sahi format type kar dein (jaise agar cell mein 07/04/2026 ya 04-07-2026 hai, toh aap wahan manually 2026-04-07 likh dein).
  3. Doosri row mein bhi agli date ko manually sahi karke likhein.
  4. Ab keyboard par Ctrl + E press karein (ya Data tab mein Flash Fill par click karein). Excel baaki saari dates ko automatically usi format mein convert kar dega.
Tareeqa 4: Excel ki default Date Settings check karein

Kayi baar Excel file kisi doosre computer ya region (jaise US format MM/DD/YYYY) se bani hoti hai:

  1. Poore column ko select karein.
  2. Right-click karke Format Cells par jayein.
  3. Date category mein jayein aur Locale (Location) ko English (India) select karein. Isse aapko Indian standard formats mil jayenge.