[kwlug-disc] Merging data into Spreadsheet?

[Chris Frey]

On Sun, Apr 05, 2026 at 03:18:07PM -0400, William Park via kwlug-disc wrote:
> So, each person pulls his/her own data from CRM subsystem, and adds to this
> spreadsheet.

In my opinion, this is where the problem should be tackled.
Ideally by automating pulling data from the CRM subsystem.
Then automate creating the spreadsheet from those source documents.

If you can't automate the pulling of data, then at least
have the user dump daily fresh data into a blank template and
save it new into their own target directory, named by date.

Then automate by reading the new spreadsheets into whatever system
or file format you need.

Python code to read/write spreadsheets is pretty straightforward.

- Chris