Changelog

Full version history of DataVista Tools. Updated with every release.

Merge PDF

Combine multiple PDF files into a single document. Drag to reorder pages before merging.

How to use

1. Upload files — drag & drop or click the upload area. Select multiple PDFs.
2. Reorder — drag file cards to set the merge order.
3. Merge — click the Merge PDFs button.
4. Download — save the merged PDF to your device.

Limits

• Up to 20 PDF files per merge
• Maximum 50 MB per file

Web URL & Data Extractor

Extract all URLs from websites, sitemaps, or HTML source — in single or bulk mode. Export to CSV, Excel, or copy directly for Sheets.

Three Modes

1. Sitemap / URL Mode

Enter any URL (sitemap or regular page). The tool fetches the content via a CORS proxy and extracts all <loc> tags (for XML sitemaps) or all href and src attributes (for HTML pages).

2. Paste HTML / Text Mode

Open the target page in your browser, right-click → View Page Source, select all (Ctrl+A), copy, and paste into this tool. All https:// and http:// URLs are extracted automatically.

3. Bulk URL List Mode

Paste a list of URLs (one per line). The tool parses each URL into structured columns: domain, path, query string, and file type. Useful for auditing existing URL lists or preparing data for analysis.

Exporting Results

• Copy for Sheets — copies tab-separated data. Paste directly into Google Sheets or Excel — columns appear automatically.
• CSV — comma-separated file, importable in any spreadsheet tool.
• Excel (.xls) — tab-separated with UTF-8 BOM, opens cleanly in Excel.
• Copy URLs only — plain list of URLs, one per line.

AI Tools

A complete toolkit for working with AI platforms — 300+ prompt templates, a structured prompt builder, token estimator, and platform guides for ChatGPT, Gemini, Claude, DeepSeek, and more.

Prompt Library

44+ categorized prompt templates across Writing, Coding, SEO, Marketing, Analysis, Education, Productivity, Media, Creative, and Business. Search by keyword or filter by category. Click any platform icon to filter prompts for that platform.

Prompt Builder

Build structured prompts by filling in: Role/Persona, Task/Goal, Context, Output Format, Tone/Style, Language, and target Platform. The generated prompt updates live and can be copied in one click.

Token Estimator

Paste any text to estimate its token count across 13 AI models. Useful for checking if your prompt fits within a model's context window before sending. Includes a reference table of context window sizes for all major models.

Platform Guides

Detailed guides for 8 AI platforms with features, pro tips, pricing, and direct links. Click any platform pill in the hero to filter the prompt library for that platform.

Bulk File Renamer

Rename multiple files in bulk using stacked rules. Preview all changes before downloading.

Available Rules

• Find & Replace — replace text in filenames, with optional case-sensitivity
• Prefix / Suffix — add text before or after the filename (before extension)
• Case Change — lowercase, UPPERCASE, Title Case, kebab-case, snake_case
• Auto Numbering — add sequential numbers as prefix, suffix, or replace the entire name
• Trim & Remove — remove leading/trailing spaces, collapse multiple spaces, replace spaces with _ or -

Downloading

Click "Download All as ZIP" to get all renamed files in a single ZIP archive. Or use "Copy rename list" to get a text list of original → new name mappings.

Brand Name & Username Generator

Enter a brand name and instantly generate compliant usernames for 14 social platforms, plus domain suggestions.

Supported Platforms

Instagram, X/Twitter, YouTube, TikTok, LinkedIn, Facebook, GitHub, Twitch, Discord, Telegram, Snapchat, Pinterest, Reddit, Medium.

How it works

Each platform has different rules: character limits, allowed characters (letters, numbers, dots, underscores, hyphens), and minimum lengths. The tool automatically adapts your brand name to each platform's rules — removing invalid characters, truncating if necessary, and flagging when the result is too short to be valid.

Domain Suggestions

12 TLD suggestions are generated (.com, .io, .co, .net, .org, .app, .dev, .studio, .media, .online, .site, .store). Each links directly to Namecheap to check availability.

Formula Guide & Search

Searchable reference for 80+ Google Sheets and Excel formulas with syntax, examples, and one-click copy.

Categories

• Lookup — VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP, CHOOSE, OFFSET
• Text — TRIM, CLEAN, LEFT, RIGHT, MID, LEN, FIND, SUBSTITUTE, UPPER, LOWER, PROPER, TEXTJOIN, SPLIT, REGEXEXTRACT
• Math — SUM, SUMIF, SUMIFS, ROUND, ABS, MOD, POWER, SUMPRODUCT
• Date & Time — TODAY, NOW, DATE, YEAR, MONTH, NETWORKDAYS, EDATE, DATEDIF
• Logic — IF, IFS, AND, OR, NOT, IFERROR, IFNA, SWITCH
• Statistics — COUNT, COUNTIF, AVERAGE, MAX, MIN, MEDIAN, RANK, LARGE
• Info — ISBLANK, ISNUMBER, ROW, COLUMN, UNIQUE, SORT, FILTER

Sheets Data Tools

Practical browser-based tools for everyday spreadsheet data cleaning tasks.

Available Tools

• Trim & Clean — Remove leading/trailing spaces, collapse multiple spaces, strip invisible characters. Equivalent to =TRIM(CLEAN(A1))
• UPPER/LOWER/PROPER — Bulk case conversion across a pasted column of values
• Remove Duplicates — Get unique values from a pasted list, with optional sort and case-insensitive mode
• CSV ↔ Paste Converter — Convert between CSV and tab-separated format for correct paste behavior in spreadsheets
• Number Format Helper — Generate format codes for currencies, percentages, dates, and custom patterns

Meta Tag Generator

Generate complete, production-ready HTML meta tags for SEO, Open Graph (Facebook/LinkedIn), and Twitter Cards.

Generated Tags

• <title> — Page title (max 60 chars recommended)
• <meta name="description"> — Page description (max 155 chars)
• <meta property="og:*"> — Open Graph for Facebook, LinkedIn
• <meta name="twitter:*"> — Twitter/X Card tags
• <link rel="canonical"> — Canonical URL

Word Counter

Real-time word, character, sentence, paragraph, and reading time counter. Supports all languages including Arabic, Hebrew, and other RTL scripts.

Metrics Explained

• Words — count of whitespace-separated tokens
• Characters — total character count including spaces
• No Spaces — character count excluding all whitespace
• Sentences — split on . ! ? ؟ (includes Arabic question mark)
• Paragraphs — blocks separated by one or more blank lines
• Read Time — estimated at 238 words per minute (average adult speed)