IMPORTTEXT

IMPORTTEXT(path [,delimiter] [,skip_rows] [,take_rows] [,encoding] [,locale])

Returns the contents from a text-based file displayed as a dynamic array.

path	The local file path or URL of the CSV file you want to import.
delimiter	(Optional) A character or string that specifies how columns are separated in the file.
skip_rows	(Optional) A number that specifies how many rows to skip.
take_rows	(Optional) A number that specifies how many rows to return.
encoding	(Optional) The file encoding.
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.
* Import Functions do not automatically refresh. To update imported data, use the Refresh All button on the Data tab.
* If "delimiter" is left blank, then tab is used.
* 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 "encoding" is left blank, then UTF-8 is used.
* If "locale" is left blank, then the OS locale is used.
* You can specify fixed-width columns by passing a comma-separated array of ascending integers in the delimiter argument.
* You can use the CHAR function to specify special characters for the delimiter argument.
* You can use the IMPORTCSV function as an easier alternative for importing CSV files.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=IMPORTTEXT("C:\Data\example.txt", "\|")
2	=IMPORTTEXT("C:\Data\fixedwidth.txt", {1,3})
3	=IMPORTTEXT("C:\Data\example.txt",,,2)