Arrow left
Back to product guides
Google Sheets Tips

How to Import Named Functions in Google Sheets

In this article, you will learn how to import the Named Functions you created in a different file into another file. If you want to know about the Named Functions, read this article.

How to call the Named Functions from another Google Sheets file

  1. Type “sheet.new” in a browser to open a new sheet.
  2. Go to the “Data” tab → “Named functions”.
  3. Click “Import function” at the bottom of the pop-up on the right.
  4. Select the Google Sheets file that contains the Named Functions you want to import.
  5. Choose if you import all Named Functions or if you import only selected Named. Functions. To import all formulas, click “Import all”. To import functions selectively, check the boxes next to the formulas you need to import and click “Import”.
  6. To use the imported formulas, you can (i) type their names directly in cells, (ii) go to the “Data” tab → “Named functions” to show the Named Functions list, or (iii) move to the “Insert” tab → “Functions” “Named functions”.

The following pictures show how to go through steps 2 to 5 above.

Step 2: Go to “Data” “Named functions”

How to import the Named Functions from the menu bar in Google Sheets

Step 3: Go to “Import function”

How the Named Functions List looks like in Google Sheets 

Step 4: Selection of the file

How to import the Named Functions from another Google Sheets

Step 5: Selection of the Named Functions

How to select the Named Functions to import from another Google Sheets

Learn how to do this step-by-step in the video below 👇

Do you need personal help?

Our team of real people are here to help you any time between 9am and 10pm GMT.
Check Icon
Email us at: founders@liveflow.io
Check Icon
Call us at +1 (415) 650-1711