Export data

You can export data from your model to Excel .xlsx format files:

• Export from the model - You can export either the model structure only (table and column names as a template) or all data currently populated in the model. This export feature is intended for smaller models. Use the Download feature for large models.
• Export from a data table - The data from the current table is exported to an Excel file. The file has a name in the format <ModelName>-<TableName>.xlsx and it is downloaded to your computer. All records in the table are exported, even if a filter is currently applied to the table.

If your table has 100,000 or more rows, it will be exported as a CSV (comma separated value) file, rather than as an Excel xlsx file. If your computer region uses a commas as the decimal symbol, see CSV files in regions such as Germany.

Export data from the model

1. Open the Models page .
2. Select the model you want to export.
3. Click Export. You see the Export Model fly out.
4. Select the type of export you want to perform:
   • Export Only Structure - Creates a template Excel .xlsx file that contains the table and column names for the model structure. Each table is written to an individual sheet in the Excel file.
   • Export Data - Creates one of the following, based on the number of table rows:
     • All tables less than 100,000 rows - An Excel .xlsx file with all the data currently in the model. Each model table is written to an individual sheet in the Excel file.
     • One or more tables with 100,000 or more rows - A .zip archive with all the data currently in the model. The archive contains a separate .csv format file for each model table.
5. Click Export. The Excel file is created and you receive an email notification with the results of the export.
6. Click the link in the email to download the Excel file.

Export data from a data table

1. Open the input or output table you want to export.
2. Click Export. You see the Export from table fly out.
3. Click Export. The data is exported to an Excel file and downloaded to your computer. If your table has 100,000 or more rows, it will be exported as a CSV (comma separated value) file.

Leading zeros in values

In some cases, values within your tables may have leading zeros. For example, postal codes such as 02139 and product names such as 0012014. When you export table data to .csv format files (for tables with 100,000 or more records), these values retain their leading zeros. However, if you open the file in Excel, the leading zeros are trimmed by default. You can preserve the leading zeros by pulling in the CSV file using the Excel From Text/CSV function on the Data tab as described in this article:

Keeping leading zeros and large numbers

CSV files in regions such as Germany

In regions where the decimal symbol is a comma (,), if you open a comma separated value (.csv) file in Excel, all column values are displayed in a single column. To successfully open the file in Excel so that each column is displayed separately, prepend the data in the csv file with the following as the first row in the file:

sep=,

When this is defined, you can open the file in Excel and the data is displayed in columns as expected.