Upload a New File

Import data into SAP Agile Data Preparation from a file.

1. Navigate to the Upload a New File dialog in one of the following ways:
   • When you first create a project and Create worksheet from... appears, select the File icon.
   • If you already have worksheets in your project, click the “+” sign near the top of the screen next to the last worksheet name, and select Upload File.
2. Select a valid CSV file, Excel file, or a ZIP file that contains an XSD file and one or more XML files using the Browse button or by dragging and dropping the file into the dialog box.
   Note

   If your CSV file or Excel file is contained in a ZIP file, you must extract the file to a folder and upload the file from that folder.

3. Select which XML entries or Excel sheets to upload.
   Note

   To change the options listed below for files with multiple XML entries or Excel sheets, click the right arrow next to each entry or sheet name that you want to edit.

4. For an Excel file, you can change the default settings for any of the following options:

   Option	Description
   Available Columns	Select the columns you wish to work with instead of accepting the default of all columns.
   Worksheet	If the file has multiple worksheets, select which worksheet you want to import in the drop-down list that appears in this option.
   Row Range	Select the row numbers you wish to work with instead of accepting the default of all rows.
   Set first row as header	By default, this option is selected. If, for example, the uploaded file has no header row, you can deselect this check box.
   Store data	By default, this option is selected. This option stores the data in your worksheet in your local user directory so that the data is still accessible if the worksheet is removed. If you do not wish to keep a back-up copy in your user directory, deselect this check box.

   Note

   If data is formatted as a string in an Excel file, it will upload as a string. Similarly, if data is formatted as a decimal in an Excel file, it will upload as a decimal.

5. For an XML file, you can change the default settings for any of the following options:

   Option	Description
   Available Columns	Select the columns you wish to work with instead of accepting the default of all columns.
   Store data	By default, this option is selected. This option stores the data in your worksheet in your local user directory so that the data is still accessible if the worksheet is removed. If you do not wish to keep a back-up copy in your user directory, deselect this check box.

   Note

   If you are uploading an XML file, your XSD file can have definitions of the following data types and XML tabs:

   Supported Data Types	Supported XML tags
   Boolean byte date dateTime decimal float integer long short string	xs:attribute xs:complexType xs:element xs:extension xs:restriction xs:sequence xs:simpleType

   The following elements are not supported:

   • compound data types

   • multiple roots

   • list of XML elements

   • XML namespaces

6. For a CSV file, you can change the default settings for any of the following options:

   Option	Description
   Available Columns	Select the columns you wish to work with instead of accepting the default of all columns.
   Row Range	Select the row numbers you wish to work with instead of accepting the default of all rows.
   Delimiter	The application detects the delimiter between column values in the first row of the file and displays it. You can change the delimiter to one of the following values if it exists in the file: Comma Semicolon Tab Pipe
   Set first row as header	By default, this option is selected. If, for example, the uploaded file has no header row, you can deselect this check box.
   Store data	By default, this option is selected. This option stores the data in your worksheet in your local user directory so that the data is still accessible if the worksheet is removed. If you do not wish to keep a back-up copy in your user directory, deselect this check box.
   Enclosing Delimiter	By default, this option is selected. The enclosing delimiter is the delimiter value, such as double quotes, that encloses each column value. For example: "ABC", "DEF", "HIJ".

   Note

   If you deselect the Enclosing Delimiter option or select a Delimiter value that is invalid for the current CSV file, you might receive a message that indicates your file has a different number of columns in each row.

7. Click Create.
   Each uploaded file, entry, or sheet becomes a worksheet in SAP Agile Data Preparation.

   • For a CSV file, the file name becomes the worksheet name. For example, if you upload a file named file1.csv, the worksheet name is file1.

   • For an XLXS file, the name of the sheet becomes the worksheet name. For example, if you upload sheet1 of file1.xslx, the worksheet name is sheet1.