Thematic data formats

Thematic can accept .xlxs and .csv files. Each row should contain one or more free-text responses you'd like analyzed, as well as any additional information about the response you can provide, (eg. Date of response, NPS score or Response segment). Files can have headers at the top, or if not you should alert your Thematic contact what each row refers to.

If you're uploading an excel file the data you wish to analyze must be in the first sheet.

If you have a column you'd like to be treated as a metric, providing it as a number in an additional column can reduce your processing time (eg. Provide NPS as a 0-10 instead of Detractor, Passive or Promoter. Or providing First Contact Resolution 1 = Yes or 0 = No). 

How to prevent data corruption

Opening a file in Excel has been known to cause issues with foreign characters and date formats. If at all possible avoid opening and saving a file in Excel before sending it to Thematic. If your file needs basic modification talk to your contact at Thematic to see if we can automate the edits for you.

Future uploads

You can upload additional data to an existing dataset and Thematic can process and add it automatically if it's configured correctly. Talk to your contact at Thematic about the frequency of future uploads to make sure the system is set up to accept new data. Thematic will have trouble automatically processing your data files if there's changes to the format, eg. column order or header name changes. Avoid these changes if possible and if it has to be changed alert your Thematic contact so they can prepare the system in advance to reduce turn around time.

Still need help? Contact Us Contact Us