ImportCSV Function

IMPORTCSV() Description

The IMPORTCSV function allows loading data from a CSV file directly into 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.

Key Features of the IMPORTCSV Function

Syntax:

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

Parameters:

• Path: Local file path or URL of the CSV file to import.
• [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) Defines regional formatting (locale) for automatic conversion of dates, numbers, etc. By default, data is returned as text.

Usage Example

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 It Works?

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 in the array and press Ctrl+/.

If you need to convert an array formula to values - 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 that, this function will be available in all files that will be opened in Excel (LibreOffice Calc).