Function ImportCSV

IMPORTCSV() Description

The IMPORTCSV function allows you to load data from a CSV file directly into Excel (LibreOffice Calc). It provides a simplified way to retrieve comma-separated data as a dynamic array with options to skip or select rows and apply locale parameters for regional formatting.

Main Characteristics of the IMPORTCSV Function

Syntax:

=IMPORTCSV(Path; [SkipRows]; [TakeRows]; [Locale])

Parameters:

• Path: Local path to the file or URL of the CSV file to be imported.
• [SkipRows]: (Optional) A number indicating how many rows to skip. A negative value skips rows from the end of the array.
• [TakeRows]: (Optional) A number defining how many rows to return. A negative value takes rows from the end of the array.
• [Locale]: (Optional) Specifies regional formatting (locale) for automatic conversion of dates, numbers, etc. By default, data is returned as text.

Example of Use

The IMPORTCSV() function is extremely useful for automating external data processing. Simply specify the file path and selection parameters, and Excel (Calc) will automatically load the content:

=IMPORTCSV(Path; SkipRows; TakeRows; Locale)

We will have the following result:

In this example, the following values are used:

• Path: B1 - Full path to your file ("C:\temp\Exchange Rates.csv").
• SkipRows: B2 - Skip the first row (1).
• TakeRows: B3 - Display 10 rows (10).
• Locale: B4 - Recognize data based on the regional format for English language and USA country ("en-US").

Corresponding data from the text file:

How Does It Work?

Simply enter the IMPORTCSV() function into any cell, specifying the appropriate parameters. After that, you need to press Ctrl+Shift+Enter to enter the array formula and LO Calc will automatically return a table with data.

To select all cells associated with the array formula, simply select any cell of the array and press Ctrl+/.

If it is necessary to convert the array formula to a value - select the entire array and in the menu Data > Calculate select Formula to Value.

Download extension

You can use the function IMPORTCSV() by installing the extension YLC Utilities.

After this, this function will be available in all files that will be opened in Excel (LibreOffice Calc).