Skip to main content

TROUBLESHOOTING: Importing Graph Values

Can't upload values to a graph, upload errors

Oliver Zdravkovski avatar
Written by Oliver Zdravkovski
Updated yesterday

CSV means comma separated value. All spreadsheets apps like Excel, Numbers and Google Sheets can export CSV files.

Trouble importing graph values can occur for these reasons:

  • Corrupted CSV file - CSV files sent via email or chat systems can be corrupted during transmission. Try opening a corrupted file in a spreadsheet app and export to CSV, or request the original spreadsheet file and covert that. Alternatively, using a file transfer service like dropbox or google drive with avoid file corruption.

  • Incorrect file format - the file type must be CSV. When using Excel ensure the correct CSV format is used. See screenshot below.

  • Incorrect field names - field names are case sensitive, they must appear exactly as shown in Full List of Graph Import Fields

  • Incorrect data - Values must contain ONLY numbers and decimals points. Remove all commas, currency symbols and letters. (e.g. $2,000.00 is invalid, 2000.00 is valid).

  • Incorrectly formatted date - Use yyyy-mm-dd, e.g 1st Jannuary 2021 is 2021-01-01

  • Missing Graph ID - This is a required field.

For more information on Graph Import, see Import Graphs - Example.

Excel - Correct CSV Export

If you still run into trouble, reach out to support via the chat below.

Did this answer your question?