External data functions

IMPORTCSV

Needs a host that can read files

The answer is a file the host reads. Microsoft's page lists it for Insiders on Windows; DNA Calc does not know the name yet. How we measure this

No local names are recorded for this entry.

What it does

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

IMPORTCSV loads a CSV file into a dynamic array with one formula. It is a shorter form of IMPORTTEXT for this one format.

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

path and the optional arguments mean what they mean in IMPORTTEXT.

Try it

Input cells (optional)

Example: {"B2": 3, "B3": 4}. A1 holds the formula. Other cells need values before a formula can read them.

Enter a formula, then calculate.

Runs locally in your browser with OneCalc. Its answer may differ from Excel. Use English function names and commas between arguments.

The OneCalc preview has no answer for this function: see the state above.

Quirks

It does not update by itself: use Refresh All on the Data tab. The default locale belongs to the machine. Microsoft's page does not list errors, and none are recorded here.

How to implement

DNA Calc does not know this name yet. An implementation needs file and URL access from the host, a parser with the page's delimiter, encoding and locale rules, an array result, and a refresh step separate from recalculation. Web sources also need the host's sign-in handling.

Rust code

This entry has no Rust implementation yet.

No implementation has been published with a Handbook test suite for this function.

Version differences

Microsoft's page lists it for Microsoft 365 Insiders in the Beta channel on Windows, version 2502 (build 18604.20002) or later. No Excel answers for this function are recorded here, so no comparison between Excel builds exists.

Alternatives

  • IMPORTTEXT for other delimiters, fixed-width files and encodings.
  • Power Query, for transformations and repeatable loads.

Named variants

No named variants are recorded yet.

Suggest a correction or contribute an implementation · For agents