1. Visualizing Data in Oracle Analytics Server
  2. Visualize Data
  3. Connect to Your Data Using Datasets
  4. Create Datasets from Data Sources
  5. Create Datasets from Files

Create Datasets from Files

You can create datasets from a range of files, including comma-separated value (*.CSV), text (*.TXT), and spreadsheets.

Topics:

About Files for Datasets

You can create datasets from Microsoft Excel spreadsheets (XLSX and XLS), Google Sheets, comma-separated value (CSV) files, and text (TXT) files.

Size Limits

  • The maximum file size you can upload is 250 MB.
  • The maximum number of columns for a single sheet is 250.

Uploading Files

  • You can upload data from multiple sheets in a spreadsheet file at the same time.
  • You can upload and use files from your computer, or from Dropbox or Google Drive data source connections.
  • When you upload a file, you can use it only in the dataset that you uploaded it to. Because Oracle Analytics doesn't store an uploaded file, you must upload the file again to include it in another dataset.

Formatting Rules for Excel Spreadsheet and Google Sheets Files

  • Tables start in Row 1 and Column 1.
  • Tables have a regular layout with no gaps, repeated column names, or inline headings. An example of an inline heading is one that's repeated on every page of a printed report.
  • Row 1 contains the unique names of the columns in the table.
  • Row 2 and greater contain the data for the table.
  • Data in a column is of the same type. For example, don't use a phone number column to hold email addresses.
  • Data is at the same granularity.

Character Set Encoding Rules for CSV and TXT Files

  • Encode source files using UTF-8.
  • Before you edit your files, configure your text editor to use the appropriate font and script (or subset).

Create a Dataset from a File Uploaded from Your Computer

You can upload spreadsheets from Microsoft Excel or Google Sheets, CSV files, and TXT files from your computer to create a dataset.

Confirm that the file that you want to upload meets these requirements:
  • The file is either a Microsoft Excel (.XLSX or .XLS format) or Google Sheets spreadsheet, a CSV file, or a TXT file.
  • Spreadsheets shouldn't contains pivoted data.
  • Spreadsheets are structured properly for import and use as a dataset. See About Files for Datasets.
  1. On the Home page, click Create and then click Dataset.
  2. In the Create Dataset dialog, either drag and drop a file to the dialog, or click Drop data file here or click to browse to browse your computer for a file to upload.
  3. In the Create Dataset Table dialog, use the Name field to change the default dataset name if required.
  4. If you're uploading a spreadsheet with multiple sheets, click the Select list to select a single sheet, or click All Sheets to load every sheet.
  5. Optional: If you’re uploading a CSV or TXT file, use the Separated By, Thousand Separator, and Decimal Separator fields to configure the default delimiters.
    To specify a custom delimiter, choose Custom in the Separated By field and enter the character you want to use as the delimiter. In the CSV or TXT file, a custom delimiter must be one character. The following example uses a pipe (|) as a delimiter: Year|Product|Revenue|Quantity|Target Revenue| Target Quantity.
  6. Click OK to upload the file and create the dataset.

Create a Dataset from a File Uploaded from Dropbox or Google Drive

You can upload spreadsheets from Microsoft Excel or Google Sheets, CSV files, and TXT files from Dropbox or Google Drive and use them to create a dataset.

Note:

Files uploaded from Google Analytics aren't available to create or include in a dataset with multiple tables.
Confirm that the file that you want to upload meets these requirements:
  • The file is either a Microsoft Excel (.XLSX or .XLS format) or Google Sheets spreadsheet, a CSV file, or a TXT file.
  • Spreadsheets shouldn't contains pivoted data.
  • Spreadsheets are structured properly for import and use as a dataset. See About Files for Datasets.
  1. On the Home page, click Create and then click Dataset.
  2. In the Create Dataset dialog, select a connection.
  3. Browse for and select the file that you want to upload.
  4. In the Create Dataset Table dialog, use the Name field to change the default dataset name if required.
  5. If you're uploading a spreadsheet with multiple sheets, click the Select list to select a single sheet, or click All Sheets to load every sheet.
  6. Optional: If you’re uploading a CSV or TXT file, use the Separated By, Thousand Separator, and Decimal Separator fields to configure the default delimiters.
    To specify a custom delimiter, choose Custom in the Separated By field and enter the character you want to use as the delimiter. In the CSV or TXT file, a custom delimiter must be one character. The following example uses a pipe (|) as a delimiter: Year|Product|Revenue|Quantity|Target Revenue| Target Quantity.
  7. Click OK to upload the file and create the dataset.

Add Multiple Files to a Dataset

A dataset can include more than one file uploaded from your computer or from Dropbox or Google Drive.

Note:

Files uploaded from Google Analytics aren't available to create or include in a dataset with multiple tables.
Before you add a file from a connection, confirm that the connection you need exists. See View Available Connections.
A dataset can contain tables created from files and connections. See Add a File to a Dataset Created From a Connection.
Confirm that the file that you want to upload meets these requirements:
  • The file is either a Microsoft Excel (.XLSX or .XLS format) or Google Sheets spreadsheet, a CSV file, or a TXT file.
  • The spreadsheet contains no pivoted data.
  • The spreadsheet is structured properly for import and use as a dataset. See About Files for Datasets.
  1. On the Home page, click Navigator and then click Data.
  2. Click the Datasets tab.
  3. Locate the dataset that you want to open, click Actions, and then click Open.
  4. Locate the file:
    • If the file you want to add is located on your computer, then in the Dataset editor's Connections pane, click Add, and click Add File.
    • If the file you want to add is located on Dropbox or Google Drive, then in the Dataset editor's Connections pane, click Add, and then click Add Connection.
  5. Browse for and select the file that you want to upload.
  6. In the Create Dataset page's Name field, provide a name for the dataset table created from the file.
  7. If you’re uploading a CSV or TXT file, then in the Separated By, Thousand Separator, and Decimal Separator fields, confirm or change the default delimiters.
    To specify a custom delimiter, choose Custom in the Separated By field and enter the character you want to use as the delimiter. In the CSV or TXT file, a custom delimiter must be one character. The following example uses a pipe (|) as a delimiter: Year|Product|Revenue|Quantity|Target Revenue| Target Quantity.
  8. Click OK to add the file to the dataset.
  9. In the Connections pane, confirm that the file was added.
  10. Click Save.