Fixed width

Fixed-width formatting is often used for data files and databases where maintaining consistent column widths is essential for data processing and readability, especially when importing data into systems that require specific data positions or for legacy data storage systems.

Example: A company possesses historical employee data archived in fixed-width files. To enhance accessibility for querying and reporting purposes, the company aims to transition this data into a contemporary relational database. The fixed-width file adheres to the specified format below:

Sample Fixed-Width File (employees.txt):

To use a fixed width, follow the below instructions:

Step 1:

You can upload files in several ways:

• Drag & drop from your computer
• Browse files manually
• Use cloud storage like Google Drive, OneDrive, Dropbox, SharePoint, etc.
• Import from Server (button below)

For the demonstration, we are uploading a file using the “Browse File” option.

Select a file from the user’s local storage and click “Open.” Once the upload is successful, proceed by clicking on “Add Range.”

Step 2: When the “Is header row present” toggle is on, it indicates that the first row in your data file contains column headers.

Step 3: Now, click on “+Add Range.”

Preview

Step 4: Add more ranges to include additional entries.