Forem: Cedric Bonjour

[Boost]

Cedric Bonjour — Fri, 25 Jul 2025 20:02:07 +0000

Cedric Bonjour

Jan 20 '25

Why Does Editing CSV Files Always Feel So Difficult?

#productivity #github #database #datascience

Comments 11

4 min read

[Boost]

Cedric Bonjour — Wed, 14 May 2025 05:20:09 +0000

Cedric Bonjour

Jan 20 '25

Why Does Editing CSV Files Always Feel So Difficult?

#productivity #github #database #datascience

Comments 11

4 min read

[Boost]

Cedric Bonjour — Wed, 26 Mar 2025 08:12:02 +0000

Why Does Editing CSV Files Always Feel So Difficult?

Cedric Bonjour ・ Jan 20

#productivity #github #database #datascience

[Boost]

Cedric Bonjour — Mon, 10 Feb 2025 18:18:05 +0000

Why Does Editing CSV Files Always Feel So Difficult?

Cedric Bonjour ・ Jan 20

#productivity #github #database #datascience

[Boost]

Cedric Bonjour — Mon, 03 Feb 2025 21:19:10 +0000

Why Does Editing CSV Files Always Feel So Difficult?

Cedric Bonjour ・ Jan 20

#productivity #github #database #datascience

Is it ok to post a same article periodically (say once per month)? What's the etiquette about that?

Cedric Bonjour — Mon, 03 Feb 2025 17:53:57 +0000

Discuss : I've built a free csv file editing app (using PWA tech). How do I reach early adopters to build a user base?

Cedric Bonjour — Tue, 28 Jan 2025 22:15:35 +0000

[Boost]

Cedric Bonjour — Wed, 22 Jan 2025 13:01:47 +0000

Why Does Editing CSV Files Always Feel So Difficult?

Cedric Bonjour ・ Jan 20

#productivity #github #database #datascience

Why Does Editing CSV Files Always Feel So Difficult?

Cedric Bonjour — Mon, 20 Jan 2025 07:14:39 +0000

CSV files are the backbone of data exchange—simple, universal, and incredibly versatile. It’s not flashy, it’s not trendy, and yet, it is everywhere. But if CSV files are so simple, important and universal then why do they feel so painful to work with?

What Are CSV Files (a quick reminder) ?

The origins of the CSV file date back to the early days of computing when simplicity was key. Developers needed a lightweight, platform-agnostic way to store and share tabular data, and the CSV was born.

CSV stands for Comma-Separated Values. At its core, it’s a simple text file where data is organized into rows and columns, with commas acting as the dividers. For example:

Name, Age, Favorite Food
Alice, 30, Pizza
Bob, 25, Sushi

A text file of tabular data
Columns of each row are delimited by commas
Hence the name, CSV: Comma-Separated Values

What Are CSV Files Used for Today ?

Fast forward to today, and CSV files are everywhere. They are a cornerstone of the digital world, acting as a universal format for data portability across systems. Whether it's accessing massive datasets from the company cloud, or transferring contacts from a phone, CSV files have you covered. Widely used in the ETL (Extract, Transform, Load) field, they enable seamless data transfer between databases with differing proprietary formats. data-engineers take advantage of their simplicity for storing and retrieving tabular data as backups. CSV files integrate well with tools like Excel, Python, or R for data-analists and data-scientists use them as input to machine learning models. Many APIs offer CSV as an exchange format due to its simplicity, and their text-based structure makes them a popular choice on platforms like GitHub, where developers use them to store configurations or small datasets in repositories. Finally, they are the go-to file format when trying to broadcast data publicly.

Database import/export, backup & API
Input format to data analysis/modeling tools
Configuration tables for code

... Just about anything

Why do CSV files remain truly indispensable?

What makes the CSV file truly indispensable is its combination of simplicity, age-old reliability, and non-proprietary nature. There’s beauty in its straightforwardness. You don’t need fancy software to open, read and understand a CSV file—the most lightweight text editors will do (notyepad, fim, emacs...). You can even check their content from the system's command line: cat ./path-to/filename.csv. It’s the file format that is guaranteed to interface seamlessly with any existing data handling software, from legacy systems to cutting-edge platforms. Sure, XML and JSON formats have their moments in the spotlight, but when it comes to reliability that will stand the test of time, the CSV is unmatched.

Simple
Reliable
Timeless
Human-Readable
Universal

Common Problems Working with CSV Files

Working with CSVs isn’t always smooth sailing. Here are some common gripes:

Encoding Nightmares: Non-ASCII characters (such as é and ü) can wreak havoc if encoding isn’t detected properly. It is worth mentioning that the recommended default encoding for CSV files is utf-8.

