Prepend a Column
Prepend a Column in a delimited table, in your browser, with a real worked example.
What this prepend a column does
Add a column at the beginning of every row. Column numbers start at one; a column can also be named by its header text.
How to use it
Prepend a Column: paste the delimited text into the box above, set Name (default "id") and Value (default "1"), and press Run to get the result below.
Worked example
Input:
name,role,years
Ada,engineer,7
Linus,maintainer,32
Output:
1 Ada engineer 7
1 Linus maintainer 32
Why it runs in your browser
The conversion happens on this page with JavaScript. Your input is not posted to a server, so it works offline after the page loads and nothing is retained anywhere. The page reads delimited text and returns result; reloading the page discards both.
Add a column at the beginning of every row. Column numbers start at one; a column can also be named by its header text.
Prepend a Column in a delimited table, in your browser, with a real worked example.
How to use it
Prepend a Column: paste the delimited text into the box above, set Name (default "id") and Value (default "1"), and press Run to get the result below.
Why it runs in your browser
The conversion happens on this page with JavaScript. Your input is not posted to a server, so it works offline after the page loads and nothing is retained anywhere. The page reads delimited text and returns result; reloading the page discards both.
What to Expect
Best for
- Converting delimited text to result when the data is already on screen.
What this tool keeps
- Your input is not posted to a server, so it works offline after the page loads and nothing is retained anywhere.
Sample input
name,role,years Ada,engineer,7 Linus,maintainer,32
Sample output
1 Ada engineer 7 1 Linus maintainer 32
Frequently asked questions
How do I use the prepend a column?
Prepend a Column: paste the delimited text into the box above, set Name (default "id") and Value (default "1"), and press Run to get the result below.
Is my input uploaded?
No. The text is parsed on this page with JavaScript and is never posted to a server.
Is there a size limit?
Yes: 5 MB per run. Larger input is refused with a message rather than freezing the tab.
Build custom tools for your store
Join the SDK program to create useful ecommerce utilities for your store.