Rishvi
Schedule MacroRIS-SM-2007 – Excel to CSV Convert

Excel to CSV Convert

Automatically convert files between Excel and CSV formats with FTP-based file transfer and management.

Overview

The RIS-SM-2007 – Excel to CSV Convertmacro automates file conversion between Excel and CSV formats while managing file transfers via an FTP server.

It downloads files, processes conversions, organizes outputs, and uploads results back to designated FTP folders.

Ensure FTP folders (raw, processed, failed) are properly configured before running this macro.

Purpose

This macro:

  • Downloads files from FTP

  • Converts Excel ↔ CSV formats

  • Uploads processed files back to FTP

👉 In short:
Automate file conversion and FTP file handling.

When It Runs

Used for file processing & system integration

Typically runs:

  • Scheduled execution (automated processing)

  • Manually for batch conversions

Parameters

No input parameters required.
The macro processes files based on predefined FTP directory configuration.

How It Works

Connect to FTP

Access FTP server and retrieve files from source folder (e.g., raw-files).

Download Files

Download files locally and remove them from FTP source location.

Prepare Directories

Create folders for raw, processed, and failed files.

Convert Files

Convert based on file type:

  • CSV → Excel (.xlsx)

  • Excel → CSV (.csv)

Handle Errors

Move failed conversions to designated local folder.

Upload Processed Files

Upload successful files to processed-files folder on FTP.

Upload Failed Files

Upload failed files to failed-files folder for review.

Cleanup

Remove temporary local files and directories.

Final Result

  • Files converted automatically between Excel and CSV

  • Processed files uploaded to FTP

  • Failed files separated for review

Usefulness

This macro is highly beneficial for:

  • Automating file format conversion

  • Eliminating manual file handling

  • Maintaining structured FTP workflows

  • Supporting external integrations

  • Reducing operational errors

Important Notes

  • Processes only files in configured FTP source folder

  • Files are removed from FTP after download

  • Supports both CSV → Excel and Excel → CSV

  • Failed files are stored separately

  • Requires proper FTP configuration

Example Scenario

Key Insight

Automating file conversion and FTP handling ensures reliable data exchange, reduces manual work, and improves integration efficiency across systems.

Was this page helpful?

Last updated today

Built with Documentation.AI