CSV Lint plug-in for Notepad++ to view csv files, validate and convert to SQL insert script

This page summarizes the projects mentioned and recommended in the original post on /r/SQLServer
notepad-plusplus-plugin CSV csv-files notepad-plus-plus csv-query

InfluxDB - Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured

  • CSVLint

    CSV Lint plug-in for Notepad++ for syntax highlighting, csv validation, automatic column and datatype detecting, fixed width datasets, change datetime format, decimal separator, sort data, count unique values, convert to xml, json, sql etc. A plugin for data cleaning and working with messy data files.

    • The CSV Lint plug-in for Notepad++ was updated recently, it's available in the latest release of Notepad++ (v8.5.3). It is a useful plug-in for anyone working with csv datasets. I have created the plugin and had posted about it before, and this latest update has some more improvements and bugfixes.

  • CsvQuery

    Plugin for Notepad++ that treats CSV files as (read only) SQL tables

    • Check out the CSVQuery plugin too. https://github.com/jokedst/CsvQuery

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo

  • NppPluginLexerExample

    Notepad++ Plug-in Lexer and Folder example using the C# template

    • Are you maybe referring to EDIFACT type files, so files where the first column value determines what type of row it is? Maybe you can take a look at this example lexer although it's not a fully functional plugin it does take into account the first character of a row.

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts

  • Is there a way I could run a SQL query on CSV file without inserting them in my database?

    1 project | /r/SQL | 12 Feb 2021

  • A question for the pro's, am I misusing SQL?

    1 project | /r/SQL | 11 Dec 2023

  • Best alternative for python

    2 projects | /r/deeplearning | 6 Dec 2023

  • Looking for a CSV editor that doesn't modify the data like Excel does

    1 project | /r/software | 7 Dec 2023

  • SQL/CSV data generator

    1 project | /r/cs50 | 7 Dec 2023