If you've ever needed to add prefixes or suffixes to hundreds of lines at once, you already know how painful it is to do manually. Clicking into each line, typing the same thing over and over, and inevitably missing one or making a typo. There's a much faster way, and it doesn't require coding skills or expensive software.
Why You'd Need to Edit Every Line in a List
This kind of task comes up more often than you'd think. You might be formatting a list of file names, building SQL queries, preparing import data, or wrapping values in HTML tags.
The common thread is that you have a large list of items and you need the same text added to the start or end of every single line. Doing it one by one is not realistic at scale.
Common Use Cases
- Adding
https://to the front of a list of domain names - Wrapping each line in quotes for a CSV or SQL import
- Appending a file extension like
.jpgto a batch of filenames - Adding a currency symbol or unit label to every value in a data export
- Inserting a consistent tag or label before each item in a report
Prefix vs. Suffix: What's the Difference?
A prefix is text you add to the beginning of a line. A suffix is text you add to the end. Sometimes you need both at the same time, for example wrapping each line like [item].
| Type | Position | Example Input | Example Output |
|---|---|---|---|
| Prefix | Start of line | apple | fruit_apple |
| Suffix | End of line | apple | apple.jpg |
| Both | Start and end | apple | [apple] |
How to Do It With a Text Tool
The quickest method is to use an online text tool that supports bulk line editing. You paste your list, specify what to add, and it handles every line at once. No formulas, no macros, no scripting required.
- Copy your full list of items and paste it into the text tool.
- Find the prefix field and type the text you want added to the start of each line.
- Find the suffix field and type the text you want added to the end of each line.
- Hit the process or transform button.
- Copy the result and paste it wherever you need it.
Tip: If your list has blank lines mixed in, check whether the tool adds prefixes and suffixes to empty lines too. Some tools skip blank lines by default, which is usually what you want. If yours doesn't, clean up the blanks first using a duplicate line remover or a basic find-and-replace.
Doing It With Find and Replace
If you're working in a code editor like VS Code or Notepad++, regex-based find and replace is a solid option. It's faster than manual editing but requires knowing a bit of regex syntax.
To add a prefix, search for ^ (start of line) and replace with your prefix text. To add a suffix, search for $ (end of line) and replace with your suffix text. Make sure regex mode is turned on in your editor's find panel.
Warning: Regex behavior can vary between editors. Always test on a small sample of your list before running it on thousands of lines.
Doing It With a Spreadsheet
In Excel or Google Sheets, you can use a formula like =CONCAT("prefix_", A1, "_suffix") to build modified values in a helper column. It works, but it adds extra steps: you need to paste values back into a plain-text format and remove the formula column afterward.
For plain text lists, a dedicated text tool is almost always faster than a spreadsheet approach. Spreadsheets are great for structured data, but they add unnecessary friction when all you have is a vertical list.
Key Points
- A prefix adds text to the start of every line; a suffix adds it to the end.
- A text transformation tool is the fastest way to bulk edit large lists without code.
- Regex find-and-replace in a code editor works well if you're comfortable with
^and$anchors. - Spreadsheet formulas can do the job but require extra cleanup steps.
- Always preview your output on a small sample before applying changes to a full dataset.
Which Method Should You Use?
It depends on where you're working and how comfortable you are with regex. For most people, a browser-based find and replace online tool is the most accessible and quickest option. You don't need to install anything, and the result is instant.
If you're already inside a code editor and your list is embedded in a larger file, regex find-and-replace is probably faster. For a standalone plain-text list, use a dedicated text tool and save yourself the setup time. The goal is to get the job done accurately without tedious repetition.