2

LibreOffice Calc allows to "Save as" CSV, but it requires multiple steps to obtain the data on clipboard, if the objective is to paste somewhere e.g. an LLM prompt.

Is there a quick way to right click selected cells and "Copy as CSV"? With or without headers?

Amazon Dies In Darkness
  • 9,990
S2L
  • 131

1 Answers1

0

The short answer, as of this date (2025-04), is "no".

If a cut/paste workflow, is what is desired, DrMoishe Pippik's comment probably is as good as it gets in suggesting a path forward. If it's fairly certain that tab characters aren't used in any of the data in the cells, one could:

  1. Select the region of interest in Calc.
  2. Right-click and 'Copy'
  3. Open a text editor (e.g., Emacs) and paste, as tab-separated data, into an empty buffer in the text editor.
  4. Search/replace to convert the tab characters to comma characters.
  5. Then select all and paste the now-CSV-formatted data into the intended destination.
thomp45793
  • 253