Step-by-Step Guide: Extracting and Filtering Fortune 500 Data Using UiPath
Overview
This guide will walk you through the process of creating an RPA bot using UiPath Studio to:
1. Extract data from the Fortune 500 company list.
2. Filter the data to keep only Computer Software companies.
3. Save the filtered data into an Excel file.
Prerequisites
Install UiPath Studio (Community Edition available at [UiPath](https://www.uipath.com/start-trial)).
– Install Google Chrome or Microsoft Edge (for web automation).
– Access the Fortune 500 website: https://www.50pros.com/fortune500.
– Ensure you have Microsoft Excel installed to verify the output file.
Step 1: Create a New UiPath Project
1. Open UiPath Studio.
2. Click “Process” and name it: Fortune500_Filter.
3. Click Create.
Step 2: Open the Website
1. Drag the “Open Browser” activity onto the workflow.
2. Set the URL to: https://www.50pros.com/fortune500.
3. Select your preferred browser (Chrome or Edge).
Step 3: Extract the Data Table
1. Click “Data Scraping” in the UiPath “Design” tab.
2. Click on the Fortune 500 table on the website.
3. Extract the following columns:
– Rank
– Company Name
– Industry
– Revenue ($B)
4. Save the extracted data into a DataTable variable named companyData.
Step 4: Filter the Data
1. Drag the “Filter Data Table” activity into the workflow.
2. Set:
– Input DataTable → companyData
– Condition → “Industry” = “Computer Software”
– Output DataTable → filteredData
Step 5: Write Filtered Data to Excel
1. Drag “Excel Application Scope” activity into the workflow.
– Set File Path to: filtered_companies.xlsx (this will create the file if it doesn’t exist).
2. Inside “Excel Application Scope”, drag the “Write Range” activity.
– Input DataTable → filteredData
– Sheet Name → “Sheet1”
– Start Cell → “A1”
– Check “Add Headers”.
Final Steps: Run and Verify Output
1. Run the UiPath Workflow.
2. Open filtered_companies.xlsx and check:
– The file exists.
– It contains only Computer Software companies.
Submission Requirements
1. Submit the UiPath Workflow File (.xaml).
2. Submit the Excel Output File (filtered_companies.xlsx).
Additional Notes
– If the extracted table structure changes, you may need to adjust column selection.
– If errors occur, use Debug Mode in UiPath to identify and fix issues.
– If the website layout changes, re-run the Da