<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Cedric Bonjour</title>
    <description>The latest articles on DEV Community by Cedric Bonjour (@cedric_bonjour).</description>
    <link>https://dev.to/cedric_bonjour</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F2633226%2F047cc8d4-6add-42c8-b250-fa189dc4f3ac.png</url>
      <title>DEV Community: Cedric Bonjour</title>
      <link>https://dev.to/cedric_bonjour</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/cedric_bonjour"/>
    <language>en</language>
    <item>
      <title>Why Spreadsheets Corrupt CSV Files (And Why Plain-Text Matters)</title>
      <dc:creator>Cedric Bonjour</dc:creator>
      <pubDate>Wed, 11 Nov 2026 22:22:38 +0000</pubDate>
      <link>https://dev.to/cedric_bonjour/why-spreadsheets-corrupt-csv-files-and-why-plain-text-matters-1k9e</link>
      <guid>https://dev.to/cedric_bonjour/why-spreadsheets-corrupt-csv-files-and-why-plain-text-matters-1k9e</guid>
      <description>&lt;blockquote&gt;
&lt;p&gt;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, why do they feel so painful to work with?&lt;/p&gt;
&lt;/blockquote&gt;

&lt;h2&gt;
  
  
  What Are CSV Files (a quick reminder)?
&lt;/h2&gt;

&lt;p&gt;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.&lt;/p&gt;

&lt;p&gt;CSV stands for &lt;strong&gt;Comma-Separated Values&lt;/strong&gt;. At its core, it's a plain text file where data is organized into rows and columns, with commas (or other delimiters like semicolons, tabs, or pipes) acting as the dividers. For example:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;Name, Age, Favorite Food
Alice, 30, Pizza
Bob, 25, Sushi
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;blockquote&gt;
&lt;p&gt;A plain-text file of tabular data&lt;br&gt;
Columns of each row are delimited by commas&lt;br&gt;
Hence the name, CSV: Comma-Separated Values&lt;/p&gt;
&lt;/blockquote&gt;

&lt;h2&gt;
  
  
  What Are CSV Files Used for Today?
&lt;/h2&gt;

&lt;p&gt;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 ETL (Extract, Transform, Load) pipelines, 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 cleanly with Python, Pandas, DuckDB, R, and SQL for data analysts and data scientists training machine learning models. Many APIs offer CSV as an exchange format due to its simplicity, and its text-based structure makes it a popular choice on GitHub, where developers store configuration tables or test datasets in repositories. Finally, it remains the go-to format for publishing open datasets.&lt;/p&gt;

&lt;blockquote&gt;
&lt;p&gt;Database import/export, backup &amp;amp; API exchange&lt;br&gt;
Input format for data analysis &amp;amp; modeling tools&lt;br&gt;
Configuration tables in source control&lt;br&gt;
... Just about anything&lt;/p&gt;
&lt;/blockquote&gt;

&lt;h2&gt;
  
  
  Why Do CSV Files Remain Truly Indispensable?
&lt;/h2&gt;

&lt;p&gt;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 proprietary software to open, read, and understand a CSV file—any lightweight text editor will do (Notepad, Vim, Emacs, VS Code). You can even inspect its content directly from the command line: &lt;code&gt;cat ./path-to/filename.csv&lt;/code&gt;. It is the only tabular file format guaranteed to interface seamlessly with virtually every data handling system, from legacy mainframes to modern cloud warehouses. While XML, Parquet, and JSON each have their place, when it comes to universal human-readable longevity, CSV is unmatched.&lt;/p&gt;

&lt;blockquote&gt;
&lt;p&gt;Simple&lt;br&gt;
Reliable&lt;br&gt;
Timeless&lt;br&gt;
Human-Readable&lt;br&gt;
Universal&lt;/p&gt;
&lt;/blockquote&gt;

&lt;h2&gt;
  
  
  Common Problems Working with CSV Files
&lt;/h2&gt;

&lt;p&gt;Working with CSVs isn't always smooth sailing. Here are the most common pain points:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fjgyc3t8ipdlq372p9na9.webp" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fjgyc3t8ipdlq372p9na9.webp" alt="csv file as atlas god" width="800" height="420"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Encoding Nightmares:&lt;/strong&gt; Non-ASCII characters (such as &lt;code&gt;é&lt;/code&gt;, &lt;code&gt;ü&lt;/code&gt;, or CJK scripts) get garbled when an editor guesses the wrong character encoding instead of properly detecting &lt;code&gt;UTF-8&lt;/code&gt;, &lt;code&gt;UTF-16LE/BE&lt;/code&gt;, &lt;code&gt;Shift-JIS&lt;/code&gt;, &lt;code&gt;GB18030&lt;/code&gt;, or &lt;code&gt;Windows-1251/1252&lt;/code&gt;.&lt;br&gt;
&lt;strong&gt;Comma &amp;amp; Quote Confusion:&lt;/strong&gt; Unescaped commas, double quotes, or embedded line breaks inside cell values can silently shift columns and break downstream RFC 4180 parsers.&lt;br&gt;
&lt;strong&gt;Regional Delimiter Collisions:&lt;/strong&gt; In many European locales where commas are used as decimal separators (&lt;code&gt;1,25&lt;/code&gt;), spreadsheets export semicolon-delimited (&lt;code&gt;;&lt;/code&gt;) files that fail to open cleanly in comma-expecting tools.&lt;br&gt;
&lt;strong&gt;Silent Data Corruption in Spreadsheets:&lt;/strong&gt; Microsoft Excel, Google Sheets, LibreOffice Calc, and Apple Numbers are built for financial modeling—not verbatim text editing. The moment you open a CSV, they automatically cast values into numbers, dates, and formulas: stripping leading zeros from postal codes (&lt;code&gt;"02138"&lt;/code&gt; becomes &lt;code&gt;2138&lt;/code&gt;), turning international phone numbers (&lt;code&gt;"+41 79 123 45 67"&lt;/code&gt;) into &lt;code&gt;#NAME?&lt;/code&gt; formula errors, converting alphanumeric SKUs (&lt;code&gt;"84E02"&lt;/code&gt; or &lt;code&gt;"10-12"&lt;/code&gt;) into scientific notation or calendar dates, and truncating 64-bit IDs beyond 15 digits. On top of that, multi-gigabyte database extracts freeze or truncate at 1,048,576 rows.&lt;/p&gt;

