
VLOOKUP in Excel – Complete Guide with Formula & Examples
VLOOKUP in Excel explained simply — syntax, step-by-step examples, common errors, and tips for beginners and professionals.
Master Excel, SQL, Power BI, Python, and Data Analytics with real-world projects, datasets, and interview preparation.
Search across blogs, datasets & tutorials
Structured curriculums designed to take you from novice to expert in specific technologies.
/// tools · utilities · browser-first
Regex, JSON, images, PDFs, media, and SEO helpers run in your browser—no install. Browse the full catalog anytime.
Format, test, and transform code — regex, Base64, diff, formatters, and API helpers.
Test JavaScript-style regular expressions in your browser: enter a pattern, toggle global (g), case-insensitive (i), and multiline (m), paste sample text, and see highlighted matches with start indexes. Invalid patterns show a clear error. No signup; your strings stay on your device.
Pretty-print, minify, and validate JSON payloads.
HTTP client in the browser: collections, environments, {{variable}} interpolation, Bearer/Basic/API key/OAuth2/custom auth, JSON/form/urlencoded/multipart/GraphQL bodies, pre-request scripts, history, and code snippets (fetch, Axios, Python, PHP, Go, cURL, C#, Ruby). Sends through Dynamic Duniya’s API proxy (30s timeout). Workspace in localStorage; optional cloud sync when signed in.
Convert CSV, JSON, YAML, and XML; analyze text; generate passwords and more.
Switch CSV → JSON or JSON → CSV. RFC 4180–style CSV parsing (quoted fields, doubled quotes), delimiter choice for import (comma, semicolon, tab, pipe), optional header row or col1… keys, pretty or minified JSON, stats after convert. JSON → CSV needs a non-empty array of objects; union of keys becomes columns; output CSV uses commas. Upload .csv/.json, load examples, copy, or download output.json / output.csv — all client-side.
Convert JSON to YAML or YAML to JSON in the browser with js-yaml: JSON.parse + YAML dump (2-space indent, 120-char wrap) or yaml.load + pretty JSON (2-space indent). Debounced live conversion as you type, line numbers on both sides, Convert now, copy, and download output.yaml / output.json.
Convert XML to JSON or JSON to XML in the browser with fast-xml-parser: attributes map to configurable-prefixed keys (default @), trimmed text nodes, optional compact output, optional UTF-8 XML declaration on JSON→XML, and a root wrapper for bare arrays or scalars. Convert on demand, character/node estimate, copy, download output.json / output.xml.
PDF, Office, ZIP, OCR, and compression — work with documents in the browser.
Merge: first-page previews in a horizontal strip — drag cards to set merge order. Split: optional “Load page previews” then drag thumbnails (four per row, scrollable) to reorder pages before splitting by ranges or every N pages; ranges use preview slot numbers when previews are loaded. Zip when multiple parts. Client-side pdf.js + pdf-lib — max ~35 MB per file, 150 pages, 12 PDFs for merge.
Create a ZIP from many local files (append picks, DEFLATE or STORE) or open a .zip and download entries / selected subset as a new ZIP. JSZip in the browser — ~35 MB archive cap, no password support.
Stamp text (font size, opacity, rotation, corner/center placement) or a JPEG/PNG image across every page using pdf-lib locally. Encrypted PDFs are not supported. Download a watermarked copy — your file never leaves the browser.
Resize, compress, convert formats, colors, watermarks, and creative image utilities.
Free online color picker for designers and developers: pick from your screen (EyeDropper in Chromium), sample any pixel from an uploaded image, edit in HSV or RGB with alpha, copy hex, RGBA, HSL, ARGB, eight-digit hex, and approximate CMYK — plus saved swatches, tint/shade strips, contrast preview, and a detachable window. Everything runs in your browser; nothing is sent to our servers.
Convert JPEG, PNG, WebP, or GIF sources to JPEG, PNG, or WebP in your browser: live preview updates as you switch format, quality slider for lossy JPEG and WebP, lossless PNG (no quality control). Decoding and encoding stay on your device—no upload. GIF sources decode to a static frame; animation is not preserved in the output file.
Resize or reframe JPEG, PNG, WebP, or GIF entirely in your browser: set target width and height, optionally lock aspect ratio, then choose how pixels map—Fit (letterbox on white), Cover (center crop to fill), or Stretch. Export as JPEG, PNG, or WebP with a quality slider for lossy formats. Decoding and canvas work stay on your device (no upload). Animated GIFs flatten when exporting to static formats.
QR codes, barcodes, screenshots, HTML utilities, SEO, and page quality checks.
Free on-page and technical SEO check for one URL at a time — meta tags, headings, images, links, Open Graph, JSON-LD, and more. We do not include backlinks, keyword rankings, or full-site crawls (those need separate databases). URL mode: server HTML fetch + in-browser audit; optional PageSpeed from Google (capped per browser per day). Paste HTML: 100% in your browser.
Batch-check up to 50 http(s) links: paste one URL per line or extract unique URLs from pasted text/HTML, POST to the link-check API, and see OK, redirect, broken, or timeout with status code, response time, and final URL. Filter and sort the table, export link-check-results.csv in the browser, or re-run checks on broken/timeout URLs only.
Build QR codes in the browser: URL, text, mailto, tel:, SMS (sms:), WhatsApp (wa.me), geo: coordinates, Wi‑Fi join strings, or vCard 3.0. Pick size 128–1024 px, error correction L–H, colors; copy payload, copy PNG, or download PNG/SVG. Tabbed UI with icons; custom strings via Text — no upload.
Cross-cutting utilities — timestamps, quick conversions, and everyday helpers that do not fit a single domain.
/// playground · challenges · leaderboard
12 language playgrounds, daily coding challenges, and a live leaderboard. The fastest path from learning to placement.
12languages
// playground
30+challenges
/// practice
2.8kcoders
[ ranked ]
// trending challenges
all challenges →// top this week
full board →Leaderboard updates hourly — check back soon.
Deep dives into data science methodologies, industry trends, and technical tutorials.
View All ArticlesData Science, ML & AI reads—scroll to explore.
Execute your interview strategy with precision. Real questions from top tech companies.
Practice with quizzes by topic and difficulty. Get instant feedback and track your progress.
Clean, real-world data for your portfolio projects.
The Awesome-ChatGPT-Prompts dataset is a community-curated collection of high-quality prompts for ChatGPT and other large language models. It includes diverse prompt templates—from technical tasks like acting as a Linux terminal or Python interpreter to creative roles like storyteller or teacher—helping users explore, reuse, and improve prompt engineering practices. The dataset is open-source under CC0, making it freely available for research, development, and practical applications.
Amazon Review Data (2018) is a large-scale dataset containing over 233 million customer reviews from Amazon products between 1996 and 2018. It includes detailed review information such as ratings, review text, helpfulness votes, and timestamps, along with rich product metadata like brand, price, category, and images. This dataset supports various tasks in natural language processing, sentiment analysis, and recommendation systems.
Two ground ozone level data sets are included in this collection. One is the eight hour peak set (eighthr.data), the other is the one hour peak set (onehr.data). Those data were collected from 1998 to 2004 at the Houston, Galveston and Brazoria area.
At LOL Bank Pvt. Ltd., ensuring the safety and integrity of economic transactions is a top priority. With increasingly more on line transactions and digital banking activities, fraudulent transactions have end up a good sized danger to both the financial institution and its customers. Fraudulent activities, along with unauthorized account get right of entry to, identification robbery, and suspicious transaction patterns, bring about economic losses and harm to patron agree with.
YouTube maintains a list of the top trending videos on the platform. According to Variety magazine, “To determine the year’s top-trending videos, YouTube uses a combination of factors including measuring users interactions (number of views, shares, comments and likes). Note that they’re not the most-viewed videos overall for the calendar year
The COVID-19 case surveillance system database includes individual-level data reported to U.S. states and autonomous reporting entities, including New York City and the District of Columbia (D.C.), as well as U.S. territories and states. On April 5, 2020,
Join thousands of data professionals building the future.