[calc] How to import CSV (text) table and automatically create pivot table (like legacy Import from Text in Excel)?

[wqcr]

Is there a plugin/macro that would turn imported CSV into color coded rows with pre-made pivots for each column?
Just like a legacy plugin for excel here:
example

Thanks,

[keme]

Not exactly as requested, but a couple of workarounds to get the job done, perhaps…

• In LibreOffice Base you can create a database from a folder containing csv files, and register it as a LibreOffice data source. New csv files copied into the folder will appear as new tables in your database.
• In Calc you can create pivot tables from registered data sources.
• Calc menu item View - data sources toggles the display of registered data sources.
• You can drag table data from the sources pane into a sheet
• You can easily format rows on a large area in the cell grid with alternating background:
• Format the first two rows for alternating background,
• Select both rows
• use clone format (paintbrush tool) or copy the selected two-row range, then select entire table and Edit - Paste special with only Formats ticked to fill that pattern into the spreadsheet grid.