&lt;h2&gt;
  
  
  Essential Yet Painful to Work With – Why?
&lt;/h2&gt;

&lt;p&gt;If CSV files are so important and universal, why does it feel so risky to open them in a standard spreadsheet editor?&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;Spreadsheet suites compete on complex formulas, charts, and pivot tables.&lt;/li&gt;
&lt;li&gt;Those features rely on aggressive automatic type inference and proprietary file formats (&lt;code&gt;.xlsx&lt;/code&gt;, &lt;code&gt;.numbers&lt;/code&gt;).&lt;/li&gt;
&lt;li&gt;Plain-text CSV handling is treated as an import/export afterthought rather than a first-class verbatim format.&lt;/li&gt;
&lt;li&gt;Users are left without a fast, dedicated CSV editor that respects raw text.&lt;/li&gt;
&lt;/ol&gt;

&lt;h2&gt;
  
  
  The Solution: A Dedicated Verbatim CSV Editor
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://nanocell-csv.com/" rel="noopener noreferrer"&gt;NanoCell CSV&lt;/a&gt; is a free, open-source, cross-platform editor built specifically for &lt;code&gt;.csv&lt;/code&gt; and &lt;code&gt;.tsv&lt;/code&gt; files. Its source code is available on &lt;a href="https://github.com/CedricBonjour/nanocell-csv" rel="noopener noreferrer"&gt;GitHub&lt;/a&gt;. Every cell is treated as 100% verbatim text by default, multi-gigabyte files preview in milliseconds via background Web Worker interval sampling, and built-in validation rules clean up headers, currencies, locale numbers, and dates in one click—running 100% locally in your browser or as an offline Desktop PWA.&lt;/p&gt;

&lt;blockquote&gt;
&lt;p&gt;&lt;a href="https://nanocell-csv.com/" rel="noopener noreferrer"&gt;NanoCell CSV&lt;/a&gt; embraces the core values of CSV:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Simple&lt;/li&gt;
&lt;li&gt;Reliable&lt;/li&gt;
&lt;li&gt;Universal&lt;/li&gt;
&lt;/ul&gt;
&lt;/blockquote&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Ftx05bsqz6jukvzjniklf.webp" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Ftx05bsqz6jukvzjniklf.webp" alt="nanocell-logo" width="800" height="450"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Find out more at &lt;a href="https://nanocell-csv.com/" rel="noopener noreferrer"&gt;https://nanocell-csv.com/&lt;/a&gt;&lt;/p&gt;

