Excel to PostgreSQL Converter
Excel to PostgreSQL Converter is a tool to Convert, Migrate data from Excel to PostgreSQL Database. You can convert multiple Excel sheets in one go to PostgreSQL. While converting you can map Excel columns to matching PostgreSQL table columns, You can also filter rows by specifying WHERE conditions.
Excel to PostgreSQL Converter comes with a built in scheduler so that you can run transfer jobs automatically at specified intervals. No need to run jobs repeatedly, just create a session define the schedule interval date and time and Excel to PostgreSQL Converter will automatically executes your session in the background and records the actions in a specified log file.
Excel to PostgreSQL Converter also lets you run migration jobs from Windows command line. It comes with separate Runtime Executable file which can be called from command line or from any other application. Thus providing easy integration with your own application
Supports all versions of PostgreSQL.
Using Excel to PostgreSQL Converter you can perform the following conversion
- Excel XLX / XLSX, CSV or Delimited Text files to PostgreSQL Database
- PostgreSQL to CSV or Delimited Text files or Fixed Width files
- PostgreSQL to PostgreSQL Database
Supported Databases
- MySQL
- MySQL Dump
- Oracle
- Oracle SQL Dump
- MS Access
- PostgreSQL
- Foxpro/DBF Files
- CSV/Text or Fixed width
- MS SQL Server
- MS SQL Server Dump
- Maria DB
- Amazon RDS
- Amazon Aurora
- Google Cloud
- Azure Database for MySQL
Top Features
Constraints and Indexes
Imports all Constraints and Indexes and Auto Increment attributes.
In Built Scheduler
Automatically transfer data without any interaction.
Bulk Loading
Bulk Loading feature for Oracle, MySQL and MS SQL Server databases to load millions of rows at blazing speed.
Column Mapping
Load into new or existing tables with full Column Mapping.
SQL DUMP FILES
Generate SQL dump files from any database source.
Synchronize
UPSERT and INSERT loading options to Synchronize Source and Target databases.
Select the Folder containing Excel Choose Target PostgreSQL database and click Start