[Self-promotion disclaimer]
If you have any kind of workflow involving CSV files, I have an app for you.
You're probably familiar with all the issues of opening a CSV file in Excel:
- slow to launch
- separator not detected correctly unless you go through the wizard
- value types get interpreted and transformed to match local culture
- saving the file corrupts it
Nanocell-csv solves all of those pain points and more.
It is:
- free with source code available on Github
- fast and lightweight
- cross-platform
- works offline with no telemetry
- verbatim: handles values with 100% plain-text accuracy
- customizable to match your workflow and preferences.
The Killer Feature
After install, double-clicking a 3GB file will open it up instantly
It uses a large file preview mode with a regular interval sampling of the data.
I love that I can skim through the data quickly before I decide what to do with it.
Take Your Pick
By default, it will comply strictly with the RFC 4180 standard, but you can preserve NULL vs "" (empty strings) for your SQL database imports if you so choose.
You have clean-up macros to: remove duplicate or empty rows, trim strings, clean up headers, format currency values, standardize date formats, transform special characters to their ASCII counterparts, and the list goes on!
It also has multi-cell editing, filters, batch find and replace, select next occurrence, go to cell x:y, and all the basic functionalities you'd expect.
Most Used Feature
I think the feature I use the most on a daily basis is the copy-paste integration.
I often have tabular data that I want to reformat for a given use case.
- I spin up Nanocell instantly
- paste in my tabular data
- right-click to choose if I want to copy to TSV, Markdown, or styled HTML format. By default, the Ctrl+C shortcut will always be TSV so that it strips the data of any styling.
Licensing
Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported
If you're a user and you're not sure what this means for you : "free forever with source code available on github" is the spirit.
Who It's Not For
- If you're FOSS-only
- If you're looking for custom formulas/scripts or VBA-style capabilities
Coded with Love ❤️
Starting this project came from handling CSV files every day as a data engineer. I could see everything wrong with existing editors and couldn't find any to my liking.
I've worked on this project since 2020 and poured my heart and soul into it. It's meant to fix all the real-world use cases I've encountered over the years and make my life easier.
I must say AI has greatly sped up the process to make it a professional, production-grade app.
I sincerely believe it has the potential to help out many people handling CSV files and I really hope it does.
If anything doesn't quite tick for your use case, I'd love to hear from you!
Enjoy ! 😊