1. Import and export data
  2. Export basics
  3. Export file types

When you export data, you can choose from different file types to suit your use case, such as CSV or PDF. The default export file type is CSV.

If you want to import data back into Anaplan, you must export your data to a CSV or TXT file.

You can export data to the following file types. Use the Comma Separate Values for Excel file type if your data contains non-ASCII characters.

File typeFile extensionSupports grid lines and text formatting
Excel (XLS).xls
Excel without formatting (XLS).xls
Excel Open XML (XLSX).xlsx
Excel Open XML without formatting (XLSX).xlsx
Comma Separated Values (CSV).csv
Text (TXT).txt
Adobe PDF (PDF).pdf
Comma Separated Values for Excel (CSV).csv

If you export a text value that includes commas to a CSV file, the export inserts double-quotation marks around the value. This applies to line items with Text data types.

If you export to Excel, your data may display in a different format. For example, if you export data to a CSV, then open the file in Excel, time periods convert to dates. Learn how to manage data in Excel in Import or export text (.txt or .csv) files(opens external page).


We may update our documentation occasionally, but will only do so in a way that does not negatively affect the features and functionality of the Anaplan service.