3 simple steps

How It Works

Set up once in 2 minutes. Then screen any watchlist with a single click — results land directly in your Google Sheet.

1

Create your Google Sheet

Open a new (or existing) Google Sheet. In column A, put your NSE or BSE stock symbols — one symbol per row. That is all the setup required in the sheet itself.

  • ✓Use .NS suffix for NSE stocks (e.g. TCS.NS)
  • ✓Use .BO suffix for BSE stocks (e.g. 500325.BO)
  • ✓Any number of rows — no header required
  • ✓Blank rows are automatically skipped
My Watchlist — Google Sheets
A
1RELIANCE.NS
2TCS.NS
3INFY.NS
4HDFCBANK.NS
5TITAN.NS

Column A — stock symbols only

2

Share with our Service Account

To write results back into your sheet, our backend needs Editor access. Share the sheet with this email address:

screener@excelscreener.iam.gserviceaccount.com
  1. Open your Google Sheet
  2. Click the Share button (top-right)
  3. Paste the email address above into the "Add people" field
  4. Set role to Editor
  5. Uncheck "Notify people" (optional) and click Send

Share "My Watchlist"

screener@excelscreener.iam.gserviceaccount.com
RoleEditor
Send
3

Go to /screener and Run

Head to the screener page, paste your Google Sheet URL, enter your email for a results notification, and click Run.

  1. Visit excelscreener.in/screener
  2. Paste your full Google Sheet URL
  3. Enter your email address
  4. Click Run Screener
  5. Wait for results — they appear directly in your sheet

Run Screener

https://docs.google.com/spreadsheets/d/...
you@example.com
Run Screener →

What happens behind the scenes

Once you click Run, our pipeline processes each stock sequentially.

1

Detecting stocks in column A

~1 second

2

Fetching data from NSE / screener.in

15–30s per stock

3

Computing 40+ checks per stock

growth, debt, valuation, flags

4

Writing results back to your sheet

~2 seconds

5

Done — check your sheet!

Score, label, metrics, red flags

Frequently Asked Questions

How long does it take?+

Roughly 15–30 seconds per stock. A 10-stock watchlist takes about 3–5 minutes. If the data was cached recently (within 24 hours) it can be much faster.

What format should symbols be in?+

NSE-listed stocks use the .NS suffix (e.g. RELIANCE.NS, TCS.NS, BAJFINANCE.NS). BSE-listed stocks use the .BO suffix. Put one symbol per row in column A, starting from A1 or A2. We auto-skip blank rows.

What columns get written to my sheet?+

We add ~30 columns: Score (0–100), Label (STRONG BUY / BUY / WATCH / AVOID / SELL), Revenue 3Y/5Y growth, PAT 3Y/5Y growth, EPS trend, EBITDA margin, ROE, ROCE, D/E ratio, Interest Coverage, PEG ratio, P/E vs 5Y mean, Promoter holding and trend, FII/DII activity, Pledge %, OCF/PAT ratio, FCF, and any Red Flags detected.

Is my data safe?+

We only read column A of your sheet (the stock symbols). We never read any other data in your sheet, and we do not store your Sheet URL or email after the job completes. Results are written to new columns we add to the right of your data.

Ready to screen your watchlist?

It takes under 2 minutes to set up. No code, no exports, no manual work.

Screen My Stocks →