</description>
      <category>data</category>
      <category>productivity</category>
      <category>opensource</category>
      <category>showdev</category>
    </item>
    <item>
      <title>[Boost]</title>
      <dc:creator>Cedric Bonjour</dc:creator>
      <pubDate>Mon, 25 May 2026 22:21:36 +0000</pubDate>
      <link>https://dev.to/cedric_bonjour/-318k</link>
      <guid>https://dev.to/cedric_bonjour/-318k</guid>
      <description>&lt;div class="ltag__link--embedded"&gt;
  &lt;div class="crayons-story "&gt;
  &lt;a href="https://dev.to/cedric_bonjour/why-does-editing-csv-files-always-feel-so-difficult-1hmh" class="crayons-story__hidden-navigation-link"&gt;Why Does Editing CSV Files Always Feel So Difficult?&lt;/a&gt;


  &lt;div class="crayons-story__body crayons-story__body-full_post"&gt;
    &lt;div class="crayons-story__top"&gt;
      &lt;div class="crayons-story__meta"&gt;
        &lt;div class="crayons-story__author-pic"&gt;

          &lt;a href="/cedric_bonjour" class="crayons-avatar  crayons-avatar--l  "&gt;
            &lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F2633226%2F047cc8d4-6add-42c8-b250-fa189dc4f3ac.png" alt="cedric_bonjour profile" class="crayons-avatar__image"&gt;
          &lt;/a&gt;
        &lt;/div&gt;
        &lt;div&gt;
          &lt;div&gt;
            &lt;a href="/cedric_bonjour" class="crayons-story__secondary fw-medium m:hidden"&gt;
              Cedric Bonjour
            &lt;/a&gt;
            &lt;div class="profile-preview-card relative mb-4 s:mb-0 fw-medium hidden m:inline-block"&gt;
              
                Cedric Bonjour
                
                
              
              &lt;div id="story-author-preview-content-2226066" class="profile-preview-card__content crayons-dropdown branded-7 p-4 pt-0"&gt;
                &lt;div class="gap-4 grid"&gt;
                  &lt;div class="-mt-4"&gt;
                    &lt;a href="/cedric_bonjour" class="flex"&gt;
                      &lt;span class="crayons-avatar crayons-avatar--xl mr-2 shrink-0"&gt;
                        &lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F2633226%2F047cc8d4-6add-42c8-b250-fa189dc4f3ac.png" class="crayons-avatar__image" alt=""&gt;
                      &lt;/span&gt;
                      &lt;span class="crayons-link crayons-subtitle-2 mt-5"&gt;Cedric Bonjour&lt;/span&gt;
                    &lt;/a&gt;
                  &lt;/div&gt;
                  &lt;div class="print-hidden"&gt;
                    
                      Follow
                    
                  &lt;/div&gt;
                  &lt;div class="author-preview-metadata-container"&gt;&lt;/div&gt;
                &lt;/div&gt;
              &lt;/div&gt;
            &lt;/div&gt;

          &lt;/div&gt;
          &lt;a href="https://dev.to/cedric_bonjour/why-does-editing-csv-files-always-feel-so-difficult-1hmh" class="crayons-story__tertiary fs-xs"&gt;&lt;time&gt;Jan 20 '25&lt;/time&gt;&lt;span class="time-ago-indicator-initial-placeholder"&gt;&lt;/span&gt;&lt;/a&gt;
        &lt;/div&gt;
      &lt;/div&gt;

    &lt;/div&gt;

    &lt;div class="crayons-story__indention"&gt;
      &lt;h2 class="crayons-story__title crayons-story__title-full_post"&gt;
        &lt;a href="https://dev.to/cedric_bonjour/why-does-editing-csv-files-always-feel-so-difficult-1hmh" id="article-link-2226066"&gt;
          Why Does Editing CSV Files Always Feel So Difficult?
        &lt;/a&gt;
      &lt;/h2&gt;
        &lt;div class="crayons-story__tags"&gt;
            &lt;a class="crayons-tag  crayons-tag--monochrome " href="/t/productivity"&gt;&lt;span class="crayons-tag__prefix"&gt;#&lt;/span&gt;productivity&lt;/a&gt;
            &lt;a class="crayons-tag  crayons-tag--monochrome " href="/t/github"&gt;&lt;span class="crayons-tag__prefix"&gt;#&lt;/span&gt;github&lt;/a&gt;
            &lt;a class="crayons-tag  crayons-tag--monochrome " href="/t/database"&gt;&lt;span class="crayons-tag__prefix"&gt;#&lt;/span&gt;database&lt;/a&gt;
            &lt;a class="crayons-tag  crayons-tag--monochrome " href="/t/datascience"&gt;&lt;span class="crayons-tag__prefix"&gt;#&lt;/span&gt;datascience&lt;/a&gt;
        &lt;/div&gt;
      &lt;div class="crayons-story__bottom"&gt;
        &lt;div class="crayons-story__details"&gt;
          &lt;a href="https://dev.to/cedric_bonjour/why-does-editing-csv-files-always-feel-so-difficult-1hmh" class="crayons-btn crayons-btn--s crayons-btn--ghost crayons-btn--icon-left"&gt;
            &lt;div class="multiple_reactions_aggregate"&gt;
              &lt;span class="multiple_reactions_icons_container"&gt;
                  &lt;span class="crayons_icon_container"&gt;
                    &lt;img src="https://assets.dev.to/assets/exploding-head-daceb38d627e6ae9b730f36a1e390fca556a4289d5a41abb2c35068ad3e2c4b5.svg" width="18" height="18"&gt;
                  &lt;/span&gt;
                  &lt;span class="crayons_icon_container"&gt;
                    &lt;img src="https://assets.dev.to/assets/multi-unicorn-b44d6f8c23cdd00964192bedc38af3e82463978aa611b4365bd33a0f1f4f3e97.svg" width="18" height="18"&gt;
                  &lt;/span&gt;
                  &lt;span class="crayons_icon_container"&gt;
                    &lt;img src="https://assets.dev.to/assets/sparkle-heart-5f9bee3767e18deb1bb725290cb151c25234768a0e9a2bd39370c382d02920cf.svg" width="18" height="18"&gt;
                  &lt;/span&gt;
              &lt;/span&gt;
              &lt;span class="aggregate_reactions_counter"&gt;18&lt;span class="hidden s:inline"&gt;&amp;nbsp;reactions&lt;/span&gt;&lt;/span&gt;
            &lt;/div&gt;
          &lt;/a&gt;
            &lt;a href="https://dev.to/cedric_bonjour/why-does-editing-csv-files-always-feel-so-difficult-1hmh#comments" class="crayons-btn crayons-btn--s crayons-btn--ghost crayons-btn--icon-left flex items-center"&gt;
              

              12&lt;span class="hidden s:inline"&gt;&amp;nbsp;comments&lt;/span&gt;
            &lt;/a&gt;
        &lt;/div&gt;
        &lt;div class="crayons-story__save"&gt;
          &lt;small class="crayons-story__tertiary fs-xs mr-2"&gt;
            4 min read
          &lt;/small&gt;
          
          &lt;div class="only-sidebar-menu-item trusted-visible-block print-hidden align-center"&gt;
                
                    
                
          &lt;/div&gt;

        &lt;/div&gt;
      &lt;/div&gt;
    &lt;/div&gt;
  &lt;/div&gt;
&lt;/div&gt;

&lt;/div&gt;


