LabelCroppers

GSTR for CA portal

How to Import Your GST Client List From Excel Into the GSTR for CA Portal

Updated 27 October 2026 · 3 min read · By the LabelCroppers team

Most practices already have their clients in an Excel sheet – sometimes several sheets kept by different people. Retyping them is slow and error-prone. The portal's import takes your sheet as it is, checks every GSTIN, skips duplicates and tells you exactly which rows need fixing.

Step 1: Download the template

Go to Clients → Import and click Download template. The template has these columns: Legal name, Trade name, GSTIN, Scheme (Monthly / QRMP / Composition), Group, Contact person, Phone, WhatsApp, Email, Address, Fee (Rs) and Fee cycle (Monthly / Quarterly / Yearly). Only the legal name and GSTIN are required.

Step 2: Copy your data in

Paste your existing columns under the matching headings. You do not have to use every column. The importer also recognises common alternative headings – "Name" or "Client" for the legal name, "GST No" for GSTIN, "Mobile" for phone, "Category" for group – so a sheet with slightly different headings usually works without changes.

  • Write the scheme as Monthly, QRMP or Composition. Anything else is treated as Monthly.
  • Put the fee as a plain number, for example 1500.
  • Leave WhatsApp empty if it is the same as the phone number.
  • Save as .xlsx or .csv.

Step 3: Upload and review

Drop the file on the import box. The portal reads it in your browser and shows how many rows it found and how many have an invalid GSTIN. GSTINs are checked for the correct 15-character format and check digit – the same check the GST system uses – so typing mistakes are caught before they reach any return.

Step 4: Import

Click Import. Clients with valid details are added; rows are skipped if the GSTIN is invalid, the name is missing or the GSTIN is already in your list. The result lists each skipped row with its row number and reason, so you can correct those rows and import them again. Invalid email addresses are simply left blank rather than blocking the client.

Common GSTIN errors and how to fix them

  • Letter O instead of zero (or I instead of 1) – the most common typing mistake. Check the PAN part against the client's PAN card.
  • Missing or extra character – a GSTIN is always 15 characters.
  • Spaces – removed automatically.
  • Wrong check digit – the 15th character is calculated from the first 14; if it does not match, one of the other characters is wrong. Search the GSTIN on the GST portal to confirm.

More on the structure in our GSTIN format guide.

After importing

Open each client to add anything not in your sheet – the GST portal username, the date the client joined your practice (so older periods are not flagged as overdue) and notes. Set the professional fee if you want to use "Raise monthly fees". Then open the Compliance tracker for the current period and start marking statuses.

Exporting back to Excel

Clients → Export downloads the full list with state, PAN, scheme, group, contacts, the current period's GSTR-1 and GSTR-3B status, fee and outstanding fees – handy for audits, partners and staff. Firm settings → Backup downloads everything as a JSON file.

Frequently asked questions

How many clients can I import at once?

Up to 1,000 rows per file, and up to 1,000 clients per account.

Will importing the same file twice create duplicates?

No. A GSTIN already in your list is skipped.

Can I import from Tally or other software?

Export the party or client list to Excel from that software, then map the columns to the template headings.

Is my file uploaded?

The file is read in your browser; only the client details are sent to your account when you click Import.

Try the GSTR for CA portal – freeClients, filing tracker, due dates, GSTR-1 and fees in one place.
Open the tool