Arrow left
Back to 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

  • Type “” in a browser to open a new sheet.

  • Go to the “Data” tab → “Named functions”.

  • Click “Import function” at the bottom of the pop-up on the right.

  • Select the Google Sheets file that contains the Named Functions you want to import.

  • 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”.

  • 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”.

Your next financial spreadsheet could be right here!
100+ spreadsheet templates, from FP&A to tax planning.
Free Spreadsheet Templates

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

The world's top businesses trust LiveFlow to automate their financial reporting
We turn Quickbooks Online data into a live FP&A dashboard in Sheets FAST!
Book a Demo

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

Automate financial reporting with LiveFlow

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how

Need help?

Our team is here to help you any time between 9am and 10pm EST.
Check Icon
Email us at:

Liked this article? Then you'll love the ones below