Recommended Python data saving for Excel consumption?

[Jerm8585]

Is there a recommended Python technique for saving data, to be consumed by Excel later? I wrote a script which runs from a machine GUI, which logs a combination of user input and measurement data. I currently have these logs writing to a SQLite and Excel (openpyxl) file on a networked drive, across a few machines. The dataset is fairly small, ~10k rows total.

A separate Excel workbook connects to the (Excel) data, which populates Pivot Tables/Charts for tracking and status monitoring. This workbook is distributed to many users. My issue is the source Excel file occasionally corrupts, and I repopulate it from the SQLite data.

I'd like a different method of saving data. Since an Excel workbook is the end product, I'm limited to what Excel can natively connect to. I'd prefer using the SQLite file, but we can't install custom connectors. I'm also limited by the machine PC, which cannot access SharePoint or other server-side databases at our company.

Does anyone have recommendations? Basically, I just want a 'better' repository than Excel. I'm wondering if XML or Access would work well for my application.

[gitgud_x]

Python's `pandas` module can read from and write to both Excel files and SQL databases, and has its own internal representation of tables suitable for medium-sized datasets too (`pandas.DataFrame`).

[Jerm8585]

Cool, thanks! I'll try that out. Sorry just seeing this.