How to Export CSV Data from Rippling and Import It into clariBI

Rippling unifies HR, IT, and finance operations in a single platform. Exporting your Rippling data as CSV and importing it into clariBI lets you analyze payroll costs, employee demographics, benefits utilization, and workforce trends with AI-powered intelligence.

What You Can Export from Rippling

• Employee directory data (name, role, department, location, start date)
• Payroll reports (gross pay, deductions, taxes, net pay by period)
• Benefits enrollment and cost data
• Time and attendance records
• Compensation history and salary bands
• Headcount and organizational structure data
• Device and app assignment records (IT data)
• Custom report outputs with selected fields

Export CSV Data from Rippling

Method 1: Export from Reports

1. Log in to your Rippling admin account
2. Navigate to Reports from the left sidebar or main menu
3. Select an existing report or click Create Report
4. Choose the data category (e.g., People, Payroll, Benefits, Time & Attendance)
5. Select the fields and filters for your report
6. Click Run to generate the report
7. Click the Export button and select CSV
8. Download the file

Method 2: Export Employee Directory

1. Navigate to People from the left sidebar
2. View the full employee list
3. Apply filters by department, location, employment status, or other criteria
4. Look for the Export button at the top of the employee list, or use the Reports section to run an employee directory report for CSV export
5. Choose CSV as the format
6. Download the exported file with employee details

Method 3: Export Payroll Data

1. Go to Payroll from the left sidebar
2. Select Pay Runs or Payroll Reports
3. Choose the specific pay period or report type
4. Click Run to generate the report
5. Click Export to Microsoft Excel to download the payroll data

Tips for Clean Exports

• Use Rippling's custom report builder to select only the fields relevant to your analysis
• Export payroll data per pay period for granular cost tracking in clariBI
• Include department and location fields in every export for segmented analysis

Import Your Data into clariBI

1. Log in to your clariBI account at claribi.com
2. Click Data Sources in the left sidebar
3. Click the + Add Source button (top right)
4. Under Direct Upload, select CSV File
5. Enter a descriptive name (e.g., "Rippling - Employee Directory Feb 2025")
6. Click the upload area or drag and drop your CSV file
7. Click Create Data Source

Once imported, you can ask clariBI questions like:
- "What is the total payroll cost per department and how has it trended over the past year?"
- "Show me our headcount by location and department with average tenure for each group."
- "What is the benefits enrollment rate by plan type and how do costs vary across departments?"

clariBI's AI will automatically analyze your data and suggest relevant insights.