The simplest way to copy an Excel file

The fastest way to copy an Excel file is to find it in File Explorer (Windows) or Finder (Mac), right-click it, and select Copy. Then right-click in the same folder and select Paste. Windows will create a file called "Copy of [original name].xlsx" in the same location. You now have two identical files.

This method works because Excel files are just files on your computer, like any other document. You do not need to open Excel or use any special menu — the operating system handles the duplication. This is the method to use when you want a backup before making changes, or when you want to send someone a file without affecting your original.

If you cannot find the file on your computer, search for the filename in your system search box. Once you locate it, the copy-and-paste method works the same way.

Key Takeaways

  • Right-click the Excel file in File Explorer or Finder, select Copy, then right-click in the same folder and select Paste to create an identical duplicate.
  • Windows automatically names the copy "Copy of [original name].xlsx" so you can tell the two files apart when ready.
  • You can also open Excel, use File > Save As, and give the file a new name to create a copy while keeping the original closed.
  • Moving a copy to a different folder is safer than copying and pasting in the same location if you want to avoid confusion about which file is which.

Using Save As to copy a file you have already opened

If you already have an Excel file open on your screen, the quickest way to create a copy is through the File menu. Click File in the top left, then click Save As. Excel will show you a dialog box with the current filename highlighted.

Type a new name for the file — for example, if the original is called "Budget 2024.xlsx", you might name the copy "Budget 2024 - Backup.xlsx" or "Budget 2024 - Draft.xlsx". Then click Save. Excel will create the copy and switch to the new file. Your original remains unchanged on your computer.

This method is useful when you are already working in a file and realize you want to keep the current version untouched. You can make changes to the copy without worrying about overwriting your original work.

Copying a file to a different folder or external drive

You may want to copy an Excel file to a different location — perhaps to an external hard drive for backup, to a cloud folder like OneDrive or Google Drive, or to a USB stick to take somewhere else. The copy-and-paste method works for this too.

Find the file in File Explorer or Finder, right-click it, and select Copy. Navigate to the destination folder (your external drive, cloud folder, or USB stick), right-click in the empty space, and select Paste. The file will appear in the new location. The original stays where it was.

If you are copying to a cloud folder like OneDrive, the file will sync to the cloud automatically once it lands in that folder. This gives you a backup that exists both on your computer and in the cloud. If you are copying to an external drive, make sure the drive is connected and appears in File Explorer or Finder before you paste.

Renaming a copy so you know which is which

When you paste a copy in the same folder, Windows names it "Copy of [filename]" automatically. On a Mac, it adds "copy" to the name. These names work, but they can get confusing if you make multiple copies or if you want a more descriptive name.

To rename a file, right-click it and select Rename (Windows) or press Enter after selecting it (Mac). Type the new name and press Enter. A good naming system might be "Budget - Original", "Budget - Draft", and "Budget - Final" so you can tell them apart at a glance. Another approach is to add the date: "Report 2024-01-15.xlsx".

Descriptive names save time later when you are looking for a specific version. Avoid names like "Final" or "Final Final" because they do not tell you which version is actually the most recent.

What happens to formulas and data when you copy a file

When you copy an Excel file, everything inside it copies exactly as it is — all the data, formulas, formatting, and sheets. If the original file contains a formula that adds up a column of numbers, that same formula will work the same way in the copy. If the original has three sheets with different data, the copy will have all three sheets identical.

The only thing that changes is the filename and the location (if you moved it to a different folder). The content itself remains untouched. This is why copying is safe — you cannot accidentally break the original by working on the copy.

If the original file is linked to other files (for example, a summary sheet that pulls data from another workbook), those links stay the same in the copy. The copy will still pull from the original linked files, not from copies of those files. If you want the copy to be completely independent, you may need to update those links manually, but that is a separate step beyond basic copying.

Copying a file when you do not know where it is saved

If you have an Excel file open but you are not sure where it is saved on your computer, you can find out through the File menu. Click File, then look at the top of the menu. You will see the filename and the folder path below it. That path tells you exactly where the file lives.

You can also click File > Open Recent to see a list of files you have worked on recently, and each one shows its location. Once you know where the file is, you can navigate to that folder in File Explorer or Finder and use the copy-and-paste method.

Another option: use your system search. On Windows, press the Windows key and type the filename. On Mac, press Command + Space and type the filename. The search will find the file, and you can right-click it to copy it from there.

Frequently Asked Questions

Can I copy an Excel file that is currently open?

Yes. You can use Save As from the File menu to create a copy while the file is open, or you can close it first and copy it through File Explorer or Finder. Both methods work. Save As is faster if you are already working in the file.

What if I copy a file and then delete the original by mistake?

The copy remains on your computer unaffected. Deleting one file does not touch any other files. If you deleted the original thinking you still had it, the copy becomes your only version going forward. This is why keeping copies is a good safety habit.

Does copying an Excel file take up twice as much space on my computer?

Yes, a copy uses the same amount of storage as the original. If your file is 5 MB, the copy is also 5 MB, so you now have 10 MB total. If storage space is tight, you can delete the original after confirming the copy works, but keeping both is usually safer.

Can I copy a file to cloud storage like OneDrive or Google Drive?

Yes. If you have OneDrive or Google Drive installed on your computer, those folders appear in File Explorer or Finder just like regular folders. Copy and paste the Excel file into them the same way you would copy to any other folder. The file will sync to the cloud automatically.

What is the difference between copying a file and making a backup?

Copying creates a duplicate on the same computer or in the same location. A backup usually means storing a copy somewhere separate — like an external drive or cloud service — so that if something happens to your computer, you still have the file elsewhere. A copy is a first step toward a backup, but a true backup lives in a different physical location.