Importing Data

If your data is in another workbook, you can copy and paste your range or table from one workbook to another. Select your data or table, click on Ctrl-C to copy the data to the clipboard, go to the target workbook Data Sheet, and then click on Ctrl-V to paste this data to the new location.

Note that table names are unique within each workbook. So, copying a table from one worksheet to another will copy the table contents, but the table name will be changed.

You can import data to your workbook in several different ways. Click on Data > Get Data to import data from various sources.

1. Import from a File (Excel Workbook, CSV, XML, JSON, etc.)
   
2. Import from a Database (SQL, Access, etc.)
   
3. Import from Other (Website, etc.)
   

Sigma Magic also has some functionality for importing data. On the Data Sheet worksheet, click on Analysis Setup to open the dialog box.

You can import data from tables or ranges stored in other workbooks using this dialog box. Sigma Magic has some standard files distributed as part of the installation. When you click on the Import Tables button, these files are displayed, but you can browse and select any Excel workbook that contains the data you want to import.

Once you pick the file you want to import, Sigma Magic will open the file and list all the data that this file contains. An example is shown below. The first data row is obtained from the table name called Design and the column name is Paint Conc. 1. It contains Numeric data and there are 100 rows of data in this table.

If you want to import this row into your current project, select this row and click on the OK button to import this data into your workbook. This data will be placed on the Data Sheet worksheet.

If your external workbook contains a lot of rows of data, you can also use the Search bar to narrow down the data to be displayed so that you can quickly select the data of interest.

• Related Articles

• Data Sheet

  While your data can be on any worksheet within a workbook, we recommend placing all data related to your project on the Data Sheet. A Data Sheet is a special worksheet that contains your data. To create a Data Sheet, click the Data button on the main ...

• Editing Data

  You can edit the data on your worksheet. This is your local copy of the data, and any changes you make to this data will be reflected in your analysis when you click on Compute Outputs. You can add additional rows or columns in your data table. You ...

• Data Tables

  Any data you wish to explore must be in Excel tables. All tables have a name and a header row containing the column's name. A table can host any data type - like dates, text, or numbers. All columns of the table have the same number of rows. If you ...

• Main Menu Bar

  The software is an add-in within Microsoft Excel. When you open Microsoft Excel, you should see the software on the main menu bar. Click on the Sigma Magic button to load the software into memory. This will open the Sigma Magic menus as shown in the ...

• Specifying Analysis Setup

  If you want to specify the options for any analysis, you can click on the Analysis Setup button on the main menu bar. Depending on the worksheet that is currently active, the analysis setup will be displayed for that worksheet. For example, if you ...