GUIDE · NIFTY OPTION DATA IN EXCEL · CATALOG VERIFIED 2026-11-11

NIFTY option data in Excel: download, filter and chart

To use NIFTY option data in Excel, download the files as CSV from your order page on Options Data (optionsdata.shop) and open one day or one expiry per sheet. NIFTY 1-minute option chains cover JAN 2023 → NOV 2026. A full day of every strike is a large sheet, so filter to the strikes you need before you open it, or use the steps below.

NIFTY option chain data Free sample Get free sample by email File schema

Get the free sample by email → check the columns

Dates on this page are read from the live file catalog, not typed by hand. Full matrix: /coverage.

Stay inside Excel's limits

Excel holds about a million rows per sheet. One trading day of one expiry fits easily; a month of every strike does not. Work per day or per strike.

Keep the timestamp column as text in ISO format (2026-09-10 09:15:00) so Excel does not reformat it.

Make a small CSV for one strike

If you are comfortable running three lines of Python, cut the data down before opening it:

import pandas as pd
df = pd.read_parquet("NIFTY_OPT_1min_2026-09-10_exp2026-09-15.parquet")
# older files use layout B names; map them to the sample names
df = df.rename(columns={"timestamp": "datetime", "strike": "strike_price",
                        "option_type": "right", "expiry": "expiry_date",
                        "oi": "open_interest"})
if "right" in df:
    df["right"] = df["right"].replace({"CE": "Call", "PE": "Put"})
df[(df["strike_price"] == 25000)].to_csv("NIFTY_25000_2026-09-15.csv", index=False)

An option chain table with formulas

Put strikes down column A and a time in cell B1. Then use MAXIFS to find the last bar at or before that time for each strike and side, and XLOOKUP to fetch its close. A PivotTable with strike in rows, call/put in columns and close as the value gives the same view for the last minute of the day.

Exactly which fields are in the files

Options files

Column (layout A · layout B)	Type	Meaning
datetime · timestamp	timestamp	Bar start time, IST wall-clock (e.g. 2026-09-10 09:15:00)
stock_code · —	string	Underlying code: NIFTY, or BSESEN for SENSEX
exchange_code · —	string	NFO (NSE F&O) or BFO (BSE F&O)
product_type · —	string	Options
expiry_date · expiry	string	Contract expiry (A: 15-SEP-2026, B: 2026-09-15)
strike_price · strike	number	Strike price
right · option_type	string	A: Call / Put, B: CE / PE
open / high / low / close	float	Traded premium OHLC within the bar
volume	int	Volume traded in the bar
open_interest · oi	int	Open interest at that bar

No Greeks or bid/ask.

Format: Parquet. Validate on the free sample and the schema page before buying.

FAQ

Can I download NIFTY option data as CSV for Excel?

Yes. Every file can be downloaded as CSV from your order page.

Will a full day open in Excel?

One day of one expiry opens fine. Many days at once can exceed Excel's row limit; split by day or strike.

Is there a sample to try in Excel?

Yes. The free sample converts to CSV with the two lines of pandas above.

Get the data

Free sample · Schema · Ask the AI for your data

NIFTY option chain data Free sample Get free sample by email