Skip to main content

The Data Story Guide Academy is Now Live! Get Certified in Data Storytelling. Go to Academy >>

The Data Story Guide Help Center home page

Search

About Subscribe Software Sign up for free courses
  • Search

  • Sign up for free courses
The Data Story Guide Academy
Explore Academy About Sign up
  • Sign up
  1. The Data Story Guide
  2. Data Files

Data Files

How to create and obtain data files, common file formats, what good data looks like

Creating or Obtaining a Data File

  • Ways of Creating/Obtaining a Data File
  • Obtaining a Data File From Another Person or Organization
  • Creating a Flat File Using a Spreadsheet
  • Creating Data Files via Database Queries (e.g., SQL)

Common Data File Formats

  • Overview of Data File Formats
  • Relational Database
  • Flat Data File
  • Fixed-Width File
  • Tab Delimited Text File
  • Comma-Delimited File
See all 19 articles

Characteristics of a Good Data File

  • Data in a Rectangular Shape, with Appropriate Cases and Varibles
  • Variables are Stored in the Data Set Consistently with their Variable Type
  • The Data File Contains a Unique Identifier (ID Variable)
  • Missing Values are Stored Appropriately
  • Categorical Variables Contain a Complete List of Useful Value Labels
  • Randomizations and Rotations Have Been Removed
See all 14 articles
  • About
  • Academy
  • Created by Displayr
  • Privacy
  • Terms
  • Contact Us
  • Software
  • About
  • The Data Story Guide
  • Created by Displayr
  • Privacy
  • Terms
  • Contact Us
Powered by Zendesk