Limpiar y transformar datos
Clean and transform data online: normalize fields, remove noise, apply filters and save processing rules.
Data cleaning Datos → Reglas
The production workflow is configured in the account: upload sources, define rules, check the result and save a profile.
Configura reglas de limpieza y transformación
La landing puede explicar el escenario, pero las fórmulas, filtros y cambios de valores reales deben guardarse en un perfil.
Registrarse y configurar →Add files or recurring data sources.
Define mapping, filters, transformations and duplicate checks.
Check output and rerun the workflow.
- filtros y condiciones
- fórmulas y transformaciones de valores
- vista previa y ejecuciones repetidas
¿Necesitas transformaciones, no solo cambiar el formato?
Regístrate si necesitas cambiar valores en celdas, redimensionar y convertir imágenes, o filtrar la exportación solo por los elementos necesarios.
What data cleaning and transformation means
Data cleaning is needed when a file can be read but is not ready for import: inconsistent field names, HTML in descriptions, empty values, extra rows and mixed price or date formats.
When you need it
When manual file editing becomes slow and error-prone.
What Eofferix does
The service saves processing rules and applies them to repeat files.
Why profile matters
A profile keeps output structure, filters, mapping and delivery.
Data cleaning example
The example shows the basic output logic. A profile can add more rules and checks.
Before
raw data| sku | title | price | active |
|---|---|---|---|
| SKU-001 | <b>iPhone 15</b> | 999 USD | yes |
| SKU-002 | Samsung S24 | 899 USD | no |
After
clean data| sku | name | price | active |
|---|---|---|---|
| SKU-001 | iPhone 15 | 999 | true |
When you need data cleaning
The tool is useful for catalogs, price lists, stock data and recurring supplier files.
Supplier catalogs
Bring different structures to one model.
Price lists
Normalize prices, names and SKUs.
Stock data
Filter and update product availability.
CMS/ERP import
Prepare files for receiver requirements.
Quality control
Check output before recurring runs.
Recurring workflows
Repeat processing without manual setup.
Common workflow setup mistakes
Problems appear when field, filter, duplicate and value-type rules are not defined upfront.
No unified model
Different sources need field rules.
Duplicates not defined
One product can arrive from several files.
No filters
Extra rows reach output.
Types not normalized
Prices, dates and active flags are read differently.
No preview
Errors are noticed only after import.
No rule version
Source changes become harder to diagnose.
Eofferix or manual processing
Manual work fits one file. Repeat workflows are better handled with saved rules.
| Method | Pros | Cons |
|---|---|---|
| Manual editing | Fast for one file. | Error-prone and hard to repeat. |
| Script | Flexible for technical teams. | Needs maintenance, logs and error handling. |
| Eofferix | Profiles, preview, rules, large files and schedule. | Workflow needs initial setup. |
Safety and production limits
Eofferix creates separate output and helps repeat processing without manual source edits.
Sources stay unchanged
Output is created separately.
Up to 2 GB after signup
Fits large production files.
Rule profiles
Mapping and filters are saved.
Preview
Check before running.
Delivery
Email, FTP/SFTP, webhook and other channels.
Free plan
Start without buying a plan.
Other Eofferix tools
Eofferix also helps with format conversion and integration-ready files.
How to clean and transform data
Upload sources
Add files or recurring data sources.
Configure rules
Define mapping, filters, transformations and duplicate checks.
Save the profile
Check output and rerun the workflow.
What data cleaning supports
Field mapping
Bring different column and node names to one model.
Filters
Keep only required products, categories, stock records or rows.
Transformations
Normalize text, prices, dates, empty values and active flags.
Preview
Check output before saving a profile.
Repeat runs
Use one workflow for recurring files.
Result delivery
Send output to the required channel.
Tool FAQ
Clean data and save processing rules
Create a profile, check output and rerun the workflow.
Registrarse y configurar → Up to 2 GB after signup · free plan · no software install