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

    • 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 is applicable to the "new" Samples & design view. We recommend using this workflow, but while it still exist, you are welcome to use the "classic" view instead. If you are planning on importing samples, before you follow the ...

    • 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 ...

    • Compusense Release Notes

      Overview With you, our clients, in mind, Compusense is dedicated to continuous improvements in our software functionality and performance. Your success is our success! On this page you will find highlights of the new features implemented in the ...

    • Projective Mapping .r Export

      Overview Projective Mapping data can be exported for analysis in XLSTAT or in SensoMineR. Currently within Compusense we do not have a built in analysis report for the Projective Mapping data. Select the Right Export Options To review what is ...