IMPORTCSV

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

Returns the contents from a CSV file displayed as a dynamic array.

path	The local file path or URL of the CSV file you want to import.
skip_rows	(Optional) A number that specifies how many rows to skip.
take_rows	(Optional) A number that specifies how many rows to return.
locale	(Optional) Determines regional formatting (date, number formats).

REMARKS

* This function was added in Microsoft 365 (version 2502, first released February 2026).
* This function is a preview function and is only available to users on the Beta Channel.
* This function is a simplified version of the IMPORTTEXT function.
* Import Functions do not automatically refresh. To update imported data, use the Refresh All button on the Data tab.
* When importing a file from the web, you may need to provide credentials or sign in to access the source file.
* If "skip_rows" < 0, then rows are skipped from the end of the array.
* If "take_rows" < 0, then rows are taken from the end of the array.
* If "locale" is left blank, then the OS locale is used.
* You can use the IMPORTTEXT function for more flexibility, including support for multiple delimiters, encoding, and fixed-width columns.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=IMPORTCSV("C:\Data\sales.csv")
2	=IMPORTCSV("C:\Data\example.csv",1)
3	=IMPORTCSV("C:\Data\example.csv",,2)