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
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.
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.
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.
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.
business,town,email Kiln & Co Pottery,Frome,[email protected] Kiln & Co Pottery ,Frome,[email protected] Marlow Print Works,Bath,[email protected] Oak Lane Joinery,Frome, Pip & Parsnip Deli,Wells,[email protected]
3 of 5 rows business town email Kiln & Co Pottery Frome [email protected] Kiln & Co Pottery Frome [email protected] 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