Limitations

Geovisualization guarantees data uploads within the following guidelines:

Files with header in only the first row

Files with fields of only letters, numbers and simple string identifiers

The following are not supported and may cause errors or problems:

Non-American short date formats.

Files containing more than 50 columns.

Column headers not in the first row (for instance, comments or other information); these rows must be removed to ensure that the header is the first row. If you use recipe ingestion then you can override this limitation.

Fields containing HTML or other complex formats.

Commas for decimal markers; numbers must have decimal points not commas (for example, numbers formatted such as 54,21 are not supported).

Non-unique column names in headers; each column must have a name that is not a duplicate of any other column name.

Headers that have blank column names; if the table has any columns, then each column must have a name.

Although latitude and longitude are not mandatory, they are required for map visualizations.

Advice

If you receive errors that the formatting of the delimited file is not formatted correctly, then try opening the file in OpenOffice or LibreOffice and resaving it. These applications tend to format delimited files better than Microsoft Office or Google Docs.

The following is an example earthquake dataset containing location information, both latitude/longitude and region names, as well a date-time field and two values for the magnitude and depth of the earthquake: