What exporting means and why you might need it

Exporting means saving your work or data in a different format or location than the program normally uses. When you export, you take information stored inside one program — a spreadsheet, a photo library, an email inbox, a document — and convert it into a format that another program can read, or save it to a place outside that program.

You export when you want to switch programs, back up your data somewhere safe, share files with people using different software, or move information between devices. For example, you might export your contacts from your phone's address book as a CSV file so you can import them into a new phone, or export a document from Google Docs as a Word file so a colleague can edit it in Microsoft Office.

Most programs have an export option built into their menu. The location and name of that option varies — sometimes it's under File, sometimes under Settings, sometimes under a three-line menu icon. This guide explains where to look and what happens when you export.

Key Takeaways

  • Export options are usually found in the File menu or under Settings, though some programs hide them under a menu icon or share button.
  • When you export, the original file stays in the program — exporting creates a copy in a new format, it does not move or delete anything.
  • Common export formats include CSV for spreadsheets and contacts, PDF for documents, and JPG or PNG for images.
  • The exported file saves to your computer's Downloads folder or a location you choose, and you can then move it, email it, or open it in another program.

Where the export option lives in common programs

The path to export differs by program, but a few locations cover most of what you will encounter. In desktop programs like Microsoft Word, Excel, and Google's suite, look in the File menu at the top left. Click File, then look for "Export As", "Save As", "Download", or "Export" — the exact wording depends on the program.

In web-based programs like Gmail, Google Photos, or Dropbox, the export option is often under a menu icon — usually three horizontal lines (called a hamburger menu) or three dots (called a more menu). Click that icon, then scroll down to find "Export", "Download", or "Save a copy".

Some programs put export under Settings instead. This is common in password managers, note-taking apps, and backup tools. Open Settings, look for a section called "Data", "Backup", "Import/Export", or "Advanced", and the export button should be there.

If you cannot find the export option after checking those three places, search the program's help menu by pressing Ctrl+? (Windows) or Command+? (Mac), then type "export" into the search box.

What format to choose when exporting

When you click export, the program usually asks you to pick a format. The format determines what kind of file you get and which other programs can open it. Common formats include:

  • CSV (Comma-Separated Values) — used for spreadsheets, contact lists, and databases. Almost every program that works with lists or tables can read CSV files.
  • PDF (Portable Document Format) — used for documents, forms, and anything you want to look the same on every device. PDFs preserve formatting and fonts.
  • JPG or PNG — used for photos and images. JPG is smaller but loses some detail; PNG keeps all detail but takes up more space.
  • XLSX or XLS — Microsoft Excel formats for spreadsheets. XLSX is newer and more widely supported.
  • DOCX or DOC — Microsoft Word formats for documents. DOCX is the current standard.
  • JSON or XML — technical formats used for moving data between programs or backing up complex information. You usually do not need these unless another program specifically asks for them.

If you are unsure which format to pick, choose the most common one for that type of file. For a spreadsheet, choose CSV. For a document, choose PDF or DOCX. For photos, choose JPG. The program usually defaults to the right choice anyway.

Where the exported file goes and what to do with it

When you export, the file saves to a location on your computer. By default, most programs save to your Downloads folder. You can usually change this by clicking "Browse" or "Choose Location" before you finish the export, which lets you pick a different folder.

Once the export is done, you can move the file anywhere you want — to a USB drive, to cloud storage like Google Drive or OneDrive, to an email attachment, or to another device. You can also open it in a different program right away. For example, if you export a spreadsheet as a CSV file, you can then open that CSV file in Excel, Google Sheets, or any other spreadsheet program.

The original file stays inside the program you exported from. Exporting creates a copy; it does not move or delete anything. If you delete the exported file later, the original is still safe in the program.

Exporting from your phone or tablet

Phones and tablets work differently than computers, so exporting on mobile devices is not always straightforward. Many phone apps do not have a built-in export button at all.

If the app does have export, look for a menu icon (three dots or three lines), then tap "Export", "Share", "Save", or "Backup". Some apps let you email the file to yourself, which is another way to move data off the device. Others let you save to cloud storage like Google Drive or iCloud.

If the app has no export option, you may need to use your phone's built-in backup feature instead. On iPhone, this means iCloud backup; on Android, it means Google backup. These backups save your data to the cloud, and you can restore it on a new phone later.

Exporting data before switching programs

If you are moving from one program to another — switching email providers, changing password managers, or moving your photos to a new service — export your data first. Most programs have a section in Settings or Help that explains how to export for this reason.

Export in the format the new program asks for. For example, if you are switching email providers, export your old emails as an MBOX or PST file (the formats most email programs accept). If you are switching password managers, export as a CSV file. The new program's setup wizard or help page usually tells you which format it needs.

After you export and before you delete anything from the old program, test the import in the new program to make sure the data came through correctly. This prevents losing information if something goes wrong.

Troubleshooting common export problems

If the export button is grayed out or not working, the program may be preventing you from exporting for security or licensing reasons. Some programs limit export to paid accounts, or do not allow export of certain types of data. Check the program's help section or contact support to find out why.

If the exported file is too large to email or upload, try exporting in a compressed format (like ZIP) if the program offers it, or split the export into smaller chunks. Some programs let you choose a date range or select only certain items to export, which reduces file size.

If the exported file will not open in the program you are trying to use it in, the format may not be compatible. Try exporting again in a different format, or check the other program's help page to see which formats it accepts.

Frequently Asked Questions

Does exporting delete the original file from the program?

No. Exporting creates a copy in a new format or location. The original stays in the program until you delete it yourself. You can export the same file as many times as you want.

Can I export just part of a file, like certain rows in a spreadsheet?

Yes, in most programs. Before you export, select only the rows, columns, or items you want to include. Then when you export, the program will ask if you want to export the selection or the whole file. Choose selection.

What is the difference between export and download?

Export and download are often used the same way, but technically export means converting to a different format, while download means saving a file from the internet to your computer. In practice, many programs use "download" to mean the same thing as export.

Can I export from a web-based program like Gmail or Google Docs?

Yes. Gmail has a download option in Settings under Forwarding and POP/IMAP. Google Docs has a download option in File menu. Other web programs usually have export under a menu icon or in Settings.

What should I do with the exported file after I create it?

That depends on why you exported it. If you are switching programs, import it into the new program. If you are backing up, move it to cloud storage or a USB drive. If you are sharing, email it or upload it to a shared folder. The exported file is just a regular file on your computer, so you can do anything with it that you would do with any other file.