BlueprintLab Tools
JAEN
All tools / Use cases / OFFICE & DATA
OFFICE & DATA

Free Tools for Office and Data Work

Finish repetitive formatting, comparison, extraction, and calculation tasks directly in your browser.

Workflow

1
Choose the tool for the task
2
Enter text, a CSV, or values
3
Copy or save the checked result

Tools for this workflow

Free tools for CSV, Excel, text, email extraction, formatting, comparison, calculations, and office data work.

Extract PDF PagesSelect pages from a PDF and save them as a new PDF. The file is processed in your browser.Open  →Delete PDF PagesRemove selected pages from a PDF and save the remaining pages as a new PDF.Open  →Text / line counterCount characters, lines and words in real time.Open  →Find and replace toolFind and replace text, optionally using a regular expression.Open  →Duplicate line removerRemove duplicate lines while keeping the first occurrence.Open  →Line sorterSort lines alphabetically or by length.Open  →List difference toolExtract lines unique to list A or list B.Open  →List intersection toolExtract lines that appear in both lists.Open  →CSV column extractorExtract selected columns from pasted CSV.Open  →CSV row filterFilter pasted CSV rows by a keyword in a selected column.Open  →CSV mergerMerge multiple CSV files with matching headers.Open  →CSV row splitterSplit a large CSV into files with a chosen number of rows.Open  →Japanese era / Gregorian date converterConvert Japanese era dates and Gregorian dates line by line.Open  →Date add / subtract calculatorAdd or subtract days/weeks from a date.Open  →Date difference calculatorCalculate the difference between two dates in days and weeks.Open  →Work hours calculatorCalculate net working time from start, end and break.Open  →Tax inclusive / exclusive calculatorConvert tax-inclusive and tax-exclusive prices with a custom rate.Open  →Unit price comparerCompare two products by unit price.Open  →Margin / markup calculatorCalculate gross profit, margin and markup.Open  →Japan phone number normalizerNormalize Japanese phone numbers and convert between domestic and +81 forms.Open  →Extract Unique Email Addresses from TextExtract email addresses from long text and remove duplicates.Open  →

A practical workflow for editing CSV in Excel

A step-by-step workflow for preserving leading zeros, long IDs, and validating the exported CSV.

Edit a CSV safely in Excel

Protect identifiers, dates, encoding, headers, and validate the exported CSV.

Practical workflow
›

Related topics and guides

CSV & data toolsBrowse all tools in this topicText & list toolsBrowse all tools in this topicDate, business day & time toolsBrowse all tools in this topicFile, storage & transferBrowse all tools in this topicCSV looks garbled in Excel—or everything lands in one column. Start here.Review the decision and workflow contextWhy “one character” can have several different countsReview the decision and workflow contextMbps vs MB/s: why transfer-time estimates can be off by 8×Review the decision and workflow context“Three business days later” sounds simple—until a holiday gets in the way.Review the decision and workflow context

Before you use these tools

Keep the original data and review results before applying them to business records.