[kwlug-disc] Merging data into Spreadsheet?

[William Park]

(1) I'll pass along, "Excel Online".

(2) Forgot to mention... the end point has to be Excel.  Telling them to 
use something else is non-starter. :-)

(3) Yes, data extraction/loading (ETL) should be automated.  But, there 
is good reason.  You're dealing with "sales guys".  You can set company 
policy, threaten them, fire them.  They enter something into company 
CRM, but always keep something to themselves.


On 2026-04-05 19:35, CrankyOldBugger wrote:
> As much as I hate to recommend this to you, as I hate it with a passion 
> myself, but Excel Online would allow multiple concurrent edits.
> 
> Sorry, I don't know of a FOSS equivalent to this.
> 
> 
> On Sun, 5 Apr 2026 at 21:50, Chris Frey <cdfrey at foursquare.net 
> <mailto:cdfrey at foursquare.net>> wrote:
> 
>     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
> 
> 
>     _______________________________________________
>     kwlug-disc mailing list
>     To unsubscribe, send an email to kwlug-disc-leave at kwlug.org
>     <mailto:kwlug-disc-leave at kwlug.org>
>     with the subject "unsubscribe", or email
>     kwlug-disc-owner at kwlug.org <mailto:kwlug-disc-owner at kwlug.org> to
>     contact a human being.
> 
> 
> _______________________________________________
> kwlug-disc mailing list
> To unsubscribe, send an email to kwlug-disc-leave at kwlug.org
> with the subject "unsubscribe", or email
> kwlug-disc-owner at kwlug.org to contact a human being.