office and writing All Tools
Text processing, QR code, bar code and table conversion.
office and writing77
Text processing, QR code, bar code and table conversion.
word count
Statistics of Chinese characters, English words, characters, paragraphs, punctuation and expected reading time.Comparison of text differences
Compare two paragraphs of text and highlight new, delete, and retain content.Text de-repeat and sort
De-weight, go blank, sort by line, and display the number before and after.Batch find replacements
Process the text according to multiple sets of rules, preview and copy the replacement result.English letter case conversion
Convert uppercase, lowercase, first letter and first to uppercase of words.Chinese characters to pinyin
Convert Chinese characters to tones, no tones or the first alphabet pinyin, and support polyphonic options.QR code generator
Generate QR codes and download them for text, URLs, or Wi-Fi configurations.QR code identifier
Upload or paste QR code pictures, and extract content locally.barcode generator
Generate Code 128, EAN-13 and Code 39 barcodes, which can be downloaded and printed.EXCEL and CSV conversion
Convert between XLSX, CSV and TSV, preview the worksheet and select the separator.Text line numbers and prefixes
Add continuous numbering, custom prefix and suffix to multiline text.Differences between the two lists
Compare the common items, unique items and de-consolidation results of the two lists.Full-width half-width character conversion
Convert all-width English alphabets, numbers, punctuation and spaces to facilitate the sorting of table text.long text segmentation tool
Split long text by the specified number of characters to generate a numbered segmented list.CSV table row column transposition
Swap the rows and columns of CSV, and support Chinese, quotation marks, line breaks and empty cells.Markdown table generation
Convert CSV tables to Markdown tables, which support left, middle and right alignment.Text privacy desensitization
Cover the mobile phone number, 18-digit ID card format and some characters in the mailbox locally.Paper size and print pixels
Inquire about common A series, B series and Letter paper sizes, and calculate pixels according to DPI.Text number and link extraction
Extract common mobile phone numbers, emails or HTTP links from text locally, and support deduplication.Blank clearing of text
Clear blanks at the beginning and end of the line, continuous spaces and blank lines, and uniform newlines.Markdown title directory generation
Generate hierarchical directory text from Markdown's pound header.CSV column selection and rearrangement
Extract, delete, or rearrange CSV fields by column number, leaving text and leading zeros.CSV two table associations
Press the specified key column to make a left connection or internal connection to the two CSVs, and organize the corresponding data.Text Reverser
In reverse order of the whole segment character, each line character or line order, the expression combination is reserved.Word and Character Frequency Statistics
Count the occurrences of characters or spaces to separate words, and the output frequency ranking.Merge Text Columns Line by Line
Pair two lines of text by line number, and use self-fill to separate and comply with each other.CSV condition filtering
Filter CSV rows by column number and text condition, leaving the header and leading zeros.CSV group summary
Grouping by specified columns, the count, total, average, min and maximum value of the numeric columns are calculated.Excel worksheet merge
Import multiple xlsx worksheets into a new workbook with the same name as the automatic numbering.Split Excel by Worksheet
Split a copy of each worksheet of XLSX into a separate XLSX and package and download.Excel to HTML Table Converter
Convert the worksheet in XLSX to a stand-alone, downloadable static HTML table.Word document text extraction
Extract paragraphs, table text and newlines from the docx body locally, and download txt.Batch File Renamer
Preview file name replacement, prefix and numbering rules, and download the zip copy after confirmation.Excel Table Comparison
Press the unique key to compare two XLSX tables, list new, delete and field modifications.Split Excel by Column Value
Split the worksheet by department, city, etc., and package and download multiple xlsx files.Spreadsheet Duplicate Checker
Press the specified key column to find the XLSX duplicate rows, preview the duplicates and export the cleaning table.Markdown to HTML Converter
Preview Markdown typography in real time, copy or download securely filtered HTML.SRT and VTT Subtitle Converter
Convert subtitle format, adjust the overall timeline, or extract subtitle text.URL Slug Generator
Batch the title of the article into a concise URL path fragment.Invisible Character Detector
Locate control characters, zero-width characters and two-way text control characters in the text.Unicode Normalization
Compare and convert the NFC, NFD, NFKC and NFKD Unicode normalization forms.Morse Code Converter
Convert English alphabets, numbers and commonly used punctuation to Morse code and restore.Caesar Cipher and ROT Converter
Move the English alphabets according to the specified offset, and support decoding and ROT13.Levenshtein Edit Distance
Calculate the Levenshtein editing distance and normalized similarity between the two paragraphs.N-gram Frequency Analyzer
Count the combination frequency of continuous characters or blank segmentation sequences.Email List Syntax Checker
Batch check commonly used mailbox formats, locate duplicates, and export a list of valid formats.ISBN Validator and Converter
Check ISBN-10 and ISBN-13 in batches and convert compatible book numbers.GTIN Barcode Validator
Check GTIN-8, 12, 13, 14-digit product numbers, or calculate the last digit check code.Cartesian Product of Lists
Combine the two lists into specs, options, or test data combination tables.CSV Pivot Table
Generate cross summary tables by row dimension and column dimension, which supports summation or counting.CSV Append by Header
Merge two CSVs in different column order, and align the fields according to the original text of the header.CSV Column Profiler
Count the number of nulls, unique values, duplicates and strict number formats in each column.Contact vCard Generator
Fill in the contact information to generate a vCard 3.0 file that can import the address book.csv to sql insert statement
The sqlite or postgresql insert statement will be generated with the header CSV, leaving the text number.Project Critical Path Calculator
Enter the task duration and pre-reliance, and calculate the shortest duration, earliest and latest time and total time difference of the project.Minimum-Cost Task Assignment
Find the minimum total cost allocation scheme to cover all tasks for multiple people and multiple tasks.Budget-Constrained Selection (0/1 Knapsack)
Look for the unbreakable option combination with the largest total value within a given capacity or budget.One-Dimensional Bin Packing
Groups are generated according to the occupancy of each item and the capacity of a single box, and the lower bound of the box number is displayed.ABC and Pareto Data Analysis
Sorting items by numerical value, calculate the proportion, cumulative proportion and ABC classification under the self-determined threshold.Weighted Integer Quota Allocation
The fixed integer total is allocated according to the non-negative integer weights of each group to ensure that the total distribution result is consistent with the total amount.Survey Sample Size Calculator
The number of valid questionnaires required for estimates based on confidence levels, error ranges, expected ratios, and overall size.Conflict-Free Task Grouping
The tasks that exist in two conflicts are divided into different groups, and a feasible grouping suggestion is generated.Stable Matching by Mutual Preferences
Generate a one-to-one stable pairing according to the complete preference sequence of the members on both sides, and display the rankings of both parties.CSV Template Mail Merge
Populate a text template with each record in CSV, and generate notifications, tag copy or personalized text in batches.Whole-Line Wildcard Matching
Use asterisks and question marks to filter text line by line to see if each line matches the pattern in full.Fixed-width Text and CSV Converter
Divide fixed-width records by specified column width, or fill in the CSV field into fixed-width text.Stable Multi-column CSV Sort
Text or precise decimal ordering of CSV by multiple column priority, keep the original cell.Fill Missing CSV Values
Select the CSV column and fill empty cells with the nearest non-null value before and after the specified text or the same column.Keyword in Context Index
Find the location of the keywords each time, and list the left and right contexts, row numbers and starting columns.CSV wide table to long table
Leave the specified ID column and expand the remaining columns into long tables with field names and values.CSV grouping cumulative and in-group number
Calculate the cumulative value and in-group serial numbers in groups according to the existing row sequence.markdown inline link extraction
Extract the intra-line links and image addresses in Markdown locally, and do not access the target.Comparison of words and characters
Compare whether two texts have the same character composition after ignoring whitespace and case.CSV value column range verification
Check whether the specified CSV column is a valid decimal number and is within the self-fill range.CSV date format unified
Convert CSV date columns in the original format that is explicitly specified, leaving other fields and empty date original values.Word-safe text truncation
Limit the length of the text according to the visible word element, and avoid dismantling the combined characters or family expressions.Comparison of multi-program weighted scores
According to the self-fill index weight and the 0 to 100 score comparison plan, the original scores are retained.