---
title: Formatting and Validating Datasets.
description: Ensure seamless data validation in Configur. Learn formatting rules for Dates, Numbers, and more to publish accurate datasets every time.
---

[Skip to content](https://help.goconfigur.com/knowledge/formatting-and-validating-datasets#main-content)

English

Show submenu for translations

[Log a Ticket](https://help.goconfigur.com/knowledge/kb-tickets/new?hsLang=en) [Customer portal](https://help.goconfigur.com/helpdesk?hsLang=en)

![Configur Logo-Nov-11-2022-09-01-59-7679-AM.png\]](https://help.goconfigur.com/hs-fs/hubfs/Configur%20Logo-Nov-11-2022-09-01-59-7679-AM.png?height=40&name=Configur%20Logo-Nov-11-2022-09-01-59-7679-AM.png)

Open main navigation

Close main navigation

- English
  
  Show submenu for translations
- [Log a Ticket](https://help.goconfigur.com/knowledge/kb-tickets/new)
- [Customer portal](https://help.goconfigur.com/helpdesk)
- Go to goconfigur.com

 Go to goconfigur.com

 Welcome, how can we help?

- There are no suggestions because the search field is empty.

1. [Configur Help Desk](https://help.goconfigur.com/knowledge?hsLang=en)
2. [Datasets](https://help.goconfigur.com/knowledge/datasets?hsLang=en)
3. [Building Your Dataset](https://help.goconfigur.com/knowledge/datasets?hsLang=en#building-your-dataset)

# Formatting and Validating Datasets.

## Before data can be published, it must pass through a validation layer. This layer checks your raw input against the "rules" of the data type you have assigned. If the format doesn't match the type, the record will be flagged or rejected.

Correct data formatting isn't just about making your spreadsheets look tidy; it is the foundation of data integrity within Configur. When your data is formatted correctly at the source, the platform can successfully validate, categorise, and transform that information into actionable insights.

Improper formatting leads to validation errors, "broken" dashboards, and manual cleanup tasks that slow down your workflow. This manual outlines the specific requirements for each data type supported by the platform.

| Data Type | Description | Key Requirements |
| --- | --- | --- |
| Bool | Logical values | Use standard True/False or 1/0 values. |
| Date | Specific calendar days | **Critical:** Use an exact match format (e.g., YYYY-MM-DD). |
| Email | Electronic mail addresses | Must include `@` and a valid domain (e.g., `.com`). |
| Number | Quantitative values | **Raw numbers only.** No currency symbols or % signs. |
| Phone Number | Contact numbers | Ensure consistent country codes if applicable. |
| Post Code | Geographic identifiers | Standard alphanumeric strings without extra spaces. |
| Text | Qualitative data/Notes | General strings; no specific validation rules. |
| Document | File references/Links | Used for categorizing attachments or file paths. |

### Critical Formatting Rules

To ensure a smooth upload and validation process, pay close attention to these two specific types:

#### 1. Dates: The "Exact Match" Rule

Configur offers multiple date formatting options (e.g., `DD/MM/YYYY` vs. `YYYY-MM-DD`).

- **The Rule:** Your raw data must exactly match the format you select in the configuration settings.
- **Common Error:** Selecting `DD/MM/YYYY` in Configur while your CSV file uses `MM/DD/YYYY` will cause the validation to fail or result in incorrect data being published.

#### 2. Numbers: The "Raw Data" Rule

Configur is designed to handle the "styling" of numbers (like adding currency symbols or percentage signs) **after** the data is uploaded.

- **The Rule:** Raw datasets should contain only integers or decimals (e.g., `1500.50` or `0.75`).
- **Prohibited:** Do **not** include symbols like `$`, `£`, or `%` in your source file.
- **Why?** Including a `%` sign turns a number into a "string" (text), which prevents Configur from performing mathematical calculations like sums or averages.

> **Pro Tip:** If you want a value to appear as 75% in a report, upload it as `0.75` and use the Configur UI settings to apply the percentage formatting.

- [Getting started](https://help.goconfigur.com/knowledge/getting-started?hsLang=en)
- [Datasets](https://help.goconfigur.com/knowledge/datasets?hsLang=en#main-content)

    - [Building Your Dataset](https://help.goconfigur.com/knowledge/datasets?hsLang=en#building-your-dataset)
- [Portals](https://help.goconfigur.com/knowledge/portals?hsLang=en#main-content)

    - [Managing Datasets](https://help.goconfigur.com/knowledge/portals?hsLang=en#managing-datasets)
- [Queries](https://help.goconfigur.com/knowledge/queries?hsLang=en)

[![](https://help.goconfigur.com/hs-fs/hubfs/Configur%20Logo-4.png?width=400&height=84&name=Configur%20Logo-4.png)](http://goconfigur.com)

Copyright © 2026, Configur