HOW TO PREPARE A FILE FOR A QUICKSTUDY ?

The mandatory rules for a file to upload in a quick study are:

  • Have an excel (.xls or .xlsx) or .csv file.
  • Have a matrix file.
  • Have an unique header.
  • Have the same date format in a column so it's mandatory to have a date column !
  • Avoid durations written as this: 2min45, 1h30. Use 2,75, 1,5.
  • Avoid the formula. Copy and "Paste the values".

You can find a resume of the recommandations on the download tab (on the left).

Note : There are some limitations about the size of the files you can import:

  • Maximum number of cells for an xls(x) file :3_553_200;
  • Maximum number of cells for a csv file: 400_000_000;
  • Maximum number of columns for an xls file: 256;
  • Maximum number of columns for an xlsx file: 16_384;
  • Maximum size of the file : 1GB

Was this article helpful?

Powered by Zendesk