Welcome to DU! The truly grassroots left-of-center political community where regular people, not algorithms, drive the discussions and set the standards. Join the community: Create a free account Support DU (and get rid of ads!): Become a Star Member Latest Breaking News Editorials & Other Articles General Discussion The DU Lounge All Forums Issue Forums Culture Forums Alliance Forums Region Forums Support Forums Help & Search

Computer Help and Support

usonian

(23,153 posts)

1. Unix junkie here.

Reply to Ptah (Original post)

Tue Dec 9, 2025, 02:38 PM

Dec 9

I'd export each one as CSV (I use CSV for all my bank statements, from their sites)

Then I'd grep on TEP and merge the files, and then do whatever. (open in Calc. It's an excel clone)

grep TEP * >> TEP.csv

Use the parent directory in case TSV.csv decides to grow endlessly.

Simple enough for grep and cat.

=============
If not, perl will do lots and lots.

Luv my command line.

I used to use a relational database known as /rdb, written entirely in perl that used flat data files.

https://github.com/ironsmith58/RDB

Edit history

Please sign in to view edit histories.

Recommendations

0 members have recommended this reply (displayed in chronological order):

10 replies

= new reply since forum marked as read

Highlight:

I have a spreadsheet question. [View all] Ptah Dec 9 OP

Unix junkie here. usonian Dec 9 #1

Export each monthly sheet as a CSV? Ptah Dec 9 #2

"Separate Sheet for each month" usonian Dec 9 #4

You can create a Lookup Table JoseBalow Dec 9 #3

Thanks, JoseBalow. Ptah Dec 9 #5

excel uses macros in visual basic rampartd Dec 9 #6

I don't want to purchase (rent) Excel. Ptah Dec 9 #7

understand fully rampartd Dec 9 #8

What macro would you use in excel to create a sheet or chart? Ptah Dec 9 #9

it wouldn't be much rampartd Dec 9 #10