JavaScript
JavaScript is a scripting language and programming language for the web that enables developers to build dynamic elements on the web. Over 97% of the websites in the world use client-side JavaScript. JavaScript is one of the most important scripting languages on the web. Strings in JavaScript are contained within a pair of either single quotation marks '' or double quotation marks "". Both quotes represent Strings but be sure to choose one and STICK WITH IT. If you start with a single quote, you need to end with a single quote. There are pros and cons to using both IE single quotes tend to make it easier to write HTML within Javascript as you don’t have to escape the line with a double quote. Let’s say you’re trying to use quotation marks inside a string. You’ll need to use opposite quotation marks inside and outside of JavaScript single or double quotes.
Learn more
Tablecruncher
Tablecruncher is a lightweight yet powerful CSV editor for Mac, designed to handle large datasets efficiently. It can open files larger than 2GB, containing over 15 million rows, with a 100MB CSV file loading in under 5 seconds on a dual-core MacBook Pro. It supports various encodings, including UTF-8, UTF-16LE, UTF-16BE, Latin-1 (ISO-8859-1), and Windows 1252, automatically detecting most CSV formats and encodings. Users can utilize JavaScript as a macro language to manipulate CSV files, accessing all cells for content changes and calculations. Tablecruncher allows exporting table data to JSON, producing an array of objects if a header row is present, or an array of arrays otherwise. The find and replace dialog supports pattern searches within the table or selected areas, with Regular Expressions compliant with the ECMAScript 5 standard. It offers four color themes, including a dark mode compatible theme, enhancing user experience.
Learn more
Edit CSV
Edit CSV is a free online tool that allows users to edit CSV files through a table-based user interface. It offers features such as undo/redo functionality, column sorting by clicking on header text, and the ability to rearrange rows and columns by dragging. Users can resize rows and columns, and navigate efficiently using keyboard shortcuts to move to the first cell in a row, to move to the last cell, to jump to the first cell in a column, and to reach the last cell. You can also add a line break within a cell. To delete a row or column, hover over it and click the trash icon. Double-clicking a column's resize handle adjusts its width to fit the content; double-clicking an auto-sized column sets its width to 200px, which is useful for very wide columns. It also provides a context menu accessible via right-click and supports copy-pasting using the tab key as a separator, similar to Excel.
Learn more
CSViewer
CSViewer is a fast and free Windows desktop application for viewing and analyzing large delimited text and binary data files, such as CSV, TSV, Parquet, and QVD. It can load millions of rows in seconds and offers advanced filtering, instant profiling with aggregates, null counts, and outlier detection. Users can export filtered data, save analysis views, and visualize data through charts and cross-tables. CSViewer is designed for easy exploratory analysis without sending data to the cloud. Aggregates and charts are updated immediately when a filter is applied or changed. Null counts, uniques, min/max values, aggregates, etc. for every column. Export the filtered subset of rows into another file for sharing or use in another application. Convert data from one file format to another, e.g. from CSV to QVD. When you export into the native for CSViewer .dset file format, data is saved together with filters and charts for your convenience.
Learn more