</description>
    </item>
    <item>
      <title>[Boost]</title>
      <dc:creator>Cedric Bonjour</dc:creator>
      <pubDate>Fri, 25 Jul 2025 20:02:07 +0000</pubDate>
      <link>https://dev.to/cedric_bonjour/-452c</link>
      <guid>https://dev.to/cedric_bonjour/-452c</guid>
      <description>&lt;div class="ltag__link--embedded"&gt;
  &lt;div class="crayons-story "&gt;
  &lt;a href="https://dev.to/cedric_bonjour/why-does-editing-csv-files-always-feel-so-difficult-1hmh" class="crayons-story__hidden-navigation-link"&gt;Why Does Editing CSV Files Always Feel So Difficult?&lt;/a&gt;


  &lt;div class="crayons-story__body crayons-story__body-full_post"&gt;
    &lt;div class="crayons-story__top"&gt;
      &lt;div class="crayons-story__meta"&gt;
        &lt;div class="crayons-story__author-pic"&gt;

          &lt;a href="/cedric_bonjour" class="crayons-avatar  crayons-avatar--l  "&gt;
            &lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F2633226%2F047cc8d4-6add-42c8-b250-fa189dc4f3ac.png" alt="cedric_bonjour profile" class="crayons-avatar__image"&gt;
          &lt;/a&gt;
        &lt;/div&gt;
        &lt;div&gt;
          &lt;div&gt;
            &lt;a href="/cedric_bonjour" class="crayons-story__secondary fw-medium m:hidden"&gt;
              Cedric Bonjour
            &lt;/a&gt;
            &lt;div class="profile-preview-card relative mb-4 s:mb-0 fw-medium hidden m:inline-block"&gt;
              
                Cedric Bonjour
                
                
              
              &lt;div id="story-author-preview-content-2226066" class="profile-preview-card__content crayons-dropdown branded-7 p-4 pt-0"&gt;
                &lt;div class="gap-4 grid"&gt;
                  &lt;div class="-mt-4"&gt;
                    &lt;a href="/cedric_bonjour" class="flex"&gt;
                      &lt;span class="crayons-avatar crayons-avatar--xl mr-2 shrink-0"&gt;
                        &lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F2633226%2F047cc8d4-6add-42c8-b250-fa189dc4f3ac.png" class="crayons-avatar__image" alt=""&gt;
                      &lt;/span&gt;
                      &lt;span class="crayons-link crayons-subtitle-2 mt-5"&gt;Cedric Bonjour&lt;/span&gt;
                    &lt;/a&gt;
                  &lt;/div&gt;
                  &lt;div class="print-hidden"&gt;
                    
                      Follow
                    
                  &lt;/div&gt;
                  &lt;div class="author-preview-metadata-container"&gt;&lt;/div&gt;
                &lt;/div&gt;
              &lt;/div&gt;
            &lt;/div&gt;

          &lt;/div&gt;
          &lt;a href="https://dev.to/cedric_bonjour/why-does-editing-csv-files-always-feel-so-difficult-1hmh" class="crayons-story__tertiary fs-xs"&gt;&lt;time&gt;Jan 20 '25&lt;/time&gt;&lt;span class="time-ago-indicator-initial-placeholder"&gt;&lt;/span&gt;&lt;/a&gt;
        &lt;/div&gt;
      &lt;/div&gt;

    &lt;/div&gt;

    &lt;div class="crayons-story__indention"&gt;
      &lt;h2 class="crayons-story__title crayons-story__title-full_post"&gt;
        &lt;a href="https://dev.to/cedric_bonjour/why-does-editing-csv-files-always-feel-so-difficult-1hmh" id="article-link-2226066"&gt;
          Why Does Editing CSV Files Always Feel So Difficult?
        &lt;/a&gt;
      &lt;/h2&gt;
        &lt;div class="crayons-story__tags"&gt;
            &lt;a class="crayons-tag  crayons-tag--monochrome " href="/t/productivity"&gt;&lt;span class="crayons-tag__prefix"&gt;#&lt;/span&gt;productivity&lt;/a&gt;
            &lt;a class="crayons-tag  crayons-tag--monochrome " href="/t/github"&gt;&lt;span class="crayons-tag__prefix"&gt;#&lt;/span&gt;github&lt;/a&gt;
            &lt;a class="crayons-tag  crayons-tag--monochrome " href="/t/database"&gt;&lt;span class="crayons-tag__prefix"&gt;#&lt;/span&gt;database&lt;/a&gt;
            &lt;a class="crayons-tag  crayons-tag--monochrome " href="/t/datascience"&gt;&lt;span class="crayons-tag__prefix"&gt;#&lt;/span&gt;datascience&lt;/a&gt;
        &lt;/div&gt;
      &lt;div class="crayons-story__bottom"&gt;
        &lt;div class="crayons-story__details"&gt;
          &lt;a href="https://dev.to/cedric_bonjour/why-does-editing-csv-files-always-feel-so-difficult-1hmh" class="crayons-btn crayons-btn--s crayons-btn--ghost crayons-btn--icon-left"&gt;
            &lt;div class="multiple_reactions_aggregate"&gt;
              &lt;span class="multiple_reactions_icons_container"&gt;
                  &lt;span class="crayons_icon_container"&gt;
                    &lt;img src="https://assets.dev.to/assets/exploding-head-daceb38d627e6ae9b730f36a1e390fca556a4289d5a41abb2c35068ad3e2c4b5.svg" width="18" height="18"&gt;
                  &lt;/span&gt;
                  &lt;span class="crayons_icon_container"&gt;
                    &lt;img src="https://assets.dev.to/assets/multi-unicorn-b44d6f8c23cdd00964192bedc38af3e82463978aa611b4365bd33a0f1f4f3e97.svg" width="18" height="18"&gt;
                  &lt;/span&gt;
                  &lt;span class="crayons_icon_container"&gt;
                    &lt;img src="https://assets.dev.to/assets/sparkle-heart-5f9bee3767e18deb1bb725290cb151c25234768a0e9a2bd39370c382d02920cf.svg" width="18" height="18"&gt;
                  &lt;/span&gt;
              &lt;/span&gt;
              &lt;span class="aggregate_reactions_counter"&gt;18&lt;span class="hidden s:inline"&gt;&amp;nbsp;reactions&lt;/span&gt;&lt;/span&gt;
            &lt;/div&gt;
          &lt;/a&gt;
            &lt;a href="https://dev.to/cedric_bonjour/why-does-editing-csv-files-always-feel-so-difficult-1hmh#comments" class="crayons-btn crayons-btn--s crayons-btn--ghost crayons-btn--icon-left flex items-center"&gt;
              

              12&lt;span class="hidden s:inline"&gt;&amp;nbsp;comments&lt;/span&gt;
            &lt;/a&gt;
        &lt;/div&gt;
        &lt;div class="crayons-story__save"&gt;
          &lt;small class="crayons-story__tertiary fs-xs mr-2"&gt;
            4 min read
          &lt;/small&gt;
          
          &lt;div class="only-sidebar-menu-item trusted-visible-block print-hidden align-center"&gt;
                
                    
                
          &lt;/div&gt;

        &lt;/div&gt;
      &lt;/div&gt;
    &lt;/div&gt;
  &lt;/div&gt;
&lt;/div&gt;

&lt;/div&gt;


