Getting started with CSV Explorer is easy
CSV Explorer accepts CSV files of almost any size and configuration. You can upload from your computer, Box, Google Drive, Amazon Cloud Drive, Github, and URLs.
CSV Explorer will intelligently determine most CSV configurations.
|Header row||A header row is required on all files|
|Delimiter||CSV Explorer will attempt to determine the delimiter. Acceptable delimiters are commas, tabs (\t), and semicolons|
|Line Breaks||CR (\r), LF(\n), or CRLF line breaks are accepted and allowed within quoted fields|
|Quote char||Quote characters are necessary if a delimiter or line break appear in a field|
|Empty Fields||Empty Fields should not be quoted in quote chars|
|File Encoding||CSV Explorer will attempt to determine the encoding, UTF-8 is preferred|
|Dates||CSV Explorer parses a variety of date and time formats including ISO 8601|
Type in the search box under a column name to find rows whose value for that column contains the search string.
Searching in multiple columns returns rows that match both queries.
Number fields can be filtered using the comparison operators: >, >=, <, <=.
Dates and times can be filtered using the comparison operators: >, >=, <, <=.
To search by regular expression, begin searches with /.
Regular expressions are a common technique for advanced string searches. Learn more about regular expressions here.
To count the occurences of each element in a column, click the column name, and then Histogram. A new table will appear containing the count of each element.
The Quick Plot iconwill plot the histogram.
Filters and histograms can easily be combined.
To compute the Average, Sum, Minimum, and Maximum values of a column, click the column name and select Avg/Sum/Min/Max.
Then select a column for which they should be computed. Leave the column selection blank to compute it over all rows.
Dates and times are made up of parts: years, months, days, hours, etc. Date/Time Histograms are used to histogram parts of a date or time.
Click on the column, then select Date/Time Parts. Select the parts of the date or time to histogram, and then select Histogram.
Dates and times are made up of parts: years, months, days, hours, etc. Use a Date/Time Part Extract to create a new column, with just one component of a date or time.
Click on the column, then select Date/Time Parts. Select the parts of the date or time to extract, and then select Extract. A new table will be created, with new columns of the time parts.
To create a bar or line chart, click the Plot icon at the top left of a table. Select a graph type, and use the input fields to choose columns to use for the X and Y axes. Click Go.
Plots will be direct representations of the table. Run filters, sorts, and aggregates before plotting. To sort the X axis, select the column name and click Sort, then plot the table.
Certain plotting analyses are common, such as plotting the results of a histogram. In these cases, the Quick Plot icon will appear at the top left of the table.
To download a table to open in Excel or to download a chart, click the download icon at the top left of a table.
CSV stands for Comma Separated Value. CSV files are a common data exchange file format for databases, spreadsheets, web applications, open data portals, IoT devices, and more. To get CSVs from common software and services, check out our guides below.