A better CSV import

This page summarizes the projects mentioned and recommended in the original post on dev.to

InfluxDB – Built for High-Performance Time Series Workloads
InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
  1. mapzy

    Free, simple, open-source and self-hostable store finder.

    When building the bulk location import feature for Mapzy, our open-source and self-hostable store finder, we wanted to provide a better import experience for our users. We wanted to spare them the pain of dealing with exporting files and choosing delimiters, and we wanted to make it simple for them to fix any import errors.

  2. InfluxDB

    InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.

    InfluxDB logo
  3. Jspreadsheet CE

    Jspreadsheet is a lightweight JavaScript data grid component for creating interactive data grids with advanced spreadsheet controls.

    For the spreadsheet, we use the excellent Jspreadsheet library. If there are no errors, the import happens in two steps because importing a lot of locations requires a lot of calls to the Mapbox geocoding API (geocoding is converting an address to longitude and latitude), which is rate limited.

  4. ActiveRecord Import

    A library for bulk insertion of data into your database using ActiveRecord.

    In the first step, we only validate if the information is all there and correctly formatted. For example, if a location name is missing, we highlight that error in the spreadsheet. If everything looks good, we save the locations to the database using the awesome Activerecord-Import library, but skip calling the geocoding API. Rather, we mark these locations as "to be geocoded".

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

  • Show HN: Jspreadsheet CE v5 – A Lightweight, Excel-Like JavaScript Data Grid

    2 projects | news.ycombinator.com | 2 May 2025
  • Libre Endowment Fund: Sustainable Development of Free Software

    1 project | news.ycombinator.com | 9 Oct 2021
  • How to show excel file in front end with edit and save functionality?

    2 projects | /r/django | 6 Jun 2021
  • Stop One-By-One Inserts! Bulk Insert Data In Rails With insert_all Or activerecord-import ⚡

    1 project | dev.to | 28 Feb 2025
  • Inserção de dados em massa em bancos relacionais

    1 project | dev.to | 29 Jan 2025

Did you know that Ruby is
the 12th most popular programming language
based on number of references?