</description>
      <category>productivity</category>
      <category>github</category>
      <category>database</category>
      <category>datascience</category>
    </item>
    <item>
      <title>[Boost]</title>
      <dc:creator>Cedric Bonjour</dc:creator>
      <pubDate>Wed, 14 May 2025 05:20:09 +0000</pubDate>
      <link>https://dev.to/cedric_bonjour/-ab2</link>
      <guid>https://dev.to/cedric_bonjour/-ab2</guid>
      <description>&lt;div class="ltag__link--embedded"&gt;
  &lt;div class="crayons-story "&gt;
  &lt;a href="https://dev.to/cedric_bonjour/why-does-editing-csv-files-always-feel-so-difficult-1hmh" class="crayons-story__hidden-navigation-link"&gt;Why Does Editing CSV Files Always Feel So Difficult?&lt;/a&gt;


  &lt;div class="crayons-story__body crayons-story__body-full_post"&gt;
    &lt;div class="crayons-story__top"&gt;
      &lt;div class="crayons-story__meta"&gt;
        &lt;div class="crayons-story__author-pic"&gt;

          &lt;a href="/cedric_bonjour" class="crayons-avatar  crayons-avatar--l  "&gt;
            &lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F2633226%2F047cc8d4-6add-42c8-b250-fa189dc4f3ac.png" alt="cedric_bonjour profile" class="crayons-avatar__image"&gt;
          &lt;/a&gt;
        &lt;/div&gt;
        &lt;div&gt;
          &lt;div&gt;
            &lt;a href="/cedric_bonjour" class="crayons-story__secondary fw-medium m:hidden"&gt;
              Cedric Bonjour
            &lt;/a&gt;
            &lt;div class="profile-preview-card relative mb-4 s:mb-0 fw-medium hidden m:inline-block"&gt;
              
                Cedric Bonjour
                
                
              
              &lt;div id="story-author-preview-content-2226066" class="profile-preview-card__content crayons-dropdown branded-7 p-4 pt-0"&gt;
                &lt;div class="gap-4 grid"&gt;
                  &lt;div class="-mt-4"&gt;
                    &lt;a href="/cedric_bonjour" class="flex"&gt;
                      &lt;span class="crayons-avatar crayons-avatar--xl mr-2 shrink-0"&gt;
                        &lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F2633226%2F047cc8d4-6add-42c8-b250-fa189dc4f3ac.png" class="crayons-avatar__image" alt=""&gt;
                      &lt;/span&gt;
                      &lt;span class="crayons-link crayons-subtitle-2 mt-5"&gt;Cedric Bonjour&lt;/span&gt;
                    &lt;/a&gt;
                  &lt;/div&gt;
                  &lt;div class="print-hidden"&gt;
                    
                      Follow
                    
                  &lt;/div&gt;
                  &lt;div class="author-preview-metadata-container"&gt;&lt;/div&gt;
                &lt;/div&gt;
              &lt;/div&gt;
            &lt;/div&gt;

          &lt;/div&gt;
          &lt;a href="https://dev.to/cedric_bonjour/why-does-editing-csv-files-always-feel-so-difficult-1hmh" class="crayons-story__tertiary fs-xs"&gt;&lt;time&gt;Jan 20 '25&lt;/time&gt;&lt;span class="time-ago-indicator-initial-placeholder"&gt;&lt;/span&gt;&lt;/a&gt;
        &lt;/div&gt;
      &lt;/div&gt;

    &lt;/div&gt;

    &lt;div class="crayons-story__indention"&gt;
      &lt;h2 class="crayons-story__title crayons-story__title-full_post"&gt;
        &lt;a href="https://dev.to/cedric_bonjour/why-does-editing-csv-files-always-feel-so-difficult-1hmh" id="article-link-2226066"&gt;
          Why Does Editing CSV Files Always Feel So Difficult?
        &lt;/a&gt;
      &lt;/h2&gt;
        &lt;div class="crayons-story__tags"&gt;
            &lt;a class="crayons-tag  crayons-tag--monochrome " href="/t/productivity"&gt;&lt;span class="crayons-tag__prefix"&gt;#&lt;/span&gt;productivity&lt;/a&gt;
            &lt;a class="crayons-tag  crayons-tag--monochrome " href="/t/github"&gt;&lt;span class="crayons-tag__prefix"&gt;#&lt;/span&gt;github&lt;/a&gt;
            &lt;a class="crayons-tag  crayons-tag--monochrome " href="/t/database"&gt;&lt;span class="crayons-tag__prefix"&gt;#&lt;/span&gt;database&lt;/a&gt;
            &lt;a class="crayons-tag  crayons-tag--monochrome " href="/t/datascience"&gt;&lt;span class="crayons-tag__prefix"&gt;#&lt;/span&gt;datascience&lt;/a&gt;
        &lt;/div&gt;
      &lt;div class="crayons-story__bottom"&gt;
        &lt;div class="crayons-story__details"&gt;
          &lt;a href="https://dev.to/cedric_bonjour/why-does-editing-csv-files-always-feel-so-difficult-1hmh" class="crayons-btn crayons-btn--s crayons-btn--ghost crayons-btn--icon-left"&gt;
            &lt;div class="multiple_reactions_aggregate"&gt;
              &lt;span class="multiple_reactions_icons_container"&gt;
                  &lt;span class="crayons_icon_container"&gt;
                    &lt;img src="https://assets.dev.to/assets/exploding-head-daceb38d627e6ae9b730f36a1e390fca556a4289d5a41abb2c35068ad3e2c4b5.svg" width="18" height="18"&gt;
                  &lt;/span&gt;
                  &lt;span class="crayons_icon_container"&gt;
                    &lt;img src="https://assets.dev.to/assets/multi-unicorn-b44d6f8c23cdd00964192bedc38af3e82463978aa611b4365bd33a0f1f4f3e97.svg" width="18" height="18"&gt;
                  &lt;/span&gt;
                  &lt;span class="crayons_icon_container"&gt;
                    &lt;img src="https://assets.dev.to/assets/sparkle-heart-5f9bee3767e18deb1bb725290cb151c25234768a0e9a2bd39370c382d02920cf.svg" width="18" height="18"&gt;
                  &lt;/span&gt;
              &lt;/span&gt;
              &lt;span class="aggregate_reactions_counter"&gt;18&lt;span class="hidden s:inline"&gt;&amp;nbsp;reactions&lt;/span&gt;&lt;/span&gt;
            &lt;/div&gt;
          &lt;/a&gt;
            &lt;a href="https://dev.to/cedric_bonjour/why-does-editing-csv-files-always-feel-so-difficult-1hmh#comments" class="crayons-btn crayons-btn--s crayons-btn--ghost crayons-btn--icon-left flex items-center"&gt;
              

              12&lt;span class="hidden s:inline"&gt;&amp;nbsp;comments&lt;/span&gt;
            &lt;/a&gt;
        &lt;/div&gt;
        &lt;div class="crayons-story__save"&gt;
          &lt;small class="crayons-story__tertiary fs-xs mr-2"&gt;
            4 min read
          &lt;/small&gt;
          
          &lt;div class="only-sidebar-menu-item trusted-visible-block print-hidden align-center"&gt;
                
                    
                
          &lt;/div&gt;

        &lt;/div&gt;
      &lt;/div&gt;
    &lt;/div&gt;
  &lt;/div&gt;
