--- title: "Import gym members from Excel or CSV | GymSetora" description: "Upload your member register from Excel or CSV: up to 10,000 members, columns matched automatically, Indian dates read, duplicates skipped, dues kept." url: https://www.gymsetora.com/features/excel-member-import updated: 2026-10-22 --- [Home](https://www.gymsetora.com/) › [Features](https://www.gymsetora.com/features) › Excel import Switch from Excel # Move your gym from Excel to GymSetora in one upload GymSetora imports your existing member list from Excel (.xlsx) or CSV — up to 10,000 members per file. Columns like name, phone, expiry date and dues are matched automatically, Indian dates such as 25/12/2026 are read correctly, duplicates are skipped and old dues come across as an opening balance, never as income. All plans [Start 14-day free trial](https://app.gymsetora.com/signup) [Ask on WhatsApp](https://wa.me/919328819265?text=Hi%2C%20I%27d%20like%20to%20know%20more%20about%20GymSetora) ## How it works 1. **Export your register** Save your Excel sheet or old software's export as .xlsx or .csv. 2. **Upload it** GymSetora matches the columns by name — “Mobile”, “Contact” and “Phone Number” all count as phone. 3. **Review the summary** See how many members were imported, which rows were duplicates and any row with an error, by row number. 4. **Start collecting** Members get sequential member IDs, with their expiry dates and old dues ready for renewal. ## Which columns does GymSetora read? - Name (or member name, client name). - Phone (or mobile, contact, phone number). - Email, gender and date of birth. - Expiry date (or end date, valid until, renewal date). - Join date (or start date, admission date). - Dues (or balance, pending amount, outstanding). ## Will importing mess up my accounts? No. Old dues come in as an opening balance on each member, not as payments, so your collection reports and cash drawer start clean. Rows with the same phone and name are imported once, and members already in GymSetora are skipped. Each import is all-or-nothing: if the file would take you past your plan's member limit, nothing is added and you are told why. ## Does it understand Indian date formats? Yes. Day-first dates like 25/12/2026, 25-12-2026 and 25.12.2026 are read correctly, as are Excel dates and ISO dates (2026-12-25). Switch from Excel at a glance | Files | Excel (.xlsx) or CSV, up to 5 MB | | --- | --- | | Size | Up to 10,000 members per file | | Columns | Name, phone, email, gender, date of birth, expiry, join date, dues | | Dates | DD/MM/YYYY, DD-MM-YYYY, DD.MM.YYYY, Excel and ISO dates | | Duplicates | Skipped, in the file and against existing members | | Dues | Opening balance, never counted as income | | Plans | Every plan, including Starter | ## Which plan includes it? - All plans Import your member list from Excel (.xlsx) or CSV — columns like phone, expiry date and dues are matched automatically - All plans Up to 10,000 members per file, and Indian dates such as 25/12/2026 are read correctly - All plans Duplicates are skipped, old dues come in as an opening balance (never as income), and an import that would pass your member limit adds nobody [Compare plans and prices](https://www.gymsetora.com/pricing) ## Switch from Excel: questions owners ask **How do I move my gym members from Excel to GymSetora?** Upload your member list to GymSetora as an Excel (.xlsx) or CSV file. Columns such as name, phone, expiry date and dues are matched automatically, and you get a summary of imported members, duplicates and any rows with errors. All plans **Will old pending fees come across?** Yes. A dues column is imported as each member's opening balance, so staff can collect it, but it is never counted as income in your reports. All plans **Is there a limit to how many members I can import?** One file can hold up to 10,000 members. The total still has to fit your plan's member limit; if a file would go over it, GymSetora imports nothing and tells you. All plans ## Related - [UPI fee collection for gyms, 0% commission](https://www.gymsetora.com/features/upi-fee-collection) Collect gym fees with a dynamic UPI QR for the exact amount. Members pay from GPay, PhonePe, Paytm or BHIM straight to your own UPI ID. 0% commission. - [Member app for gyms: QR pass, receipts, renewals](https://www.gymsetora.com/features/member-app) A member app with no app-store download: QR entry pass, plan and expiry, receipts, class booking, attendance history and UPI renewal for your gym members. - [Pricing: gym software plans from ₹999/month](https://www.gymsetora.com/pricing) GymSetora plans for Indian gyms: Starter ₹999, Growth ₹1,999, Pro ₹2,999 and Enterprise ₹5,999 a month, GST included. 14-day free trial, no card. Start today ## Bridge every gym to growth. Bring your member list from Excel, collect fees by UPI to your own account and let members check in with a QR. Try every self-serve plan free for 14 days. [Start 14-day free trial](https://app.gymsetora.com/signup) [Staff sign in](https://app.gymsetora.com/login) No card required · Prices include GST [Chat with us on WhatsApp](https://wa.me/919328819265?text=Hi%2C%20I%27d%20like%20to%20know%20more%20about%20GymSetora)