Transfers in Google Sheets: Move, Copy, and Import Data

Google Sheets can transfer spreadsheet data by moving or copying cells, copying a whole sheet, or importing a range from another file with IMPORTRANGE. It does not send money or carry out bank transfers; it can only help you record, organize, and calculate information about them.

What “transfers” can mean in Google Sheets

People use “transfer” to describe several different tasks. You might move a block of cells to another location, copy a worksheet tab into a different spreadsheet, bring live data in from another file, or hand a spreadsheet over to another person. These actions have different results, so it helps to decide whether you want a one-time copy, a continuing connection, or a change in who controls the file.

A one-time copy is useful for an archive, report, or handoff that should not change when its source changes. An import is better when the destination needs to reflect new source data. Changing ownership concerns the spreadsheet file itself, not just the cells inside it. If you mean transferring funds, Sheets can track amounts and dates but cannot initiate a payment.

For example, a small club could keep a master list of dues in one spreadsheet and show selected columns in a treasurer’s reporting file. The treasurer could import the list for ongoing reference, or paste a values-only copy at month-end to preserve a fixed record. Those are distinct workflows even though both may be called a transfer.

Move or copy cells in the same spreadsheet

For a straightforward transfer within one spreadsheet, select the cells, cut them, and paste them in the destination. On Windows or ChromeOS, use Ctrl+X and Ctrl+V; on a Mac, use Command+X and Command+V. To leave the original in place, copy instead: Ctrl+C and Ctrl+V on Windows or ChromeOS, and Command+C and Command+V on a Mac.

You can also use Edit > Cut, Edit > Copy, and Edit > Paste in Google Sheets. If the destination already contains information, check the selected range before pasting: a paste can replace the contents of those cells. Copying formulas may adjust their relative cell references to suit the new location. For instance, a formula referring to the cell immediately to its left may continue to refer to the cell immediately to its left after it is pasted elsewhere.

To preserve displayed results without carrying formulas, copy the cells and choose Edit > Paste special > Values only. This is useful for a finished report or a snapshot. Values-only pasting does not preserve the original formulas, so it is unsuitable when the destination should recalculate as inputs change. Formatting and formulas may also be handled differently by other Paste special choices; check the pasted result rather than assuming every detail transferred.

Copy a sheet tab to another spreadsheet

When you want to transfer a whole worksheet tab, open the source spreadsheet and use the menu on the sheet tab. Choose Copy to, then select an existing spreadsheet or create a new spreadsheet. The copied tab appears in the destination as a separate sheet; the original remains in its source file. This is safer than recreating the sheet manually, but review formulas, charts, and references after copying because some may depend on other tabs or data that were not copied.

Google Sheets does not treat copying a tab as moving the entire source spreadsheet. If you need the tab removed from its original file, verify the copy in the destination first, then delete the original tab only if that is genuinely what you intend. A copied tab can also bring along information you did not mean to share, such as hidden rows, supporting calculations, or notes. Inspect the complete sheet before sending it to someone.

If the goal is to make a separate copy of the entire spreadsheet rather than one tab, use File > Make a copy. Give the copy a clear name and choose its destination in Google Drive. The new file is separate from the original, though its sharing settings and linked data should be checked rather than assumed to match your needs.

Import a live range from another file

For a continuing connection between files, Google Sheets provides IMPORTRANGE. It retrieves a range from another spreadsheet and displays the imported data in the destination. With the source spreadsheet URL in A1 and a source tab named Sales, for example, enter this in an empty destination cell:

=IMPORTRANGE(A1,"Sales!A1:D100")

Here, A1 contains the source spreadsheet’s URL, and the requested range is cells A1 through D100 on its Sales tab. You can instead put the URL directly in the first argument. The imported result fills the relevant rows and columns, so keep the corresponding space in the destination clear. If the source data changes, the displayed import can update; it is not a fixed, independent snapshot.

The first time a destination file connects to a particular source, Sheets may show a permission prompt. Open the destination, select the cell containing the import, and choose Allow access when prompted. The person setting up the connection needs permission to access the source. Avoid granting access casually: anyone who can edit the destination may be able to change its formula, and the imported material may reveal information to destination-file users.

Use a narrow range such as A1:D100 rather than importing an entire tab when you only need a few columns. Clear labels, consistent headers, and a defined destination area make the import easier to maintain. If a tab name contains spaces, surround it with single quotation marks inside the range text, as in =IMPORTRANGE(A1,"'Monthly Sales'!A1:D100"). The quoted tab name is part of the range string.

Choose a method based on the result you need