&lt;/div&gt;

&lt;/div&gt;


</description>
      <category>productivity</category>
      <category>github</category>
      <category>database</category>
      <category>datascience</category>
    </item>
    <item>
      <title>[Boost]</title>
      <dc:creator>Cedric Bonjour</dc:creator>
      <pubDate>Wed, 26 Mar 2025 08:12:02 +0000</pubDate>
      <link>https://dev.to/cedric_bonjour/-2icb</link>
      <guid>https://dev.to/cedric_bonjour/-2icb</guid>
      <description>&lt;div class="ltag__link"&gt;
  &lt;a href="/cedric_bonjour" class="ltag__link__link"&gt;
    &lt;div class="ltag__link__pic"&gt;
      &lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F2633226%2F047cc8d4-6add-42c8-b250-fa189dc4f3ac.png" alt="cedric_bonjour"&gt;
    &lt;/div&gt;
  &lt;/a&gt;
  &lt;a href="https://dev.to/cedric_bonjour/why-does-editing-csv-files-always-feel-so-difficult-1hmh" class="ltag__link__link"&gt;
    &lt;div class="ltag__link__content"&gt;
      &lt;h2&gt;Why Does Editing CSV Files Always Feel So Difficult?&lt;/h2&gt;
      &lt;h3&gt;Cedric Bonjour ・ Jan 20&lt;/h3&gt;
      &lt;div class="ltag__link__taglist"&gt;
        &lt;span class="ltag__link__tag"&gt;#productivity&lt;/span&gt;
        &lt;span class="ltag__link__tag"&gt;#github&lt;/span&gt;
        &lt;span class="ltag__link__tag"&gt;#database&lt;/span&gt;
        &lt;span class="ltag__link__tag"&gt;#datascience&lt;/span&gt;
      &lt;/div&gt;
    &lt;/div&gt;
  &lt;/a&gt;
&lt;/div&gt;


</description>
      <category>productivity</category>
      <category>github</category>
      <category>database</category>
      <category>datascience</category>
    </item>
    <item>
      <title>[Boost]</title>
      <dc:creator>Cedric Bonjour</dc:creator>
      <pubDate>Mon, 10 Feb 2025 18:18:05 +0000</pubDate>
      <link>https://dev.to/cedric_bonjour/-2ia3</link>
      <guid>https://dev.to/cedric_bonjour/-2ia3</guid>
      <description>&lt;div class="ltag__link"&gt;
  &lt;a href="/cedric_bonjour" class="ltag__link__link"&gt;
    &lt;div class="ltag__link__pic"&gt;
      &lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F2633226%2F047cc8d4-6add-42c8-b250-fa189dc4f3ac.png" alt="cedric_bonjour"&gt;
    &lt;/div&gt;
  &lt;/a&gt;
  &lt;a href="https://dev.to/cedric_bonjour/why-does-editing-csv-files-always-feel-so-difficult-1hmh" class="ltag__link__link"&gt;
    &lt;div class="ltag__link__content"&gt;
      &lt;h2&gt;Why Does Editing CSV Files Always Feel So Difficult?&lt;/h2&gt;
      &lt;h3&gt;Cedric Bonjour ・ Jan 20&lt;/h3&gt;
      &lt;div class="ltag__link__taglist"&gt;
        &lt;span class="ltag__link__tag"&gt;#productivity&lt;/span&gt;
        &lt;span class="ltag__link__tag"&gt;#github&lt;/span&gt;
        &lt;span class="ltag__link__tag"&gt;#database&lt;/span&gt;
        &lt;span class="ltag__link__tag"&gt;#datascience&lt;/span&gt;
      &lt;/div&gt;
    &lt;/div&gt;
  &lt;/a&gt;
&lt;/div&gt;


</description>
      <category>productivity</category>
      <category>github</category>
      <category>database</category>
      <category>datascience</category>
    </item>
    <item>
      <title>[Boost]</title>
      <dc:creator>Cedric Bonjour</dc:creator>
      <pubDate>Mon, 03 Feb 2025 21:19:10 +0000</pubDate>
      <link>https://dev.to/cedric_bonjour/-2h5f</link>
      <guid>https://dev.to/cedric_bonjour/-2h5f</guid>
      <description>&lt;div class="ltag__link"&gt;
  &lt;a href="/cedric_bonjour" class="ltag__link__link"&gt;
    &lt;div class="ltag__link__pic"&gt;
      &lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F2633226%2F047cc8d4-6add-42c8-b250-fa189dc4f3ac.png" alt="cedric_bonjour"&gt;
    &lt;/div&gt;
  &lt;/a&gt;
  &lt;a href="https://dev.to/cedric_bonjour/why-does-editing-csv-files-always-feel-so-difficult-1hmh" class="ltag__link__link"&gt;
    &lt;div class="ltag__link__content"&gt;
      &lt;h2&gt;Why Does Editing CSV Files Always Feel So Difficult?&lt;/h2&gt;
      &lt;h3&gt;Cedric Bonjour ・ Jan 20&lt;/h3&gt;
      &lt;div class="ltag__link__taglist"&gt;
        &lt;span class="ltag__link__tag"&gt;#productivity&lt;/span&gt;
        &lt;span class="ltag__link__tag"&gt;#github&lt;/span&gt;
        &lt;span class="ltag__link__tag"&gt;#database&lt;/span&gt;
        &lt;span class="ltag__link__tag"&gt;#datascience&lt;/span&gt;
      &lt;/div&gt;
    &lt;/div&gt;
  &lt;/a&gt;
