Data Formatter
Format a list of text lines with a chosen transformation. Convert to UPPERCASE, lowercase, Title Case, camelCase, snake_case, or kebab-case. Trim whitespace and collapse extra spaces. Live preview, one-line-per-row output.
What Is Data Formatting?
Data formatting is the process of converting text into a consistent pattern — changing case, removing extra spaces, joining or separating words. It is essential for making data usable in databases, code, spreadsheets, and forms.
Different contexts require different formats. Database column names usually use `snake_case`. Programming variables use `camelCase` or `snake_case` depending on language. URLs and CSS classes use `kebab-case`. Display names use Title Case. This tool handles all of them.
Format Types Explained
- Title Case — Every Word Starts With a Capital Letter ("John Doe")
- UPPERCASE — ALL CAPS ("JOHN DOE")
- lowercase — all lower ("john doe")
- Sentence case — First letter capital, rest lower ("John doe")
- camelCase — First word lower, subsequent words capitalized, no spaces ("johnDoe")
- PascalCase — All words capitalized, no spaces ("JohnDoe")
- snake_case — Lowercase words separated by underscores ("john_doe")
- kebab-case — Lowercase words separated by hyphens ("john-doe")
- CONSTANT_CASE — Uppercase words separated by underscores ("JOHN_DOE")
Worked Examples
Input line: " john doe " (extra spaces, lowercase)
- Trim + collapse + Title Case →
John Doe - Trim + collapse + camelCase →
johnDoe - Trim + collapse + snake_case →
john_doe - Trim + collapse + kebab-case →
john-doe - Trim + collapse + CONSTANT_CASE →
JOHN_DOE
Each row is processed independently and output as one line per row, preserving the row order.
Common Uses
- Database column names — convert "First Name" to
first_namefor SQL tables - Programming variables — convert "user id" to
userId(camelCase) oruser_id(snake_case) - URLs and slugs — convert "My Blog Post Title" to
my-blog-post-title(kebab-case) - CSS class names — convert "Button Primary" to
button-primary - Customer list cleanup — trim spaces, standardize case ("JOHN DOE" → "John Doe")
- Email list normalization — convert all to lowercase for consistent matching
- Data import preparation — match the target system's naming convention
Frequently Asked Questions
What is the difference between camelCase and PascalCase?
camelCase starts with a lowercase letter ("johnDoe"); PascalCase starts with an uppercase letter ("JohnDoe"). Both remove spaces and capitalize subsequent words. camelCase is more common for variables and function names in Java, JavaScript, and C#. PascalCase is used for class names and public properties in those languages.
When should I use snake_case vs kebab-case?
snake_case (with underscores) is common for database columns and Python variable names. kebab-case (with hyphens) is common for URLs, CSS class names, and HTML attribute names — because hyphens are not allowed in most programming variable names but are fine in URLs and CSS. The choice depends on the convention of the language or platform you are targeting.
What does "collapse extra spaces" do?
It replaces any sequence of two or more spaces with a single space. "John Doe" becomes "John Doe". This is useful when data has been copied from web pages or PDFs, where extra spaces often creep in. Note: "trim" only removes leading and trailing spaces; "collapse" handles internal spacing.
Can I format numbers or dates?
No — this formatter works on text. Numbers are preserved exactly as entered. If you need to format numbers (add commas, round to decimal places, format as currency), use the Number to Words Converter or the various financial calculators. If you need date formatting, use the Excel Date Difference Calculator, which handles date arithmetic.
Does the formatter handle special characters?
Special characters (accents, symbols, non-Latin scripts) are preserved. However, for camelCase and snake_case conversions, only spaces are used as word separators — special characters stay in place. For "José María" with camelCase, the result is "joséMaría" (accents preserved). For non-Latin scripts (Chinese, Arabic), case conversion has no effect, but spacing and formatting still apply.
Is my data private?
Yes — everything runs in your browser. Your data is not sent to any server, not stored, and not shared. When you close the tab, the data is gone. Copy or download the formatted output before closing the tab if you need to keep it. This is especially important for sensitive data like customer names or internal database schemas.