Excel automation pipeline

Search more jobs
Our company deals with excel files (~40-45 different formats) - we extract necessary data points, convert them into our structure, and do some logical data transformation.

We would like to automate this process using some existing 3rd party tools.

Previously we tried using an existing ETL tool, and we had a team of ETL developers, who supported these scripts.
But we faced a problem, that the data format occasionally changes (~30-50% of all cases) – column names, exact locations, new or deleted data, etc

We want to automate our data processing workflow.
In general:
1.  It should be a tool with a solid intellectual part, (e.g. mix of algorithms and ML models) So, it would be able to locate the missing data in case of minor changes.
2. Also, it should be a very zero-code solution, as we want to ask users to support scripts (in case of minor data format changes).

We want to have an expert opinion on:

1. Are there any existing 3rd party tools on the market that might suit us?
2. Feedback on the criteria list – do we miss any critical items? Or do we include unnecessary?
3. Feedback on our process flow – is it possible to achieve?

  • Less than 30 hrs/week
  • < 1 month
  • Expert
    Experience Level
  • $100.00-$200.00
  • Remote Job
  • One-time project
    Project Type

Skills and Expertise

Automation ETL zero-code

Activity on this job

  • 20 to 50
    20 to 50
  • 8 days ago
    Last viewed by client
    8 days ago
  • 1
  • 0
  • 2
    Invites sent
  • 0
    Unanswered invites

About the client

Member since Jan 24, 2022
  • Germany
    Munich 10:29 pm
  • 11 jobs posted
    100% hire rate, 1 open job
  • $41,976 total spent
    13 hires, 4 active
  • $35.79 /hr avg hourly rate paid
    691 hours
  • Member since Jan 24, 2022

Explore similar jobs on Upwork

Data validation using excel, Toad and SQL command
Hourly ‐ Posted 54 minutes ago
Microsoft Excel SQL
Data Labeling Microsoft Excel Microsoft Outlook Microsoft OneNote

How it works

Post a job icon
Create your free profile

Highlight your skills and experience, show your portfolio, and set your ideal pay rate.

Talent comes to you icon
Work the way you want

Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.

Payment simplified icon
Get paid securely

From contract to payment, we help you work safely and get paid securely.

Want to get started?

About Upwork

Stars rating
(Average rating of clients by professionals)
G2 2021
#1 freelance platform
Signed contract every week
Freelancers earned on Upwork in 2020

Find the best freelance jobs

Growing your career is as easy as creating a free profile and finding work like this that fits your skills.

Trusted by
Microsoft Logo Airbnb Logo Bissell Logo GoDaddy Logo