Data Formats Flashcards
The way data is stored on a computer. Understanding the data format will determine how you access and import data to your BI tool or spreadsheet.
Tabular data separated by commas.
CSV (Comma Separated Value)
Text based with no formatting or tags. It can be delimited (separated) by anything.
TXT
Proprietary spreadsheet file format created by Microsoft Excel.
XLSX
Text-based open standard designed for human-readable data interchange.
JSON (JavaScript Object Notation)
A file that is stored as raw text but has a markup language to denote basic formatting such as bold, underline, etc.
RTF (Rich Text Format)
A hierarchy-based markup language that uses user-defined keywords to tag data.
XML (Extensible Markup Language)
What is CSV an abbreviation of?
Comma Separated Value
What is JSON an abbreviation of?
JavaScript Object Notation
What is RTF an abbreviation of?
Rich Text Format
What is XML an abbreviation of?
Extensible Markup Language
Give an example of in which programmes CSV is compatible
Excel, Google Sheets, Power BI, Tableau, Google Data Studios, Python, TextEdit, Notepad
Give an example of in which programmes TXT is compatible
TextEdit, Notepad, Python
Give an example of in which programmes XLSX is compatible
Excel, Google Sheets, Power BI, Tableau, Python
Give an example of in which programmes JSON is compatible
Power BI, Tableau, Python
Give an example of in which programmes RTF is compatible
Microsoft Word, Google Docs.
