Connect SFTP to Pigment and import files securely
Load the CSV extracts your source systems already drop on an SFTP server into Pigment through a native connector. Built for IT teams who need control over access and encryption, and for FP&A teams who want current files without downloading and re-uploading them by hand.

SFTP
Load CSV files from your SFTP server into Pigment Blocks over an encrypted, key-based connection
Category
Integration method
Best for
Financial actuals · Workforce cost data · Legacy system exports
What can you do with SFTP and Pigment?
- Update the forecast with current actuals. An FP&A analyst loads the latest transactions CSV into a Transactions list, then reviews the forecast against it.
- Cost headcount from the latest payroll. Most recent file mode loads the newest dated salary extract, so headcount cost plans use current payroll.
- Load a one-off extract. Fixed file mode loads a single named CSV, such as folder1/folder2/file.csv, for ad hoc analysis.
- Give modelers data without server access. IT stores the SSH key in the connection, so model builders import from the server without their own SFTP credentials.
How the SFTP integration works
Setup starts on the server, where IT creates a dedicated account holding only the files Pigment should read and adds the public key from an SSH key pair. A Pigment Workspace Admin then adds the connection under Workspace Settings > Integrations with the host, port, user login, private key, and server fingerprint, and chooses which Applications can use it.
Inside an Application, users go to Import data > Integration, select the connection, and enter a file path. Pigment loads either one fixed file or the most recent file that matches a dated naming convention, and you can save the import to re-run or schedule it. Data only flows into Pigment.
Key capabilities
- Authenticate without a password. Pigment signs in with a dedicated SSH key pair, using RSA, DSA, ECDSA, or ED25519 keys, with the private key in Pigment and the public key on your server.
- Meet stricter encryption policies. Turn on optional PGP encryption, and Pigment generates a key your systems use to encrypt files before they reach the server.
- Allowlist Pigment’s IP addresses. Allow incoming SFTP traffic only from Pigment’s published IP addresses, so the server accepts connections from Pigment and nowhere else.
- Decide which Applications use each location. Each connection covers one SFTP location, and its Application access setting controls which Pigment Applications can import from it.
- Keep your pipeline’s file names. Pigment reads ISO-8601 dates in file or folder names, so source systems don’t rename exports for planning.
Frequently Asked Questions
Which file formats and import modes does the SFTP integration support?
The integration loads CSV files in two modes. Fixed file mode loads one exact path, such as folder1/folder2/file.csv. Most recent file mode uses a date placeholder in the file or folder name and loads the newest matching file.
Can SFTP imports run on a schedule?
Yes. You can schedule an SFTP import configuration to run automatically, with up to four schedules per configuration and notifications if an import fails. With most recent file mode, each scheduled run picks up the newest dated file in the folder.
Does Pigment change any files on the server?
No. Pigment only needs read access to the server, and it imports files into Pigment without changing them.
Related integrations
See Pigment in action
The fastest way to understand Pigment is to see it in action. Sign up today and explore how agentic AI can transform the way you plan.

From 8 days to 4 min
Update P&L actuals & financial forecasting
80%
Time cut on data aggregation
12 hours
Saved per month on executive reporting
6 days faster
For scenarios creation and analysis