Not so new anymore. But take care. Your imports of CSV will get more expensive. Use JSON, XML or YML instead.

> tariffsOnYourSpreadsheets : r/ProgrammerHumor
https://www.reddit.com/r/ProgrammerHumor/comments/1jszlsx/tariffsonyourspreadsheets/?rdt=42092

Show HN: A modern spreadsheet with Python integration
https://citadel5.com/gs-calc.htm
#ycombinator #gs_calc #spreadsheet #portable #download #pivot_tables #linear_programming #quadratic_programming #dbf #clipper #foxpro #text #csv

#TIL about #xan a cool #rustlang #cli tool to deal with #CSV #data: https://github.com/medialab/xan

A tariff on all CSV imports would bankrupt the world.

"Excel hates CSV - It clearly means CSV must be doing something right"
-- xan, the #CSV magician
https://github.com/medialab/xan/blob/master/docs/LOVE_LETTER.md

Parsing CSV with units in the header · Issue #166 · hgrecco/pint-pandas

https://github.com/hgrecco/pint-pandas/issues/166

Now we can read a #csv file with a header like `time / s,mass / g` into #pandas and call `.pint.quantify()` to get a #dataframe in which the columns have #units as in #Pints !

Handy for CSV restricted to single-row headers, as in Confluence Databases and Microsoft Lists.

#TIL about #Visidata: https://jsvine.github.io/intro-to-visidata/

If you ever need to wrangle, filter, sort, edit, navigate, subset or get basic statistics out of #data in #CSV format (comma-separated values), this is a super useful piece of software. It takes raw data and implements a very handy subset of functionality from spreadsheets directly on top, with both a keyboard (modal Vi-style operation) and menu/mouse driven operation.

Nice one to have in the toolchest.

Wochenrückblick, Ausgabe 85 (2025-13)

Themen:

Neues Feature für bikerouter.de: Kurzlinks und verbesserte QR Codes

Automatisch bei Blog-Updates den Uberblogr-Webring pingen

Neuer Schlauch für die Absaugung in der Werkstatt

Unbekannte Holzart entdeckt

snips.sh: SSH-basiertes Pastebin, Opengist als weitere Alternative für GitHub Gists

CLI-Tool der Woche: xsv

In dieser Woche gehört: SOS U-Ground B2B Tobias Sommer, Taberia

#Wochenrückblick #Bikerouter #QRCode #UberBlogr #Webring #Absaugschlauch #Werkstatt #Woodworking #Holz #Drechseln #snips.sh #Gist #Gitea #GitHub #Opengist #CLI #Shell #xsv #CSV #TSV #Techno

https://www.marcusjaschen.de/blog/2025/2025-13/

Unreal Engine and Version Control https://frederickkdp.github.io/game_dev/ue_journal/2025/03/28/ue-vc.html #UnrealEngine5 #version_control #csv

wow this `xan` that showed up in #macOS #homebrew today is pretty sweet. it's written in #rust and is a #csv slice-and-dice tool.

https://github.com/medialab/xan

Not sure who needs this (apart from me, of course), but just pushed my rof2csv tool:
https://github.com/branch-predictor/rof2csv
Use it to convert Rigol's ROF files (produced by Rigol DP800 series programmable power supplies) into CSV files that can be fed into Excel or LibreOffice Calc.
#programming #SoftwareDevelopment #rigol #rof #csv

Looking forward to #DFD2025. What #FLOSS tools do you use to read #CSV files? Any FOSS #ETL tools to copy CSVs to/from databases? Is there a #Free, #OpenSource ODBC driver for connecting to CSV files?
#AskFedi #AskFediverse #DFF

10 Efficient Ways to Seed Your #Database with #Laravel

• Use static hard-coded arrays or #JSON files for predefined data sets
• Generate seeders from existing table data with orangehill/iseed
• Import large #CSV files directly using database engine

#laravel

[Utiliser des données en #opendata n°6] Vous avez téléchargé des données et souhaitez ouvrir le fichier.

L'équipe de data.gouv.fr propose un rappel de quelques options possibles pour les formats #CSV, #JSON, #XML, #GeoJSON, #shapefile et #KML dans son guide : https://guides.data.gouv.fr/reutiliser-des-donnees/guide-traitement-et-analyse-de-donnees/manipuler-des-donnees/ouvrir-des-donnees

The oldschool web/tech side of me is smiling.

"A love letter to the #CSV format"

https://github.com/medialab/xan/blob/master/docs/LOVE_LETTER.md

"Or why people pretending CSV is dead are wrong... #Excel hates CSV which clearly means CSV must be doing something right."

League/csv 9.22.0 is out with a brand new class that seats between the Reader and the Writer called the Buffer. It allows buffering you CSV document and performing some CRUD operation on the data before storing it. You can do a lot more with it check the documentation https://csv.thephpleague.com/9.0/writer/buffer/

Helped my wife to simplify her work life a bit. She was frustrated with how many clicks it took her to log her work hours in #bamboohr. With the help of some coding AI she now extracts tagged events from her Google calendar into a #csv. Then she uses a little #python script to talk to the Bamboo API to add the hours. The AI generated code needed a bit of tweaking but she was amazed how easy you can get a working prototype.
Now it saves her a lot of time manually logging her hours.