Help Center / Integrations

Export a OpenOffice Calc document as CSV file

This tutorial will guide you through the process of converting a single sheet from an OpenOffice Calc document into a CSV file.

Step 1: Open the Calc Document

  1. Launch OpenOffice Calc on your computer.
  2. Open the Calc document containing the sheet you want to convert to CSV.

Step 2: Select the Sheet

  1. At the bottom of the Calc document, you will see tabs representing each sheet within the document.
  2. Click on the tab of the sheet you want to convert to CSV. This will make it the active sheet.

Step 3: Save the Sheet as a CSV File

  1. Click on File in the top-left corner of the Calc interface.
  2. Click on Save As in the dropdown menu.
  3. Choose the location where you want to save the CSV file on your computer.
  4. In the File type dropdown menu, select Text CSV (.csv).
  5. Click Save to save the active sheet as a CSV file.

Step 4: Confirm CSV Export Settings

  1. A dialog box titled Export Text File will appear.
  2. Make sure the Character set is set to Unicode (UTF-8).
  3. Choose the desired field delimiter (usually a comma) in the Field delimiter dropdown menu.
  4. Choose the desired text delimiter (usually double quotes) in the Text delimiter dropdown menu.
  5. Click OK to confirm the settings and export the CSV file.

Note: This will only save the active sheet as a CSV file. Other sheets in the document will not be included in the CSV file.

Now you have successfully converted a single sheet from an OpenOffice Calc document into a CSV file.



Was this article helpful?

Thank you for your feedback!

Related articles


Categories

FAQ