Skip to main content

excel

The excel command converts CSV files to Excel format.

Syntax​

qsv excel [options] <input_file> [<output_file>]

Description​

The excel command is used to convert CSV files to Excel format. This is useful for sharing data with users who prefer Excel.

Options​

  • --sheet <name>: Specify the name of the Excel sheet (default: Sheet1)
  • --no-headers: When set, the first row will not be interpreted as headers

Examples​

Convert to Excel​

Convert a CSV file to Excel format:

qsv excel DLD_Transactions_English_500.csv output.xlsx

Common Use Cases​

  • Sharing data with users who prefer Excel
  • Converting data for compatibility with Excel-based tools

Tips​

  • Verify the output file format is correct
  • Use in combination with other commands for complex data processing

See Also​

  • select - for selecting specific columns
  • apply - for data transformations