Convert Excel to CSV using REST API in Python.

Convert-Excel-to-CSV-Python-.md

Learn how to convert Excel files to CSV using a REST API in Python: https://blog.groupdocs.cloud/2022/01/12/convert-excel-to-csv-using-rest-api-in-python/

The following topics shall be covered in this article:

1. Excel to CSV Conversion REST API and Python SDK
2. Convert Excel to CSV using a REST API in Python
3. Convert Excel to CSV and Download File Directly
4. Excel to CSV Conversion without using Cloud Storage
5. Convert CSV to Excel using a REST API in Python

Convert-Excel-to-CSV-Python-Configurations.py

# The following code example demonstrates how to add Client id and secret in the code.
client_id = "659fe7da-715b-4744-a0f7-cf469a392b73"
client_secret = "b377c36cfa28fa69960ebac6b6e36421"

configuration = groupdocs_conversion_cloud.Configuration(client_id, client_secret)
configuration.api_base_url = "https://api.groupdocs.cloud"
my_storage = ""

Convert-Excel-to-CSV-Python-Convert.py

# This code example demonstrates how to convert Excel to CSV.
# Create necessary API instance
convert_api = groupdocs_conversion_cloud.ConvertApi.from_keys(client_id, client_secret)

# Prepare convert settings
settings = groupdocs_conversion_cloud.ConvertSettings()
settings.file_path = "Sample.xlsx"  # Input file
settings.format = "csv"             # Output format
settings.output_path = "output"     # Folder path to save converted file

# Convert document request
request = groupdocs_conversion_cloud.ConvertDocumentRequest(settings)

# Convert document
result = convert_api.convert_document(request)

# Done
print("Document converted: " + result[0].path)

Convert-Excel-to-CSV-Python-ConvertAndDownload.py

# This code example demonstrates how to convert Excel to CSV and download converted file directly.
# Create necessary API instances
convert_api = groupdocs_conversion_cloud.ConvertApi.from_keys(client_id, client_secret)

# Prepare convert settings
settings = groupdocs_conversion_cloud.ConvertSettings()
settings.file_path = "sample.xlsx"
settings.format = "csv"
settings.output_path = None    # leave OutputPath will result the output as document IOStream

# Prepare request
request = groupdocs_conversion_cloud.ConvertDocumentRequest(settings)

# Convert and download
response = convert_api.convert_document_download(request)

# Move downloaded file to your working directory
shutil.move(response, "C:\\Files\\Conversion\\")

Convert-Excel-to-CSV-Python-ConvertCSVtoXLSX.py

# This code example demonstrates how to convert CSV to Excel.
# Create necessary API instances
convert_api = groupdocs_conversion_cloud.ConvertApi.from_keys(client_id, client_secret)

# Prepare request
request = groupdocs_conversion_cloud.ConvertDocumentDirectRequest("xlsx", "C:\\Files\\Conversion\\sample.csv")

# Convert
result = convert_api.convert_document_direct(request)

# Move downloaded file to your working directory
shutil.move(result, "C:\\Files\\Conversion\\")

Convert-Excel-to-CSV-Python-ConvertWithoutCloudStorage.py

# This code example demonstrates how to convert Excel to CSV and without using cloud storage.
# Create necessary API instances
convert_api = groupdocs_conversion_cloud.ConvertApi.from_keys(client_id, client_secret)

# Prepare request
request = groupdocs_conversion_cloud.ConvertDocumentDirectRequest("csv", "C:\\Files\\Conversion\\sample.xlsx")

# Convert
result = convert_api.convert_document_direct(request)

# Move downloaded file to your working directory
shutil.move(result, "C:\\Files\\Conversion\\")

Convert-Excel-to-CSV-Python-Download.py

# This code example demonstartes how to download CSV from the cloud.
# API initialization
file_api = groupdocs_conversion_cloud.FileApi.from_config(configuration)

# Downlaod file request
request = groupdocs_conversion_cloud.DownloadFileRequest("output/Sample.csv", my_storage)

# download file
response = file_api.download_file(request)

# Move downloaded file to your working directory
shutil.move(response, "C:\\Files\\Conversion\\")

Convert-Excel-to-CSV-Python-Upload.py

# This code example demonstrates how to upload an XLSX file to the cloud.
# Create an instance of the API
file_api = groupdocs_conversion_cloud.FileApi.from_config(configuration)

# Upload file request
request = groupdocs_conversion_cloud.UploadFileRequest("Sample.xlsx", "C:\\Files\\Conversion\\Sample.xlsx", my_storage)

# Upload sample file
response = file_api.upload_file(request)