How to Choose a Column

How to Choose a Column

This article will help you in choosing the correct column after uploading the CSV file containing text data.


Once you uploaded the CSV file which contains the data coming from different sources like Playstore, Support Tickets, Emails, Tweets, Facebook posts, we will show a preview of your data to avoid any errors.

And in the next step, you have to choose the column on which you want to run text analytics. In case the file only has text data in one column, then you have to click on Next button and wait for some time till you get a success message.

Note: Just uncheck the Exclude First row if the first row of the file doesn't contain the names of the column.

In case, the file uploaded by you contains many columns, then you have to choose the column on which you want to run Text Analytics. Lets take the example of Playstore reviews to understand this point in more detail.

In the below image, there are 5 columns which contains unique id, date, ratings, user reviews and user name. You can identify that the column user reviews contain the text data i.e. feedback given by users.

So you have to choose this column for running text analysis to get an idea what your users are actually talking about your product and services.

    • Related Articles

    • How to Upload Data

      his article will help you in uploading the CSV file containing text data. Before uploading data for doing text analytics, you need to collect your customer data in CSV format. The CSV file must contain text data coming from different sources. Sources ...
    • How to add multiple Languages in your Surveys

      This article will guide the users in using the Translation Feature and creating Multilingual Surveys in SurveySensum SurveySensum gives its users the option to create a multilingual survey. The user can use a single survey to reach out to people who ...
    • How can you use the DIY Dashboard?

      The DIY Dashboard is a solution from our side to solve your hassle of sharing multiple responses from different surveys with your teams in screenshots and multiple PowerPoint presentations.  With this Dashboard, you can collate all the responses ...
    • What is Metadata and when it is used?

      Metadata is an additional property that we can embed in the survey. It is received along with the response from the user and makes tracking easier in case of anonymous responses. Create a new property by clicking on "Add metadata" button. The left ...
    • Share Survey Via Email

      After creating your survey, your survey is ready to be shared! Let us see how we can share the survey via email. Click on Send Email and you will direct to the Email Campaign. Enter the following details based on your requirements: From Name: Enter ...