&lt;/div&gt;


</description>
      <category>productivity</category>
      <category>github</category>
      <category>database</category>
      <category>datascience</category>
    </item>
    <item>
      <title>Is it ok to post a same article periodically (say once per month)? What's the etiquette about that?</title>
      <dc:creator>Cedric Bonjour</dc:creator>
      <pubDate>Mon, 03 Feb 2025 17:53:57 +0000</pubDate>
      <link>https://dev.to/cedric_bonjour/is-it-ok-to-post-a-same-article-periodically-say-once-per-month-whats-the-etiquette-about-that-1nii</link>
      <guid>https://dev.to/cedric_bonjour/is-it-ok-to-post-a-same-article-periodically-say-once-per-month-whats-the-etiquette-about-that-1nii</guid>
      <description></description>
      <category>discuss</category>
    </item>
    <item>
      <title>Discuss : I've built a free csv file editing app (using PWA tech). How do I reach early adopters to build a user base?</title>
      <dc:creator>Cedric Bonjour</dc:creator>
      <pubDate>Tue, 28 Jan 2025 22:15:35 +0000</pubDate>
      <link>https://dev.to/cedric_bonjour/discuss-ive-build-a-free-csv-editing-app-using-pwa-tech-how-do-i-reach-early-adopters-to-59de</link>
      <guid>https://dev.to/cedric_bonjour/discuss-ive-build-a-free-csv-editing-app-using-pwa-tech-how-do-i-reach-early-adopters-to-59de</guid>
      <description></description>
      <category>discuss</category>
      <category>pwa</category>
      <category>webdev</category>
      <category>startup</category>
    </item>
    <item>
      <title>[Boost]</title>
      <dc:creator>Cedric Bonjour</dc:creator>
      <pubDate>Wed, 22 Jan 2025 13:01:47 +0000</pubDate>
      <link>https://dev.to/cedric_bonjour/-1lnl</link>
      <guid>https://dev.to/cedric_bonjour/-1lnl</guid>
      <description>&lt;div class="ltag__link"&gt;
  &lt;a href="/cedric_bonjour" class="ltag__link__link"&gt;
    &lt;div class="ltag__link__pic"&gt;
      &lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F2633226%2F047cc8d4-6add-42c8-b250-fa189dc4f3ac.png" alt="cedric_bonjour"&gt;
    &lt;/div&gt;
  &lt;/a&gt;
  &lt;a href="https://dev.to/cedric_bonjour/why-does-editing-csv-files-always-feel-so-difficult-1hmh" class="ltag__link__link"&gt;
    &lt;div class="ltag__link__content"&gt;
      &lt;h2&gt;Why Does Editing CSV Files Always Feel So Difficult?&lt;/h2&gt;
      &lt;h3&gt;Cedric Bonjour ・ Jan 20&lt;/h3&gt;
      &lt;div class="ltag__link__taglist"&gt;
        &lt;span class="ltag__link__tag"&gt;#productivity&lt;/span&gt;
        &lt;span class="ltag__link__tag"&gt;#github&lt;/span&gt;
        &lt;span class="ltag__link__tag"&gt;#database&lt;/span&gt;
        &lt;span class="ltag__link__tag"&gt;#datascience&lt;/span&gt;
      &lt;/div&gt;
    &lt;/div&gt;
  &lt;/a&gt;
&lt;/div&gt;


</description>
      <category>csv</category>
      <category>productivity</category>
      <category>discuss</category>
    </item>
    <item>
      <title>Why Does Editing CSV Files Always Feel So Difficult?</title>
      <dc:creator>Cedric Bonjour</dc:creator>
      <pubDate>Mon, 20 Jan 2025 07:14:39 +0000</pubDate>
      <link>https://dev.to/cedric_bonjour/why-does-editing-csv-files-always-feel-so-difficult-1hmh</link>
      <guid>https://dev.to/cedric_bonjour/why-does-editing-csv-files-always-feel-so-difficult-1hmh</guid>
      <description>&lt;blockquote&gt;
&lt;p&gt;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?&lt;/p&gt;
&lt;/blockquote&gt;

&lt;h2&gt;
  
  
  What Are CSV Files (a quick reminder) ?
&lt;/h2&gt;

&lt;p&gt;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. &lt;/p&gt;

&lt;p&gt;CSV stands for &lt;strong&gt;Comma-Separated Values&lt;/strong&gt;. 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:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;Name, Age, Favorite Food
Alice, 30, Pizza
Bob, 25, Sushi
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;blockquote&gt;
&lt;p&gt;A text file of tabular data&lt;br&gt;
Columns of each row are delimited by commas&lt;br&gt;
Hence the name, CSV: Comma-Separated Values&lt;/p&gt;
&lt;/blockquote&gt;

&lt;h2&gt;
  
  
  What Are CSV Files Used for Today ?
&lt;/h2&gt;

&lt;p&gt;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. &lt;/p&gt;

&lt;blockquote&gt;
&lt;p&gt;Database import/export, backup &amp;amp; API &lt;br&gt;
Input format to data analysis/modeling tools&lt;br&gt;
Configuration tables for code&lt;br&gt;&lt;br&gt;
... Just about anything&lt;/p&gt;
&lt;/blockquote&gt;

&lt;h2&gt;
  
  
  Why do CSV files remain truly indispensable?
&lt;/h2&gt;

&lt;p&gt;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: &lt;code&gt;cat ./path-to/filename.csv&lt;/code&gt;. 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.&lt;/p&gt;

&lt;blockquote&gt;
&lt;p&gt;Simple&lt;br&gt;
Reliable&lt;br&gt;
Timeless &lt;br&gt;
Human-Readable&lt;br&gt;
Universal&lt;/p&gt;
&lt;/blockquote&gt;

&lt;h2&gt;
  
  
  Common Problems Working with CSV Files
&lt;/h2&gt;

