Map Extract
Free tool

View, search and sort a CSV file

Paste or open a CSV and it appears as a table. Type in the search box to filter rows across every column, click a column to sort, and download just the rows that are showing. Values are displayed exactly as they are in the file.

Runs in your browser. Nothing you enter is uploaded.

Why not just double-click it?

Spreadsheet apps change CSV data as they open it. Phone numbers lose their leading zero, long numbers turn into scientific notation, postcodes that look like dates get converted, and a UTF-8 file without a byte order mark can show accented names as strange symbols. If you then save, those changes are written back into the file.

A viewer that only reads the text avoids all of that. You see 01632 960410 as 01632 960410, and nothing is saved unless you choose to download a filtered copy. It is the safer way to look at a scraper export or a CRM extract before deciding what to do with it.

Using the viewer

  1. Load the CSV

    Paste the text, or press Open a file. Leave the separator on Detect unless columns look wrong, then choose comma, semicolon, tab or pipe.

  2. Search every column

    Type in Search every column. Rows containing the text anywhere stay visible, and the note shows how many of the total rows match.

  3. Sort

    Use the Sort by buttons under the table. Press once for ascending, again for descending; an arrow on the column heading shows the current order.

  4. Download the view

    Download these rows saves the filtered, sorted rows as a new CSV, with the header if the first row is a header.

Finding every Frome lead

Searching frome in this list keeps three rows, including the pottery row that has a stray trailing space in its name. The search is not case sensitive and matches part of any cell, so print would find Marlow Print Works.

Sorting the unfiltered list by town, descending, puts Wells first and Bath last. Downloading after filtering gives a three-row CSV with the header, ready to pass to whoever covers Frome.

Input
business,town,email
Kiln & Co Pottery,Frome,hello@kilnandco.example
Kiln & Co Pottery ,Frome,Hello@KilnAndCo.example
Marlow Print Works,Bath,info@marlowprint.example
Oak Lane Joinery,Frome,
Pip & Parsnip Deli,Wells,shop@pipparsnip.example
Result
3 of 5 rows

business            town   email
Kiln & Co Pottery   Frome  hello@kilnandco.example
Kiln & Co Pottery   Frome  Hello@KilnAndCo.example
Oak Lane Joinery    Frome

Things to check in a new export

A first look at a file usually answers these in a minute or two:

  • Does every row have the same number of columns, or has a comma inside a value broken the layout?
  • Are phone numbers and postcodes intact, with leading zeros?
  • Search for @ to see roughly how many rows have an email at all.
  • Sort by name to spot obvious duplicates sitting next to each other.
  • Sort by town or postcode to see whether results drifted outside the area you searched.

Questions people ask

How can I open a CSV file without Excel?

Paste the contents here or open the file with the button, and it is shown as a searchable table in your browser. Because the viewer only displays the text, it does not strip leading zeros, reformat dates or change encodings the way a spreadsheet can, and nothing is written back to your file.

Why does Excel remove the zero from phone numbers?

Excel guesses that a column of digits is numeric and stores it as a number, and numbers cannot start with zero. Viewing the CSV here shows the value as it really is in the file. To keep zeros in Excel, import the column as text rather than double-clicking the file.

Can I edit cells in the viewer?

No. The viewer is for reading, filtering and sorting. You can download the rows currently showing as a new CSV. To change values, make the edit in the pasted text, which updates the table straight away, or use a spreadsheet once you know what the data contains.

Is the search case sensitive?

No. Typing leeds matches Leeds, LEEDS and Leeds City Centre, in any column. The search looks for the text anywhere in a cell, so a short search term can match more than you expect; add more of the word to narrow it down.

Where your data goes

The table is drawn by your browser from the text you provide. The file is not uploaded, and the filtered download is generated on your device.

Checked against the tool on

Top