Data Analyst Tools

Extract structured values from text

Paste the source text, choose the options that match its format, and check the result before using it elsewhere.

• Date Extractor: Set Output mode to List (dates only), Harmonize (rewrite text), Table (context view), CSV, or JSON. Choose a Date format, select a Sort order, and use Unique dates only when repeated dates should appear once. For dates such as 03/04/2024, enable Interpret ambiguous numeric dates as DD/MM if that is the intended reading.
• Phone Number Extractor: Choose a Region, then select a value under Standardize to, such as As found, E.164 (+1XXXXXXXXXX), or Digits only. The available format affects how extracted numbers are written.
• Number Extractor: Use Include decimals, Allow comma as thousands separator (6,500), and Include negatives for the numeric forms in your input. Turn on Unique only, One per line, or Include embedded numbers as needed.
• Extract Lines Containing: Enter a word, phrase, or pattern. Use Case sensitive, Use regex, or Invert (exclude matching lines) to control which lines remain.
• Extract Emails and Extract URLs are the focused choices when you need those value types from mixed text.

Clean duplicate and empty lines

Use these tools after extraction when the result contains repeated records or blank rows.

• Remove Duplicate Lines: Paste one line per record. Enable Case sensitive when letter case should distinguish lines, and keep or clear Trim spaces before comparing depending on whether surrounding spaces should matter.
• Remove Empty Lines: Paste or upload the text to remove empty lines. Check the output before passing it to another line-based tool.

Compare text and analyze content

• Compare Text: Paste the original and modified text into the two inputs. Under Diff level, choose Word, Line, or Character; Word is active by default. Enable Ignore case or Ignore extra whitespace when those differences should not count.
• Text Analyzer: Paste or upload text to view Words, Characters, Chars (no spaces), Sentences, Paragraphs, Lines, Unique Words, Syllables, reading time, speaking time, Flesch Reading Ease, and keyword information.
• Keyword Density: Paste the text, choose Phrase length for 1-word keywords, 2-word phrases, or 3-word phrases, and set Show top to 10, 20, 30, or 50. Enable Include stop words when common words should be included.

Use a simple processing workflow

1. Paste or upload the source text in the linked tool.
2. Extract the value type or matching lines you need.
3. Clean repeated or empty lines if the result is line-based.
4. Compare the cleaned text, count it, or inspect keyword frequency.
5. Copy or download the result when that action is available, then review it against the source.

Limitations and input checks

These tools use the patterns and settings exposed by each interface. Extraction may miss or misread unusual input, so check results before treating them as a complete dataset.

• There is no explicit maximum input size or performance limit documented on this collection page. Very large inputs should be tested in the selected tool.
• Ambiguous numeric dates need the Interpret ambiguous numeric dates as DD/MM setting when day-first interpretation is required.
• Phone formatting depends on the selected Region and Standardize to value.
• Numeric identifiers such as A123 may be excluded unless Include embedded numbers is enabled.
• Use regex changes how Extract Lines Containing matches lines, so review the pattern and output.
• The local files do not establish complete edge-case coverage for email, URL, date, phone, or number parsing. Do not assume every unusual format will be detected.

Frequently asked questions