Spreadsheets

IMPORTDATA: load a CSV from a link into Google Sheets

Use IMPORTDATA to load a public CSV or TSV link into Google Sheets, learn how often it refreshes, and see why it cannot read a bank statement behind a login.

Editorial illustration for IMPORTDATA: load a CSV from a link into Google Sheets

IMPORTDATA loads the contents of a public .csv or .tsv link straight into a sheet: =IMPORTDATA(B1), where B1 holds the full link. It cannot read anything that sits behind a login, which includes a bank statement in your net-banking account, so for statements you download the file and import it instead.

What exactly can IMPORTDATA fetch?

The syntax is IMPORTDATA(url, delimiter, locale). Only the first argument is required. The link must open without signing in and must return plain delimited text, usually a comma-separated or tab-separated file.

  • A published CSV of another sheet of your own. Publishing makes it viewable by anyone who has the link, so use it only for data you are happy to expose.
  • A public file from an organisation that offers a direct data download link ending in .csv or .tsv.
  • Not an Excel file, a PDF or a web page. For a table inside a web page, a different function exists, covered in the next article in this series.

Put the link in a cell and point the formula at that cell. It keeps the formula short and lets you swap the source without editing the formula.

How do I set it up step by step?

  1. Open a new tab and name it Import so the data lands away from your working sheets.
  2. Paste the link into B1 as plain text.
  3. In A3 type =IMPORTDATA(B1). The rows fill downward and across from A3.
  4. If the columns look jammed into one, the file may use semicolons. Add the delimiter: =IMPORTDATA(B1, ";").
  5. Point your summary formulas at the Import tab, not at the live range inside your reports, so a broken fetch only breaks one place.

How often does it refresh?

IMPORTDATA refreshes by itself, but on a schedule that Google decides, so you cannot count on a second-by-second or even a minute-by-minute update. Reopening the file or editing the formula forces a fresh fetch. If you need a number as it stood on a particular day, copy the imported block and paste it as values into another tab. The imported block will have moved on by tomorrow.

Why does IMPORTDATA show an error?

Message or symptomLikely causeWhat to try
Could not fetch urlThe link is wrong, private, expired or needs a loginPaste the link into a private browser window; if it asks you to sign in, IMPORTDATA cannot read it
Imported content is emptyThe link returned a web page or nothing at allConfirm the link ends in the file itself, not a viewer page
Array result was not expanded because it would overwrite dataCells below or beside the formula are not emptyClear them, or move the formula to a blank tab
Text crammed in one columnWrong separatorAdd the delimiter argument, such as ";" or a tab
Resource exceeds maximum sizeThe file is too large for the functionUse a smaller extract, or download and import the file by hand

Can IMPORTDATA read my bank statement?

No. A bank statement lives behind your net-banking login, and a link to it will not work for a sheet that is not signed in as you. Do not try to get round that by sharing your login or by pasting a session link anywhere, because that puts your account at risk and still would not give the function a file it can read.

The reliable route is the plain one. Download the statement as a CSV or Excel file from your bank, then use File > Import in Google Sheets and choose to append or replace. The columns and the date format come exactly as your bank prints them, so look at a few rows before you build formulas on top.

Where does this fit in a budget workflow?

IMPORTDATA suits reference data that sits at a public address and changes now and then, such as a list your own other sheet publishes. It is a poor fit for personal transactions. If your goal is to get statements into one place with categories, SpendixAI takes PDF, CSV or Excel statements you upload and shows the rows for review before saving. There is no bank connection, and it never asks for your net-banking login.

Quick check before you rely on it

  • The link opens in a private window with no sign-in.
  • The file is delimited text, not Excel or PDF.
  • The destination area is empty.
  • You have a pasted-values copy of any month you have reported on.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports