A Glossary of Technical File Formats & Scripting Basics for HR & Recruiting

In today’s fast-paced HR and recruiting landscape, data drives decision-making and automation fuels efficiency. Understanding the technical backbone of your operations—from how data is structured to how systems communicate—is no longer just for IT. This glossary demystifies key technical file formats and scripting basics, empowering HR and recruiting leaders to navigate their tech stacks with confidence, optimize automation workflows, and ensure robust data management practices. Dive in to build your technical fluency and unlock new possibilities for streamlined talent acquisition and HR administration.

CSV (Comma Separated Values)

CSV is a plain text file format that stores tabular data in a structured way. Each line in the file is a data record, and each record consists of one or more fields, separated by commas. For HR and recruiting professionals, CSV files are incredibly common for exporting and importing candidate lists, employee data, payroll information, or applicant tracking system (ATS) reports. They provide a simple, universal method to transfer data between different software applications or to perform bulk updates, making them indispensable for managing large datasets without complex integrations.

JSON (JavaScript Object Notation)

JSON is a lightweight, human-readable data-interchange format, commonly used for sending data between a server and web applications. It structures data as key-value pairs, similar to a dictionary or object, and supports arrays (lists of items). In HR technology, JSON is the prevalent format for APIs, allowing systems like an ATS, HRIS, or a background check service to exchange complex candidate or employee information programmatically. Understanding JSON helps HR leaders grasp how real-time data flows are managed between disparate systems in their automation efforts.

XML (Extensible Markup Language)

XML is a markup language that defines a set of rules for encoding documents in a format that is both human-readable and machine-readable. It uses tags to define elements and attributes to describe data, allowing for highly structured and hierarchical data representation. While less common than JSON for modern web APIs, XML is still widely used in older enterprise systems, data feeds for job boards, or for specific data integration scenarios within HR, such as transmitting large batches of compliance data or talent profiles between legacy systems.

API (Application Programming Interface)

An API is a set of defined rules and protocols that allows different software applications to communicate and interact with each other. Think of it as a waiter in a restaurant, taking your order (request) to the kitchen (another application) and bringing back your food (data). For HR and recruiting, APIs are fundamental to building an interconnected tech stack. They enable your ATS to integrate with a background check service, your HRIS to sync with a payroll system, or your internal tools to pull candidate data, reducing manual data entry and enabling seamless automation workflows.

Webhook

A webhook is an automated message sent from an application when a specific event occurs. Unlike a typical API call where one system actively requests data from another, webhooks are “push” notifications. For example, when a new candidate applies in your ATS, the ATS can immediately “push” a webhook notification to your automation platform (like Make.com). This instantly triggers a subsequent action, such as sending a personalized email, updating a spreadsheet, or creating a task in your project management system, making real-time, event-driven automation possible in recruiting workflows.

Scripting Language

A scripting language is a programming language designed to automate tasks within a software environment. Unlike compiled languages, scripts are typically interpreted line by line during runtime. Languages like Python or JavaScript are common scripting tools. In HR, while you may not write scripts daily, understanding their purpose is crucial. They are used behind the scenes for data cleaning, custom report generation, automating repetitive administrative tasks, parsing resumes for specific keywords, or creating custom integrations that go beyond standard API capabilities, significantly enhancing operational efficiency.

Data Parsing

Data parsing is the process of extracting specific pieces of information from a larger block of text or data, often transforming it into a more structured, usable format. For HR professionals, this is critically important when dealing with unstructured data like resumes, cover letters, or open-ended survey responses. AI-powered parsing tools can extract candidate names, contact information, skills, and work history, converting them into structured fields in an ATS or CRM. This automation dramatically reduces manual data entry, speeds up candidate screening, and improves the accuracy of candidate profiles.

Data Normalization

Data normalization is the process of structuring a database or data set to reduce data redundancy and improve data integrity. It involves organizing data fields and tables to ensure that each piece of information is stored in only one place, in a consistent format. For HR data, this means ensuring that job titles, department names, or location codes are standardized across all systems (e.g., “Software Engineer” not “SE” or “Software Dev”). Normalized data is essential for accurate reporting, reliable analytics, and efficient data exchange between different HR systems, preventing errors and inconsistencies.

ETL (Extract, Transform, Load)

ETL stands for Extract, Transform, Load, a three-phase process used to integrate data from multiple sources into a data warehouse or another destination system. First, data is **Extracted** from various sources (e.g., ATS, HRIS, payroll). Then, it’s **Transformed** to fit the target system’s schema, which might involve cleaning, standardizing, or aggregating data. Finally, the transformed data is **Loaded** into the destination. ETL is critical in HR for large-scale data migrations, building consolidated reporting systems, or preparing data for advanced analytics, ensuring data quality and usability across your entire organization.

Database

A database is an organized collection of structured information, or data, typically stored electronically in a computer system. It is designed to efficiently store, retrieve, modify, and manage data. For HR and recruiting, databases are the backbone of virtually all software: ATS platforms store candidate profiles and application statuses; HRIS systems house employee records, benefits, and payroll data; CRM systems manage client interactions. Understanding that a database is the central repository for your critical HR data underscores the importance of data integrity, security, and proper management.

SQL (Structured Query Language)

SQL is a standard programming language used to manage and query data in relational databases. It allows users to create, read, update, and delete data within these databases. While HR professionals typically interact with database information through a user interface, understanding SQL’s role is important for advanced reporting and custom data extraction. HR analysts or operations teams might use SQL queries to pull specific datasets for compliance audits, generate custom dashboards on hiring metrics, or identify trends that go beyond standard system reports, providing deeper insights into workforce data.

Automation Workflow

An automation workflow is a series of interconnected, automated steps designed to achieve a specific business process or task without manual intervention. It involves defining triggers, actions, and conditional logic that dictate how data and tasks flow between different systems or stages. In HR and recruiting, automation workflows are transformative: onboarding new hires, managing offer letters, scheduling interviews, or sending follow-up communications can all be automated. These workflows reduce human error, save significant time for HR teams, and ensure consistency in talent management processes, allowing your team to focus on strategic initiatives.

Cloud Storage

Cloud storage is a model of computer data storage where digital data is stored in logical pools, typically across multiple servers, rather than directly on a local device. The physical environment is owned and managed by a third-party cloud provider, and users access their data over the internet. For HR, cloud storage is ubiquitous, supporting platforms like Google Drive, Dropbox, or integrated HRIS solutions. It ensures that sensitive HR documents, candidate resumes, and employee records are securely backed up, accessible from anywhere, and scalable to meet growing data needs, enhancing collaboration and disaster recovery.

Data Security/Encryption

Data security refers to the protective measures applied to prevent unauthorized access, corruption, or theft of data throughout its lifecycle. Encryption is a key component of data security, converting data into a code to prevent unauthorized access. For HR and recruiting, protecting highly sensitive personal information—like Social Security numbers, health records, and financial details—is paramount for compliance (e.g., GDPR, CCPA) and maintaining trust. Implementing robust data security practices, including strong encryption for data at rest and in transit, is non-negotiable to safeguard employee and candidate privacy and avoid costly breaches.

Integrations (Software Integration)

Software integration is the process of enabling different software applications to communicate and work together as a cohesive unit, rather than operating in silos. This is achieved through APIs, webhooks, or custom scripting. In HR and recruiting, strategic integrations are crucial for creating a seamless tech ecosystem: connecting your ATS to your HRIS, payroll system, background check provider, or even a specialized AI tool. Effective integrations eliminate manual data entry, reduce duplicate efforts, improve data consistency, and create end-to-end automated workflows, saving valuable time and reducing operational friction.

If you would like to read more, we recommend this article: The Essential Guide to Keap Data Protection for HR & Recruiting: Beyond Manual Recovery