1. Home
  2. Docs
  3. Knowledge Base
  4. Data Collection and Management
  5. Formatting Data Sources for Import

Formatting Data Sources for Import

Some notes on how to format your data before importing:

  • The structure of different tables that collect the same data should be uniform
  • First line contains (only) the column headers / “headings”
  • No text in number columns, otherwise it cannot be read. Remember this slogan: “You can’t count on text!”
  • Comments, if necessary, must go in a separate column
  • Ensure uniform number formatting: don’t switch between  “xx.xxx,xx” (DE, FR, NL format) and “xx,xxx,.xx”
  • No aggregation formulas in the bottom line (or delete them after the import), otherwise there is a risk that values will be read twice
  • Before saving, check whether the table has been imported correctly; If necessary, clean up the original file and import it again.

For further information on how to get your data set ready for analysis, check out our blog article.

Print Friendly, PDF & Email
Was this article helpful to you? Yes No

How can we help?