CSV row range extractor: take the first 500 rows, the last rows or rows 1,001 to 2,000
In short: Upload a list and take the first rows, the last rows, a range of rows or every Nth row. The header row is kept in both the rows you took and the rows left behind. Limit: It selects by position only, so a slice of a sorted list does not stand for the rest.
Upload a CSV or .xlsx file, or paste it with a header row. Choose the first rows, the last rows, a range such as rows 1,001 to 2,000, or every Nth row. You get the rows you took and the rows left behind as two files, each with the header row kept and every column unchanged.
Price: this tool is free. Checking a whole email list is from $9/mo, and the first 100 checks are free with Google, no card. Check your list free nowSee pricing
Sample result
Rows 3 to 8 of a 12-row example list are taken: 6 rows, with 6 left behind.
- Rows taken
- 6
- Range
- Rows 3 to 8
- Header
- Kept
What this means for you
A slice keeps its share of bad addresses; check it before the send.
- First or last N rows
- A range of rows
- Every Nth row
- Header kept in both files
- CSV
- Rows
- Slice
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
Took your slice? Check the addresses in it before the send.
- Download the rows you took, or use the check button under the result, which carries the addresses in the slice across.
- Upload or paste it at /verify. Every address gets a live mailbox check, and the first 100 email checks are free with a Google sign-in, no card.
How do I take a range of rows from a CSV?
- Upload the file as a CSV or .xlsx, or paste the cells with the header row first.
- Choose what to take: the first rows, the last rows, a range of rows or every Nth row.
- Set the number, or the from and to rows. Row 1 is the first row under the header.
- Download the rows you took and, if you want them, the rows left behind.
Example
- You enter
- A header and 12 rows of contacts, rows 3 to 8 taken.
- You get
- 6 rows taken (rows 3 to 8) and 6 left, each file with the header row kept.
- Limits
- Runs in your browser; nothing is uploaded. It selects by position, so a slice of a sorted list does not stand for the rest.
How are the rows counted?
The header row is not counted, so row 1 is the first row under it. The first 500 rows are rows 1 to 500, and rows 1,001 to 2,000 are the second thousand. Both files you download start with the header row, and the rows keep their original order.
Every Nth row takes rows N, 2N, 3N and so on, so every 10th row of a 100-row list gives 10 rows. It is a spread through the list, not a random draw.
When is a slice better than a random sample?
Take the first rows when the list is sorted by priority and you want to send to the best ones first, or when you want a small test file. Take a range to continue where a last send stopped. For a random draw that stands for the whole list, use the email list sampler. A slice of a sorted list does not represent the rest.
What if I need many parts, or a split by value?
To cut a whole list into equal files, use the email list splitter. To split by what a column holds, such as country or owner, use split CSV by column value. To read what a file holds first, see clean CSV columns before import.
Who uses this tool, and for what?
- Cold emailers
- Take the first 200 rows of a sorted list as a test send, then the next range tomorrow.
- Marketers
- Cut a big export into a file small enough for an importer that limits rows.
- Analysts
- Pull rows 5,001 to 10,000 out of a long export to look at them in a spreadsheet.
What can’t this tool tell you?
- It selects by position only, so a slice of a sorted list does not stand for the rest.
- Every Nth row is evenly spaced, not random; use the sampler for a random draw.
- Only the first sheet of a workbook is read.
- It does not clean or check the rows; each slice keeps its share of bad addresses.
Common questions
- Does the header row count as row 1?
- No. Row 1 is the first row under the header, so the first 500 rows are rows 1 to 500 of the data.
- Do both downloads keep the header?
- Yes. The rows taken and the rows left both start with the header row, and every column is unchanged.
- Does the list need an email column?
- No. Any CSV works. If it has a column of addresses, the check button under the result carries the rows you took across.
- What does every Nth row do?
- It takes rows N, 2N, 3N and so on. It is evenly spread, not random, so a list sorted by date gives a spread across the dates.
- What if my range is longer than the list?
- It takes what exists. A range of rows 90 to 200 of a 100-row list takes rows 90 to 100.
- Is my file uploaded?
- No. The file is read in your browser and goes nowhere.
A tidy list can still be full of dead addresses.
Extracting, deduplicating and syntax checks all work on the text of an address. None of them can tell whether the mailbox exists. Only the server that hosts it can answer that, through an SMTP check, and that is what the paid product does.
- Upload the cleaned file as it is: CSVs up to 100,000 rows
- A real SMTP mailbox check on every row, with catch-all detection
- Small list? Starter at $9/mo covers 2,500 emails a month, cancel anytime
Plans from $9 a month, cancel anytime, no contract. Sign in with Google and your first 100 email checks are free, no card. The free tools stay free either way.