Comma Confusion: What happens when your data values contain commas? (Spoiler: It can get messy if not handled with the right standard.)
Standard misalignment: Over time, people have tweaked the CSV standards to better fit their needs. An example of this is in european countries where the commas are used for decimal numbers in european countries, the comma was replaced by a semicolon.

Misuse of Excel: Microsoft Excel is a great data analysis tool but poorly suited for CSV files. This holds especially true in the fields of ETL and data-engineering. It often misinterprets CSV standards or value data-types. This often ends up in data corruption and even more so when users have the auto-save mode activated. Furthermore, CSV files or often database extracts that are too large to be handled by Excel making it feel clunky or even crash upon opening a file. What hold for Excel is also true of other major spreadsheet editors such as Google Sheets, Libre Office Calc, or Mac's Numbers.

Poor tooling due to negligence in following standards

Essential Yet Painful to work with – Why?

If CSV files are so important and universal then why does it always feels unnecessarily complicated to open them in a any spreadsheet editor?

Here is a hypothesis:

A spreadsheet editor needs a fancy feature to differentiate itself and be competitive.

Fancy features require complexity that CSV files can't handle.

Editors come up with a proprietary file format to enable this differenciation.

Editors leave out CSV file handling (more or less purposly) to push their user base towards their proprietary format.

Users can't find a descent CSV file editor.

The solution: An alternative spreadsheet editor dedicated to CSV files

Nanocell-csv is a free, cross platform, spreadsheet editor dedicated to CSV files. Its source code is available on Github to be community driven. Nanocell-csv, pledges to focus only on CSV files and their real-world use cases.

The Nanocell-csv file editor strives to embrace CSV core values:

Simple

Reliable

Universal

Find out more at https://www.nanocell-csv.com/

Progressive Web Apps: Revolutionizing the Way We Experience the Web

Cedric Bonjour — Fri, 17 Jan 2025 11:01:53 +0000

Checkout how Progressive Web Apps (PWAs) combine the best of web and app experiences—offering speed, offline access, cross-platform compatibility, and seamless updates without downloads. They empower users and businesses with cost-effective, native-app-like functionality.

Imagine a world where websites behave like apps, offering lightning-fast speed, offline functionality, and seamless user experiences—all without the hassle of downloading from an app store. Enter Progressive Web Apps (PWAs), the future of web technology designed to bridge the gap between the web and native apps. A standout example of this innovation is Nanocell-CSV, a PWA designed to handle CSV files with remarkable precision and ease.

What Are Progressive Web Apps?

Progressive Web Apps are web applications that use modern web technologies to deliver app-like experiences. Built with standard web tech like HTML, CSS, and JavaScript, PWAs can be accessed through your browser but feel as polished and responsive as any native app.

What’s in It for Users?

Speed and Responsiveness - PWAs load quickly, even on slower networks. This is thanks to advanced caching techniques powered by service workers, ensuring users experience minimal loading times.

Offline Access - Ever lost a connection while using a traditional website? PWAs have your back. They work offline or in areas with poor connectivity, keeping essential features functional.

No Downloads Needed - Forget app store clutter. PWAs are lightweight and can be installed directly from the browser, saving storage space and time.

Cross-Platform Compatibility - Whether you’re on Android, iOS, Mac, Linux or Windows, PWAs adapt seamlessly, offering a consistent experience across devices.

Automatic Updates - Say goodbye to those constant “update now” notifications. PWAs update in the background, ensuring users always have the latest version.

Why Should Businesses Care?

For businesses, PWAs offer a golden opportunity to boost engagement and conversion rates. Their speed and reliability reduce bounce rates, while offline functionality ensures users stay connected with your brand. Moreover, PWAs are more cost-effective to develop and maintain compared to traditional apps, making them a win-win for businesses of all sizes.

The Ultimate Goal: Democratizing the Web

At its core, the goal of PWA technology is simple yet profound: to make the web more accessible, reliable, and engaging for everyone. By eliminating the friction between web and app experiences, PWAs empower users and developers alike, creating a more unified digital ecosystem.

In a world where user expectations are at an all-time high, PWAs are a game-changer, proving that the web can be as dynamic and powerful as any app. Ready to join the revolution? Start exploring the world of Progressive Web Apps today with Nanocell-CSV, a spreadsheet editor PWA!

Let's discuss in the comments:

Are you using this tech, and what for?

Do you think PWAs have a promising future ?

Is it ok to post a same article periodically (say once per month)? What's the etiquette about that?

Cedric Bonjour — Fri, 17 Jan 2025 06:47:41 +0000

New to dev.to: what is the etiquette about posting around here?

Cedric Bonjour — Sat, 11 Jan 2025 21:56:16 +0000