Web Microsoft 365 ◉ 24 views Dynamic Array

=IMPORTCSV()

IMPORTCSV function

Applies To: Excel for Microsoft 365

=IMPORTCSV(path, [skip_rows], [take_rows], [locale])

Hover argument names in the table for details.

Output typeText

Popularity15 / 100

VolatileNo

Dynamic ArrayYes

📥 Download sample .xlsx ▦ Try in Playground Dedicated file for this function — safe & lightweight · sample data + live formulas

⬇ Download Sample Workbook

A dedicated .xlsx for =IMPORTCSV() with Persian sample data & live formulas — open in Excel and practice.

📥 Download IMPORTCSV.xlsx ~ 8–12 KB · No macros

%d questions — syntax, example & errors — test yourself!

Start quiz →

Argument	Type	Required	Description
`path`	Number	Required	The local file path or URL of the CSV file you want to import.
`skip_rows`	Range	Required	A number that specifies how many rows to skip. A negative value skips rows from the end of the array.
`take_rows`	Range	Required	A number that specifies how many rows to return. A negative value takes rows from the end of the array.
`locale`	Date	Required	Determines regional formatting (e.g., date, number formats). By default, the OS locale is used.

▦ Data

Example 1 =IMPORTCSV("C:\Data\example.csv",,2)

Example 2 =IMPORTCSV("C:\Data\example.csv",1)

🔒 Your comment will be published after review.

Share your thoughts — visible after admin approval

No comments yet — be the first!