Upload a CSV File

If you are a trial user, you have the option to upload one or more CSV files that will act as a data source. Please note that this feature is not yet available in the full production release of GoodData but we plan to introduce it there in the future.

Connect data dialog showing the 'Upload CSV file' option.

The uploaded CSV files can be shared and used across all workspaces and by all users within your organization.

In the Logical Data Model (LDM), you can link data from multiple CSV files within the same data source. This is not possible if the CSV files are in different data sources.

If you need to update or delete a CSV file, follow these steps:

  1. Open the Data Sources tab.
  2. Select your CSV data source.
  3. In the dialog that appears, select the CSV file you want to update or delete.
  4. Click the three dots icon on the right and choose the appropriate action. For updating, select a CSV file whose content will overwrite the previously uploaded CSV file.

How to Format Your CSV

To ensure maximum compatibility with GoodData, your CSV file should adhere to the following formatting guidelines:

Field Names

  • Place field names in the first line of your CSV file.
  • Field names must be unique; ensure there are no duplicates.

Quotation Marks

  • It’s recommended to enclose string fields in double quotes (") especially if they might contain characters used as field separators or newline characters.
  • If a string field contains a double quote character (") within, escape it by using two double quote characters ("").
  • As a general guideline, adhering to RFC 4180 standards is advisable.

Using Commas

Using comma (,) as a decimal separator is not currently supported. We plan to add support for it soon.

Newlines

Avoid using newline characters within fields. If unavoidable, use LF (\n) as the newline separator within fields and CRLF (\r\n) as the record separator.

Date

Your CSV file can accommodate various common date formats:

  • dd-MM-yyyy, MM-dd-yyyy, yyyy-MM-dd
  • dd-MMM-yyyy, MMM-dd-yyyy, yyyy-MMM-dd
  • MMM dd, yyyy
  • Dates can be separated by a dash (-), slash (/), dot (.), space ( ), or no separator at all (for example yyyymmdd).
  • Both one-digit and two-digit day and month formats are supported.
  • The following formats also support two-digit year representations: dd-MM-yyyy, MM-dd-yyyy, yyyy-MM-dd.

Example Dates

  • 18.8.2014, 08 18 2014, 08-18-14
  • 18/08/14, Aug-18-2014, 2014.aug.18
  • 18 AUG 2014, Aug/18/2014, Aug 18, 2014

Time

  • Only the ISO format HH:MM:SS is supported for time.
  • We consider all times to be UTC, there is currently no support for timezones.

Limits

  • A maximum of 250 columns is allowed.
  • Each cell can contain up to 255 characters.
  • The overall file size must not exceed 20MB.
  • SQL Datasets are not supported when using a CSV file as your data source.