Upload a CSV File

If you are a trial user, you have the option to upload a CSV file that will act as a data source. Please note, 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.

You are able to upload only one CSV file at a time for the whole organization, which will be reusable across all workspaces and by all users within the organization.

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 ,

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.
Improve Performance