Saving Files in a .csv Format

Saving Files in a .csv Format

Overview

Working in Compusense means that sooner or later you will need to import a .csv file to meet some of your testing needs. It could be that you need to import panelists or a custom design.

We find that, depending on you MS Excel settings, when saving your work in a .csv format, confusing messages can sometimes be displayed. These in return can make saving .csv files somewhat challenging. 

In this workflow, we will show you how to properly save Excel files in a .csv format. Although indirectly related to our other workflows, these steps are applicable even when you are not working with Compusense.

Your Excel settings may not be displaying any messages when saving files in a .csv format. This workflow is intended only for those users who are presented with messages described in this workflow when attempting to save files in a .csv format.  

Scenario:   Let's suppose that you need to create a custom design (Experimental Plan) for your upcoming test. The design needs to be saved as a .csv file in order to import it into Cloud.

Our focus in this workflow is on saving the file as a .csv, it is not how to create and import the design.


Saving .csv Files

  1. Open the file you wish to save as a .csv file.  
  2. Select  File > Save As  and select a folder where you wish to save the file.  
  3. From the  Save as type  list, select the   CSV (Comma delimited)  option and update the file name, if necessary. 
  4. Click  Save  . 
  5. When prompted with the message as seen in the image below, click   Yes  . 



  6. Close the file. You may be presented with another message similar to the one in the image below: 

      
  7. Click   Don't Save   because you already saved the file. 

Here is a quick animation of the process. 





    • Related Articles

    • Saving Files in a .dat Format

      Overview Most of file imports and exports handled in Compusense are done using a .csv file format. However, some file imports require .dat file format in order to preserve special characters that the .csv file format is not able to preserve. For ...

    • Sample List: Import Samples from a .csv file

      Overview The Sample List library provides multiple ways for adding samples so that they can be evaluated at a later time. On this page we will focus on the steps for importing samples from a .csv file. This workflow is useful for all users that are ...

    • Samples & Design: Edit Samples

      Overview This workflow will help you navigate through the sample editing process. If you are planning on importing samples, before you follow the steps to edit them, export the existing list of samples by selecting Samples > Export (.csv). or Select ...

    • Import Products from a File

      Overview When importing products, it is important to format the file properly and to use unique product codes to ensure successful import. To assist you with these requirements, we made it easier by providing example import files that directly ...

    • Rewards Codes

      Overview Manage Rewards Manage Codes Manage Notifications Customize Panelist View Overview What Are Rewards? The Rewards feature compliments the Incentives feature. Panelists need to have a points balance in order to be able to redeem their points by ...