Data table export and import

You can export data directly from a data table to an Excel .xlsx format file. You must have Excel installed on your computer to use Export from a data table. You can also import data into a data table from an Excel file, as long as the file name and worksheet name are in the appropriate format.

For both import and export, the data must be limited to 1,048,576 rows and 16,384 columns (the limit for Microsoft Excel).

Supply Chain Guru X also supports copying table records and pasting them into other applications, such as Excel. If you select all records in a table (for example, using Ctrl+A), keep in mind that only the first 200 records will be copied. When you open a table, Supply Chain Guru X loads only 200 records at a time to provide good performance.

Data table export

Use the Export function to export table records to an Excel .xlsx format file or to a different model.

Export a table to an Excel file

1. Click Export.
2. Select one of:
   • Export records matching the current filter – This option is available and selected if a filter is currently applied to the table.
   • Export selected records – This option is available if one or more records in the table are currently selected (highlighted).
   • Export all records
3. Ensure that the Export Destination is set to “Export to Excel”.
4. Click Export. The table records are exported to an Excel file in the folder where the model file is located. The default name for the file is <ModelName>_<TableName>_en.xlsx. If Excel is installed on your computer, Excel is opened and the spreadsheet is displayed.

Export a table to a different model

1. Click Export.
2. Select one of:
   • Export records matching the current filter – This option is available and selected if a filter is currently applied to the table.
   • Export selected records – This option is available if one or more records in the table are currently selected (highlighted).
   • Export all records.
3. Select “Export to a Different Model” in the Export Destination drop-down.
4. Enter the file path of the model, or click Browse [...] and navigate to the model for the exported data, then click Open.
5. Select the Export Option:
   • Replace Records in Destination Table – Existing records in the table are cleared and replaced with those exported.
   • Append Records to Destination Table – Exported records are appended to any records already in the table.
6. Click Export. The table records are exported to the model you selected. Records either replace the existing records, or are appended to any records already in the table.

Data table import

Use the Import function to import table records from an Excel .xlsx format file. The Excel file must be in the folder where the model is located. The name should be in the format <ModelName>_<TableName>_en.xlsx.

Import to a table

1. Click Import.
2. Select one of:
   • Replace – Replaces all data in the target table by deleting existing rows before import.
   • Append – Appends rows from the Excel file to those already in the target table.
3. Click Next. The data is imported based on the action you selected.
   For columns that support a Unit Of Measure, if the imported value does not include the Unit Of Measure Symbol, the default Unit Of Measure as defined in Model > Model Settings > Units and Currency is assumed.