DEV Community

Cover image for Why Does Editing CSV Files Always Feel So Difficult?

Why Does Editing CSV Files Always Feel So Difficult?

Cedric Bonjour on January 20, 2025

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 everywh...
Collapse
 
xwero profile image
david duymelinck

The only CSV files I encounter are the ones that are generated by some software solution. I never received a CSV file from someone who wrote it manually.

While I don't see the benefit for myself, I think there will be people who can use this.
Keep up the good work!

Collapse
 
cedric_bonjour profile image
Cedric Bonjour

Hi, thanks for the support 😊

Always curious to know :
What do you use those CSV files for ?

Collapse
 
xwero profile image
david duymelinck

Most of the time first imports.

Thread Thread
 
cedric_bonjour profile image
Cedric Bonjour

currently working on tools to help you cleanup the file for import. Things like getting the headers to snake case, detecting duplicat headers, parsing the data for any deviation from the standards, checking date formats, etc...

Happy to take any special requests ;)

Thread Thread
 
xwero profile image
david duymelinck

The schema and input types are known before starting to code. So cleanup is not needed.
If there are abnormalities in the schema or input types. It is up to the data provider to follow the schema and input types, or request a change.

I understand your eagerness to solve problems, but the best thing is to have a lack of problems. And that is why communication is important.

Collapse
 
agunechemba profile image
Agunechemba Ekene

Backed up my google contacts using csv format... I almost lost it all...

Collapse
 
cedric_bonjour profile image
Cedric Bonjour

What went wrong ?

Collapse
 
agunechemba profile image
Agunechemba Ekene

trying to import back to my device, and I noticed that the data got messed up.

  • Some contact names were stored with commas

  • some fields like emails, websites, contact groups..... got really messed up too

Collapse
 
kehoecj profile image
Clayton Kehoe

Nice project

Collapse
 
cedric_bonjour profile image
Cedric Bonjour

Thanks for your support on GitHub too 😉

Collapse
 
cedric_bonjour profile image
Cedric Bonjour

Thanks 🙏 glad you like it 😊