The key decision is whether the destination should remain connected to the source. Use a cut-and-paste operation for a move within one file, a regular copy for a duplicate, Paste special > Values only for a static result, and IMPORTRANGE for a range that should keep drawing from another spreadsheet.

One-time handoff: Copy the relevant cells or tab, then check the destination and remove anything that should not be shared.
Fixed record: Paste values only, or make a separate copy of the file, so later source edits do not update the record.
Ongoing reporting: Use IMPORTRANGE for the columns and rows the report actually requires.
File handoff: Share the spreadsheet or review ownership options rather than transferring cells one by one.

For example, a weekly report that needs current inventory counts is a good candidate for an import. A signed-off quarterly report may be better as a fixed copy, since a later edit to the working sheet should not silently change the historical version. Choose based on how the data will be used, not just on which method takes the fewest clicks.

Sharing, ownership, and privacy

Moving data does not automatically give the intended recipient the access they need. A person may be able to view the destination but not the source, or may have access to the source but not the destination. For an import, check both files’ sharing permissions and test the result using an account with the intended level of access when practical.

Google Drive sharing controls who can view, comment on, or edit a file. If you need another person to control the spreadsheet, look at the sharing and ownership options available for that file and account; transfer eligibility can depend on account type and organizational settings. Simply copying a sheet does not transfer ownership of the source file. In a work or school account, an administrator may limit external sharing or ownership changes.

Before transferring customer, employee, financial, or other sensitive data, remove unnecessary columns and check hidden content. A sheet that displays only a few columns may still contain other information elsewhere in the tab. Share the minimum data required, use the correct recipient, and avoid publishing a file to the web unless public access is intended.

Common problems and practical fixes

An IMPORTRANGE result that says the user must connect spreadsheets usually needs the Allow access approval. A result showing an error can also mean the URL is wrong, the tab name is misspelled, or the requested range does not exist. Check the source URL and tab spelling, including spaces and punctuation, before rebuilding the formula.

If imported cells do not appear, make sure the destination cells are empty; existing content can block the result from expanding. If the imported data seems out of date, allow time for Sheets to refresh and check whether the source itself has changed. An import is not a guaranteed instant synchronization system for every workflow, so critical reports should be checked against their source.

After a copy, formulas may show errors if they refer to a tab or range that was not copied. The copy may also retain formulas rather than the values you expected. Review important totals and references in the destination, and use Paste special > Values only when the intended result is a snapshot. When copying a tab, inspect charts and any cross-tab calculations as well as visible cell contents.

Alternatives and limits

For occasional transfers, Sheets’ built-in copy, paste, and import tools are usually sufficient. For a file you only need to read in another format, use File > Download and select an available format such as Microsoft Excel or comma-separated values. Downloading creates a file for you; it does not keep that file synchronized with the Google Sheets original.

Excel does not use Google Sheets’ IMPORTRANGE function. If someone opens or converts a spreadsheet in Excel, do not assume that this formula will work there. Excel has its own ways to link workbooks and bring in external data, but the appropriate option depends on the Excel version, file location, and whether the data should refresh. For recurring transfers between business systems, an approved integration or a controlled export process may be more reliable than manual copying.

There is generally no separate fee for using a basic Sheets cell copy or formula simply because data is transferred. However, Google account or Workspace plans, Drive storage limits, organizational policies, and third-party integration services can affect what is available. Check your account’s current terms for plan-specific limits rather than relying on a general assumption.

Frequently Asked Questions

Can Google Sheets transfer money?
No. Sheets can record transactions, calculate totals, and organize payment information, but it cannot initiate a bank transfer or payment. Use your bank or payment provider for actual transactions and verify the recipient and terms there.

How do I transfer data from one Google Sheet to another?
For a one-time transfer, copy the cells or use Paste special > Values only if you need a snapshot. To keep a range connected to another spreadsheet, use IMPORTRANGE and approve access when prompted.

Does IMPORTRANGE copy the data permanently?
No. It displays data from a source range and can reflect subsequent changes. To keep a fixed record, copy the displayed results and paste values only into the destination.

Can I move a sheet tab to another spreadsheet?
You can use the tab menu’s Copy to option to copy it to another spreadsheet. Confirm that the copy is complete before deleting the original tab; copying is not the same as moving the entire source file.

Why is IMPORTRANGE asking me to allow access?
The destination needs authorization to connect to that source spreadsheet. Select the import formula and choose Allow access if you have permission to view the source and the connection is appropriate for the data.

Can I transfer Google Sheets data to Excel?
Yes. Use File > Download and choose a compatible format, such as Microsoft Excel. The downloaded file is a separate copy, and Google Sheets-specific functions such as IMPORTRANGE may not work in Excel.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.