Try our High Performance Text File Batch Processing Tool (No Coding Required): Match, Standardize, Verify, and Enrich Data within CSV/TSV Files in Seconds: Start Now!

Getting Started with the Interzoid Text File Batch Tool

Unlock the full potential of your data assets with Interzoid's Text File Batch Tool. This powerful utility allows you to quickly and easily improve the quality, accuracy, usability, and value of your important data. In this step-by-step guide, we'll walk you through the process of setting up and using this versatile tool.
1 Obtain an API Key

Before you begin, you'll need to authenticate your access with an Interzoid API key. Simply log in to your existing account or register for a new one at www.interzoid.com. Your API key serves two important purposes:

  • Authenticates each API call you make
  • Tracks your usage of the service

Process datasets via APIs in no-code batch mode

2 Select the API to Use

Browse the left-hand column to choose the specific API that best suits your data processing needs. The selected API will be called for each record or line in your text file, and its output will be incorporated into your results.

For maximum efficiency, all processing occurs on Interzoid's parallel-processing batch platform, ensuring optimal performance even with large datasets.

3 Configure Settings for Your Job

The tool offers flexibility through several configuration options:

File Source Input Modes:

  • Local File (default): Upload a file directly from your computer
  • Web URL: Enter a direct URL to your raw text file (ensure it contains no embedded HTML)

Input File Format:

  • CSV (comma-delimited)
  • TSV (tab-delimited) - Recommended to avoid comma-related issues

Column Number Specification:

Indicate which column in your text file (counting from the left, starting with #1) will be processed by the API. For example:

  • For organization similarity keys: the column containing organization names
  • For Global Weather API: the column containing location data
  • For Email Information API: the column containing email addresses

Some APIs may require additional fields, for which default values are typically provided.

Show All Option:

When checked, all fields from the input file will appear in the output file alongside the API call results. If unchecked, only the data from the selected column will be included with the output data.

4 Run the Job

After entering your API key and configuring all settings, click the Run button (with its action icon) to begin processing. The system will execute API calls for each line in your input file.

During processing, a spinner will indicate that the job is active. As results become available, the API responses for each line will populate the results window.

5 Review and Download Results

Once processing is complete, you can:

  • Review your results in the dedicated results window (supports horizontal scrolling for long output)
  • Click the Download button to save the output file for further use in your workflows

Important Note on File Formatting:

Ensure your files follow the proper standard format required for CSV and TSV files:

CSV Text Qualifiers: If any data field values contain the delimiter character (comma), enclose that particular field in double quotes (e.g., "John, Doe, Inc.") per industry standards. This ensures that the delimiter inside the quotes is treated as part of the data rather than a separator.

Most export functions in applications will automatically enforce this format. For files with only a single column of input data, the TSV format is recommended since the entire line will be read as a column, avoiding issues with unquoted data containing commas.

Ready to Transform Your Data?

Congratulations! You are now equipped to use the Interzoid Text File Batch Tool to improve the quality, consistency, usability, and value of your important data assets.

Need assistance? Contact support@interzoid.com for help. You can also try the APIs interactively at this link.

High-Performance Batch Processing: Call our APIs with Text Files as Input.
Perform bulk data enrichment using CSV or TSV files.
More...
Available in the AWS Marketplace.
Optionally add usage billing to your AWS account.
More...
See our Snowflake Native Application. Achieve Data Quality built-in to SQL statements.
Identify inconsistent and duplicate data quickly and easily in data tables and files.
More...
Connect Directly to Cloud SQL Databases and Perform Data Quality Analysis
Achieve better, more consistent, more usable data.
More...
Try our Pay-as-you-Go Option
Start increasing the usability and value of your data - start small and grow with success.
More...
Free Trial Usage Credits
Register for an Interzoid API account and receive free usage credits. Improve the value and usability of your strategic data assets now.
Automate API Integration into Cloud Databases
Run live data quality exception and enhancement reports on major Cloud Data Platforms direct from your browser.
More...
Check out our full list of AI-powered APIs
Easily integrate better data everywhere.
More...
Business Case: Cloud APIs and Cloud Databases
See the business case for API-driven data enhancement - directly within your important datasets
More...
Documentation and Overview
See our documentation site.
More...
Product Newsletter
Receive Interzoid product and technology updates.
More...