Hi Abhinav!
No, your import files don't have to match the export format. You can load data using multiple files – for example, one for simple attributes and others for nested or reference attributes.
What's important is that each file includes a unique identifier (such as an external ID or URI), so Reltio can correctly attach the nested or reference data to the right profile.
Alternatively, you can load all attributes in a single file, and Reltio will process them accordingly. Supported formats include CSV, Excel (.xlsx), and JSON – as shown in the screenshot below.
Keep in mind that when exporting to CSV, there's an option to flatten the format – you'll get one file per entity type, with simple and nested attributes combined in a single row. Because of this structural difference, direct file-to-file comparison is usually not feasible, and some transformation or merging may be needed to align source data with the export.
Hope this helps!
------------------------------
Temenuzhka Gadzheva
Ulpia Tech
------------------------------
Original Message:
Sent: 04-07-2025 13:40
From: Abhinav Kumar
Subject: How to test the initial data migration to Reltio
Thanks for answering, I understand that the data loaded to Reltio - export will be one record per entity of a given entity type for simple and nested attributes.
The import file that we need to provide as a feed to reltio - do that also need to be in similar format or we can have one file for simple attributes and separate files for each nested attributes and reference attributes.
I am just trying to understand if both files has to be in similar format then probably its just two csv files comparison else need to build something to do the comparision
------------------------------
Abhinav Kumar
Travelers
Manchester CT
Original Message:
Sent: 04-07-2025 09:47
From: Temenuzhka Gadzheva
Subject: How to test the initial data migration to Reltio
Hi Abhinav Kumar! Great question - this is a common challenge during large-scale data migrations.
Reltio doesn't currently offer a built-in utility to automatically compare source data from an external platform with the data loaded in Reltio (whether that's via Data Loader, SnapLogic, or another integration method). The usual approach is to handle this externally, by exporting the loaded data from Reltio and comparing it with your original source files.
You can export the data using the Reltio Export API or through the Reltio Console. The export format aligns with your data model and supports CSV, JSON
- You'll get one file per entity type
- Simple and nested attributes are included in the same file
- Reference attributes show up as IDs or URIs, or in separate files if modeled as relationships
- Each record includes its crosswalks (source system + source ID), which makes it easier to match against your source data
Тhere isn't an automated comparison tool within Reltio, so post-load validation typically involves comparing exports to your original data, using crosswalks to align records.
Hope this helps - happy to share more tips if needed!
------------------------------
Temenuzhka Gadzheva
Original Message:
Sent: 04-03-2025 20:57
From: Abhinav Kumar
Subject: How to test the initial data migration to Reltio
I have more than 50 million records that will be loaded to Reltio as part of initial data migration from other platform, How do I do data comparison between source data and data loaded to Reltio.
In this I want to know if any utility exists or its just export of data ? if its just export -what would be format of export - will it be on line of data model (Simple attributes at entity level in one file and one file each for each of nested attribute , separate file for reference attribute?
------------------------------
Abhinav Kumar
------------------------------