Can Data Fabric Create Entity Fields Automatically from CSV/Excel During Import?

Help Data Service
,
1

Hi Everyone,

I am currently exploring UiPath Data Fabric and had a question regarding entity creation and data import.

From my understanding, when importing data into a Data Fabric entity using a CSV file, the entity fields (columns) must already exist and the CSV column names must match the entity field names. The import process then adds the records to the existing entity.

My use case involves importing large datasets where the structure may contain hundreds of columns. Creating all the fields manually can be time-consuming.

My questions are:

  1. Is there any way to import a CSV or Excel file and have Data Fabric automatically create the entity fields based on the file columns?
  2. Has anyone implemented a workaround to dynamically generate entity fields from a file schema?
  3. Would Schema Import be the only supported approach for creating entities and fields in bulk?
  4. Has anyone used Autopilot, APIs, or custom automation to generate entity structures before importing data?

I reviewed the documentation and found that CSV import requires the entity fields to already exist and that column names must match the entity fields.

I would appreciate any guidance, best practices, or alternative approaches from the community.

Thank you!

2

Not possible at least for now. We will have to create the fields manually.

This is the best approach if you are going to do it frequently

I had tried autopilot but it failed to do it as expected. It could be due to the prompt I was using or something but give it a try.

3

Hi @Gaurav_Sonawane,

As far as I know, Data Fabric CSV import does not automatically create entity fields from the CSV columns. The entity and its fields need to be created first, and then the CSV columns should match the existing field names.

If you have hundreds of columns, creating them manually can definitely be time-consuming. In that case, Schema Import or an API-based approach could be worth considering to automate the entity/field creation.

You could also build a small UiPath workflow that reads the CSV/Excel headers and uses the appropriate API to create the required fields before importing the data.

I would also recommend checking the current Data Fabric API capabilities and supported schema import options, as these may be better suited for large or dynamic schemas.

Hope this helps!