&lt;p&gt;Working with CSVs isn’t always smooth sailing. Here are some common gripes:&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Encoding Nightmares:&lt;/strong&gt; 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 &lt;code&gt;utf-8&lt;/code&gt;.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Comma Confusion:&lt;/strong&gt; What happens when your data values contain commas? (Spoiler: It can get messy if not handled with the right standard.)&lt;br&gt;
&lt;strong&gt;Standard misalignment:&lt;/strong&gt; 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.  &lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Misuse of Excel:&lt;/strong&gt; 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 &lt;code&gt;auto-save&lt;/code&gt; 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.&lt;/p&gt;

&lt;blockquote&gt;
&lt;p&gt;Poor tooling due to negligence in following standards&lt;/p&gt;
&lt;/blockquote&gt;

&lt;h2&gt;
  
  
  Essential Yet Painful to work with – Why?
&lt;/h2&gt;

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

&lt;p&gt;Here is a hypothesis: &lt;/p&gt;

&lt;blockquote&gt;
&lt;ol&gt;
&lt;li&gt;A spreadsheet editor needs a fancy feature to differentiate itself and be competitive. &lt;/li&gt;
&lt;li&gt;Fancy features require complexity that CSV files can't handle.&lt;/li&gt;
&lt;li&gt;Editors come up with a proprietary file format to enable this differenciation.&lt;/li&gt;
&lt;li&gt;Editors leave out CSV file handling (more or less purposly) to push their user base towards their proprietary format.&lt;/li&gt;
&lt;li&gt;Users can't find a descent CSV file editor.&lt;/li&gt;
&lt;/ol&gt;
&lt;/blockquote&gt;

&lt;h2&gt;
  
  
  The solution: An alternative spreadsheet editor dedicated to CSV files
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://www.nanocell-csv.com/" rel="noopener noreferrer"&gt;Nanocell-csv&lt;/a&gt; is a free, cross platform, spreadsheet editor dedicated to CSV files. Its source code is available on &lt;a href="https://github.com/CedricBonjour/nanocell-csv" rel="noopener noreferrer"&gt;Github&lt;/a&gt; to be community driven. &lt;a href="https://www.nanocell-csv.com/" rel="noopener noreferrer"&gt;Nanocell-csv&lt;/a&gt;, pledges to focus only on CSV files and their real-world use cases. &lt;/p&gt;

&lt;blockquote&gt;
&lt;p&gt;The &lt;a href="https://www.nanocell-csv.com/" rel="noopener noreferrer"&gt;Nanocell-csv&lt;/a&gt; file editor strives to embrace CSV core values: &lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Simple &lt;/li&gt;
&lt;li&gt;Reliable&lt;/li&gt;
&lt;li&gt;Universal &lt;/li&gt;
&lt;/ul&gt;
&lt;/blockquote&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fwww.nanocell-csv.com%2Fimg%2Fscreenshot%2Fscreenshot_light_logo.webp" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fwww.nanocell-csv.com%2Fimg%2Fscreenshot%2Fscreenshot_light_logo.webp" alt="nanocell-logo" width="800" height="420"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Find out more at &lt;a href="https://www.nanocell-csv.com/" rel="noopener noreferrer"&gt;https://www.nanocell-csv.com/&lt;/a&gt;&lt;/p&gt;

</description>
      <category>productivity</category>
      <category>github</category>
      <category>database</category>
      <category>datascience</category>
    </item>
    <item>
      <title>Progressive Web Apps: Revolutionizing the Way We Experience the Web</title>
      <dc:creator>Cedric Bonjour</dc:creator>
      <pubDate>Fri, 17 Jan 2025 11:01:53 +0000</pubDate>
      <link>https://dev.to/cedric_bonjour/progressive-web-apps-revolutionizing-the-way-we-experience-the-web-32hl</link>
      <guid>https://dev.to/cedric_bonjour/progressive-web-apps-revolutionizing-the-way-we-experience-the-web-32hl</guid>
      <description>&lt;blockquote&gt;
&lt;p&gt;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.&lt;/p&gt;
&lt;/blockquote&gt;

&lt;p&gt;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 &lt;a href="https://www.nanocell-csv.com/" rel="noopener noreferrer"&gt;Nanocell-CSV&lt;/a&gt;, a PWA designed to handle CSV files with remarkable precision and ease.&lt;/p&gt;

&lt;h2&gt;
  
  
  What Are Progressive Web Apps?
&lt;/h2&gt;

&lt;p&gt;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.&lt;/p&gt;

&lt;h2&gt;
  
  
  What’s in It for Users?
&lt;/h2&gt;

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

&lt;p&gt;&lt;strong&gt;Offline Access&lt;/strong&gt; - 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.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;No Downloads Needed&lt;/strong&gt; - Forget app store clutter. PWAs are lightweight and can be installed directly from the browser, saving storage space and time.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Cross-Platform Compatibility&lt;/strong&gt; - Whether you’re on Android, iOS, Mac, Linux or Windows, PWAs adapt seamlessly, offering a consistent experience across devices.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Automatic Updates&lt;/strong&gt; - Say goodbye to those constant “update now” notifications. PWAs update in the background, ensuring users always have the latest version.&lt;/p&gt;

&lt;h2&gt;
  
  
  Why Should Businesses Care?
&lt;/h2&gt;

&lt;p&gt;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.&lt;/p&gt;

&lt;h2&gt;
  
  
  The Ultimate Goal: Democratizing the Web
&lt;/h2&gt;

&lt;p&gt;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.&lt;/p&gt;

&lt;p&gt;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 &lt;a href="https://www.nanocell-csv.com/" rel="noopener noreferrer"&gt;Nanocell-CSV&lt;/a&gt;, a spreadsheet editor PWA!&lt;/p&gt;

&lt;blockquote&gt;
&lt;p&gt;Let's discuss in the comments:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Are you using this tech, and what for? &lt;/li&gt;
&lt;li&gt;Do you think PWAs have a promising future ? &lt;/li&gt;
&lt;/ul&gt;
&lt;/blockquote&gt;

</description>
      <category>pwa</category>
      <category>webdev</category>
      <category>webperf</category>
      <category>nextgen</category>
    </item>
  </channel>
</rss>
