Sql import excel jobs
I have an existing Microsoft SQL Server database that I'm looking to migrate to a NoSQL database system. Ideal skills and experience: - Strong experience with database programming - Previous database migration experience - Proficient in both Microsoft SQL Server and NoSQL databases Please let me know your experience in such projects and the approach you would take to ensure a smooth and successful migration.
I'm looking for a professional with advanced skills in data mining and excel to extract specific text information from a website into an excel spreadsheet. This job requires an understanding of website data scraping. The successful candidate should have: - Proven experience with Web Scraping. - Expert knowledge in Data mining and Excel. - The ability to handle large sets of information efficiently and effectively. - Accuracy and attention to detail. - Knowledge of and web scraping ethics. The task primarily involves text data mining, here are the specifics: - Extract exact information from a website. - The exact text data to be mined will be communicated to the successful candidate. This opportunity is ideal for someone with a knack for managing large amounts...
I am seeking an experienced Excel expert to create a functional timeline sheet. As the project specifics were not indicated, the freelancer must be capable of handling a wide range of tasks including but not limited to designing tasks description, start and end dates, and task dependencies. The sheet needs to be well-organized, potentially categorized by project phases or team members, or put in chronological order. This can be further discussed as the project progresses. It's crucial that the timeline offers a clearly visible trajectory of tasks, milestones, or a high-level overview of the project timeline. It will be helpful if the freelancer possesses: - Expertise in Excel - Strong attention to detail - Understanding of project management processes - Ability to wo...
I'm in need of a professional who can scrape specific data from a website onto an Excel spreadsheet. The requirement is to list information in a table format. Key Requirements: - Scraping of content descriptions from the website - Transferring the extracted data into an Excel database The data should be organized in a clear and structured manner, following the format I will provide.
I'm in need of an Excel sheet that is set up for data analysis purposes. Key Requirements: - Utilize Pivot Tables: The main goal of the sheet is to leverage Pivot Tables for efficient and effective data analysis. - One-time setup: This is a one-time project, so the sheet will be used for data analysis and won't require regular updates. Ideal Skills: - Proficient in Excel: An expert in Excel who is comfortable working with large data sets and has a deep understanding of Pivot Tables. - Data Analysis Experience: Previous experience with data analysis is a plus, especially with a focus on creating actionable insights. - Attention to Detail: The ability to accurately set up the Excel sheet to ensure data integrity and reliable analysis. I'm lookin...
...information, specifically email addresses and fax machine numbers, for doctor's offices in Hamilton, Ontario. The desired freelancer will have: - Proven experience in data scraping and data entry. - Ability to independently source from multiple platforms or websites. - Knowledge and capability to deliver the data in an Excel spreadsheet format. Primary Tasks: - Data scraping for email addresses and fax numbers across various sources. - Ensure accurate, complete data entry into the Excel spreadsheet. - Verification of compiled data to ensure its accuracy. This project is ideal for freelancers with a keen attention to detail and a dedication to data accuracy and integrity. If the quality of your submitted work is high then I would love to pay you to complete a s...
I'm looking for a skilled Excel and Adobe professional to automate a series of Excel forms that have varying formats and information, with the data from a single fillable heading. Below are some key details: - Excel Version: The forms are based on different versions of Excel, as I'm not sure which ones to be exact. A freelancer who is proficient in all versions will be ideal. - Application Requirements: Please include detailed project proposals in your application. Experience with similar projects will also be a plus. - Final Documents: I need the final documents in both XLSX and PDF formats. The main goal of this project is to create a fillable heading where client information can be input on one page and have it automatically populate to the other ...
I'm looking for a Microsoft Access professional to work on generating a report concerning my inventory data. Your key tasks will include: - Utilize existing inventory data to create a excel sheet that shows all data required in one place.
Job Title: Senior Full Stack .NET Developer Monday to Friday 2-3 hours/day IST Night (7am to 11am IST) Salary: 25,000 INR per month J...Salary: 25,000 INR per month Job Description: We are seeking a highly skilled and experienced Senior .NET Developer to join our team. The ideal candidate should have strong proficiency in C#, ASP.NET MVC, and the .NET Framework, along with expertise in various web-related technologies such as HTML, CSS3, JavaScript, and jQuery. Additionally, familiarity with database technologies including SQL Server and T-SQL is essential for this role. One needs to be available in the mentioned timings and willing to work by screen share and remote control via Zoom. Skills Required: C# ASP.NET MVC .NET Framework Entity Framework HTML CSS3 JavaScript T...
I have a daily dataset of the prices and funding fees of cryptocurrencies from Binance. I'm seeking an Excel expert to automate the task of calculating the price, funding fee, and percentage of each crypto every day at specific time. - The output should be in a table format for ease of understanding and comparison. Any tool or programming language that can efficiently and accurately perform this task is acceptable. The goal is to create a structured, automated process that can handle this daily task with precision. Ideal Skills and Experience: - Strong Excel skills, especially in formulas and functions. - Prior experience with automation in Excel, macros and VBA programming. - A good understanding of cryptocurrencies and their pricing. - Ability to deliver a ...
As a part of my marketing campaign, I'm seeking a professional who can meticulously gather the contact information of celebrants in the entire South UK. The final output should be in a convenient Excel spreadsheet format. Key Responsibilities: - Data Mining: Cover all regions in South UK to get a comprehensive list of celebrants. - Accuracy: The data should include celebrants' name, location, phone number, and email address. I want 500 celebrants listed. Please bid to complete this project. Do not message me to have a chat further or look to increase a price posted. This is unfair on the people following my instructions and bidding.
I'm seeking a VBA expert who can help me create a tool that will generate both PDF and Word documents from a specific column of an Excel file. The Word document should contain some static data derived from the column details. The primary requirements are as follows: - The tool should be able to generate both PDF and Word documents. - The Word document should include some fixed data from the Excel details. - An interactive graph should be included in the Word document, based on the data from the specific column.
...where hours submitted by employees must be approved by an administrator before being finalized. ## **Technical Specifications:** - **Frontend:** Responsive design using Bootstrap for the web dashboard and adaptive layouts for iOS and Android apps. - **Backend:** Python (with frameworks such as Flask or Django) to handle server-side logic, API endpoints, and database integration. - **Database:** SQL (e.g., PostgreSQL) for storing user data, time entries, projects, and tasks. - **Security:** Implementation of essential security measures including HTTPS, data encryption, and secure authentication processes. - **Mobile Development:** Native apps for both iOS and Android to ensure optimal performance and user experience. ## **Features:** ### General: - **Landing Page and Login:** ...
I need a freelancer with proficiency in data collection and Excel to handle a minor task for me. The project is straightforward, with only 28 rows of data that need to be collected. I'll need the following information included in each row: - 12 columns of data - Each row will contain Text, Dates, Phone numbers, Links, etc. - Other miscellaneous data related to my project requirements that need to be captured. The ideal candidate for this position is skilled in Excel, organized, and pays great attention to detail. Prior experience in data mining will be a huge plus.
I need a VBA script tailored to Excel that will assist in my data analysis projects. It should prompt me to enter a target amount, then let me select a range of cells that contain various amounts. The code should find a combination within the selected range that makes the sum equal to or closest to the target amount. It could be more than the target amount or less than the target amount but it should be closest. It should then highlight the cells that make the sum that is closest to target amount. It should also ensure that only visible rows are to be considered. Hidden rows are not to be considered. Key Requirements: - Prompt for target amount and range of cells - Find combination closest to target sum - Compatible with Excel 2016 and above Key Features: - Return the first...
Do you excel in Excel? Are you a pro at product cataloging and social media savvy? We're hiring an E-commerce Operations Specialist! Responsibilities: Data management wizardry in Excel Catalog listing perfection for top-notch quality Media editing mastery for captivating visuals Google sleuthing for competitive price analysis Shopify expertise and social media finesse Requirements: Excel expertise Catalog listing experience Media editing skills Google search proficiency Shopify knowledge Social media savvy Ready to level up your e-commerce career? Apply now!
I'm in need of a detail-oriented data entry operator to transfer data from my handwritten notes into a structured Excel spreadsheet. The critical aspect of the task involves entering data in a date-wise manner. Key Tasks: - Translate data from handwritten notes into digital form - Create a spreadsheet that categorizes data by date Ideal Skills: - Strong attention to detail - Prior experience with Excel data entry - Good understanding of date-based data organization - Ability to read and interpret handwritten notes Your experience with similar tasks will ensure speed and accuracy in this project. Preference will be given to those who can demonstrate previous success in such projects.
As a business with a medium-sized SQL database, my aim is to enhance data interpretation and decision making by utilizing Microsoft Power BI for data visualization, interactive dashboards, and comprehensive reporting. Key Requirements: - Expertise in Microsoft Power BI to analyze database. - Experience with SQL and understanding of data volume (1GB - 10GB). - Ability to visualize data through charts and graphs, create interactive dashboards, and generate comprehensive reports using Power BI. - Familiarity with implementing security measures, including data encryption, user authentication, and permission-based access control. Please bid if you have the ideal skills and proven experience. Your bid will be evaluated based on your expertise, client feedback, and cost-effective...
I'm in need of someone who can assist me in developing Excel formulas for financial equations, focusing specifically on profit and loss analysis. - You should be an expert in using Excel for financial analysis. - You will need to create tailored formulas to handle profit and loss calculations effectively. - Experience in business finance, particularly in profit and loss statement analysis, is greatly preferred.
I am looking for a reliable virtual assistant to help me with a variety of tasks ranging from email management, scheduling, data entry and documentation to managing Excel sheets and handling calls. Your communication skills are crucial and you should be comfortable with a variety of communication tools. Ideal skills and experience include: - Prior experience as a virtual assistant - Proficiency in time management and organizational skills - Strong communication skills - Familiarity with a variety of communication tools including email, instant messaging apps and Whatsapp calls I expect to communicate with my virtual assistant on once per day 1-2 hours a day basis. The right candidate would be someone who is proactive and can work independently to get the job done. Must be fluent...
...(tariff payment and number of contacts). You need to make sure that these fields are also displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. One file for all users (form will be provided). * Fix the code when sending an E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to the artist registration form, whe...
I'm looking for an Excel expert to create a robust template for tracking and analyzing student results data. This template will be used to perform in-depth statistical analysis. Key requirements: - Statistical Analysis: The main focus of this project is on statistical analysis of the student results data. Your experience with advanced Excel functions and statistical tools will be crucial for this. - Input Data: The data will be entered using forms within Excel. It's essential that these forms are user-friendly and efficient, allowing for accurate data collection. - Visual Representations: I need the data to be visually represented in the form of charts, graphs, and tables. Experience with data visualization and formatting is required to ensure that the data...
...real-life combat scenarios. Why Join Us: Strategic Partnership: This is more than just a job – it's an opportunity to become a key partner in our expansion, leading our machine learning initiatives to new heights. Leadership Role: As the Senior Machine Learning Engineer, you'll spearhead our efforts in leveraging machine learning technology, guiding and managing our talented teams to innovate and excel. Exciting Growth: VRAS is expanding rapidly, and we're looking for our next partner to join us on this thrilling journey. Equity Only Offer: This partnership opportunity is equity-only, reflecting our commitment to building a collaborative and mutually beneficial relationship. Future Salary: A rewarding salary is guaranteed once the project secures funding....
I have a AWS Infrastructure setup project requiring expertise in Cloudfront NLB and protection using WAF. As the goal is targeted at content distribution and load balancing, proficiency in these areas ...to access website on EC2 IIS with custom ports like 8080, 5440 etc and not standard 80 or 443. User will be providing url with port number and on IIS different website is binded with different port number. For WAF, protective measures against DDoS attacks, SQL injections, and XSS attacks are necessary. Thus, an understanding of these areas is also needed. Skills and experience: - Proficient in AWS services (Amazon EC2, ELB, Cloudfront and Amazon S3) - Knowledge of Cloudfront NLB - Experience with WAF - Understanding of DDoS attacks, SQL injections, and XSS attacks protecti...
As someone managing integral data via Excel, I am experiencing significant issues with formatting errors, especially concerning chart alignment for printing. I'm keen to hire an expert who is well-acquainted with handling these challenges. Key facets you should focus on include: - Rectifying formatting issues: Your primary task will be to identify and correct any formatting discrepancies in my Excel charts that hinder smooth printing. - Specialized in Alignment: A considerable part of the task involves aligning the charts properly to ensure hassle-free printing. Hence, a solid grounding in Excel chart alignment is necessary. Ideal Candidate: - Proficient in Microsoft Excel, specifically adept at creating and formatting charts. - Excellent problem-sol...
I'm looking for a freelancer who can type up data from an XLS Excel sheet. The data is related to different categories and I want it organized accordingly. Additionally, I would need some basic analysis done on this data; think simple calculations like sum and average. Ideal Skills: - Proficiency in Excel, specifically with XLS files - Experience in data entry - Ability to perform basic calculations Please note: This project doesn't require any complex analysis like pivot tables or charts, just simple arithmetic operations.
I am looking for an Excel expert who can assist in improving formulas and functions related to my current project. The focus will mainly be on Lookup and reference functions. Key Responsibilities: - Review existing Excel worksheets - Improve or create Lookup and Reference functions as needed - Verify functionality and accuracy of updates Necessary Skills: - Proficient in using Excel 2013 - In-depth knowledge of Excel formulas, specifically Lookup and reference functions. Experience with complex Excel functions is a plus. The goal is to streamline my workflows, so efficiency and attention to detail are critical for this role.
Looking for a large list of investors who have worked in or showed interest in various entertainment industries provide data in excel: name | company | industry | location | email address We're paying $50 for every 1,000
...among professionals within the specified countries and sectors. Companies’ details (I will provide the below mentioned list of companies):  United Arab Emirates (UAE) – 75 companies  Saudi Arabia – 50 companies  Turkey - 50 companies  Singapore - 50 companies  Hong Kong - 77 companies  Thailand - 50 companies Total 352 Companies Data Required: (I will provide you a template excel file, in which you can provide the below details) • Company's Name • Company’s website • Full Name of the key person (First & Last name) • Job Titles / Role in the company • Email Address (official and private) • Mobile/Phone Number • LinkedIn Profile (most important) Lead priority (Searching Key Words): 1st pri...
I have a data analysis project that I completed within the required timeframe. This project involved analyzing sales data to identify trends. Key Points: - Project Type: Data Analysis - Goal: Trend Analysis - Data Source: Sales Data Ideal Skills and Experience: - Proficient in Data Analysis Tools: The ideal candidate should have a strong background in using data analysis tools such as Excel, Python, R, or any other relevant software. - Experience in Trend Analysis: A proven track record of conducting trend analysis is essential for this project. - Familiarity with Sales Data: Prior experience with sales data analysis would be considered a significant advantage. The successful completion of this project relies on the ability to extract meaningful insights from sales data and pres...
I need an Excel template tailored for my existing business to manage deliveries, sales, and balance quantities on orders. Key Features: - Advanced Formulas & Conditional Formatting: I require this to ensure the template is robust and can visualize data effectively. - Data Points Tracking: I need the template to include sections tracking: - Product names and categories - Customer names and contact details - Delivery dates and quantities - Profits and balances on Purchase Orders (POs) - Daily load outs reports The ideal freelancer for this job should have: - Proficiency in Excel, with extensive experience in creating advanced templates with conditional formatting. - A good understanding of business processes, especially in sales, deliveries, and inventory ...
...vibrant, knowledgeable Microsoft SQL trainer for my client who can help me elevate skills to an intermediate level. Fluent Tamil communication is a must as I feel most comfortable learning in this language. Key Learnings Expected: - Database Creation: Learn how to build an efficient and well-structured database from scratch. - Querying and Managing Data: Gain expertise in extracting, manipulating, and managing data. - Advanced SQL Concepts: Explore more sophisticated SQL concepts to comprehend the language's full capabilities. Ideal Freelancer's Profile: - Experienced MS SQL tutor with a strong understanding of database creation, handling data, and advanced SQL topics. - Proficiency in teaching in Tamil. - Proven experience in educating a...
Hello, I have a CSV file that contains our product catalogue, that file is dynamic, is contained on a hosting (www... ) and change the stock and products info each X hours, I need upload that catalogue products to Amazon
Hello, I need upload my CSV catalogue products to Amazon, is a dynamic CSV cointained on a hosting that change and refresh the information
I have a project that entails transferring text data from a PDF into Excel. Given that the information is well-structured, this task should be a smooth process for anyone proficient in data entry and comfortable handling documents in both PDF and Excel formats. Key Tasks: - Transcribe text accurately from the PDF to Excel - Ensure data maintains its structured format Ideal Skills: - Extensive experience with data entry - Proficiency in PDF and Excel - Detail-oriented and high accuracy rate A successful completion of the project would entail an Excel sheet in which the transferred text data from the PDF maintains its original structure.
...specific data from a website containing a list of potential investors. The project requires an attention to detail as well as proficiency with Excel or similar spreadsheet software. Key tasks: - Visit a pre-specified website and navigate to the list of potential investors. - Carefully extract the following details for each investor: Name, Fund name, and 'Sweet Spot' investment amount. - Collate this information in a well-organized Excel spreadsheet. - Find and add a link to each investor's LinkedIn profile alongside their extracted details. Specific requirements: - A meticulous approach to uphold the accuracy of data. - Experience or familiarity with Excel or similar spreadsheet software. - Strong data extraction and entry skills. - A detailed pro...
I need a Laravel Expert to make two separate tasks urgently. Task 1: Wherever something specific is not specified, you have complet...available in the DB • Add create/edit functionalities. Requirements: o Country field should be a dropdown populated from the DB o Active field should be a checkbox o Show how many months the client is registered in our DB o Validate the inputs in the backend (basic validation) • Add delete customer functionality • Implement a simple search functionality. The search fields are by your choice. • Create “Import from CSV” functionality for adding new clients into the DB. Mandatory fields - email and country. Rules: You can use – Laravel, JS libraries, Google search, etc. The frontend is not important, so don’t...
Excel to Invoice Automation System My project involves leveraging Power BI, excel, and macros to automate the invoicing process. I am specifically looking to reduce the manual work that comes with data transfer. Requirements: - Develop a system to automatically generate and track invoices from excel spreadsheets - Implement a robust and error-free data transfer process - The final product should be able to streamline the entire invoicing process Ideal skills and experience: - Deep experience with Power BI, excel and macros - Understanding of finance and invoicing processes - Proven track record in creating automated systems - Strong problem-solving skills, attention to detail. In conclusion, I need someone capable of merging my existing software with a new a...
Seeking a SQL specialist (4-5 hr/day part time remote job) excelling in data partitioning, indexing, complex query calculations, and impeccable SQL design. Here's a snapshot of what my project entails: - Enhancement of a medium-scale database (1,000 - 10,000 records) using best practices - Expertise in SQL Design for efficient data management - Aptitude for complex query calculation to enhance speed and accuracy - Proficiency in data partitioning and indexing - Equally prioritizing both query optimization and database design - Excellent communication skills for steady project updates Ideal candidates must have a knack for balancing database design and query optimization. Let's push the boundaries of what SQL databases can achieve together!
...am in need of a proficient VBA and Excel Macros expert to develop a simple, yet efficient invoice/billing application. Key Features: - Generation of invoices from input data. - Tracking and calculation facility for totals. - Maintaining a robust database for customers and invoices generated. Interface Requirements: - The GUI should be straightforward and user-friendly, allowing quick input, management, and retrieval of information. Data Handling: - The application should exploit Excel capabilities for the storage and manipulation of all the data, including customer and invoice records. Ideal Skills & Experience: - VBA and Excel Macros expertise. - Experience in creating user-friendly GUIs in Excel. - Able to develop robust database systems in ...
...management. Therefore, we're seeking an expert in Excel to build us an inclusive inventory management template. The template should possess the following specialized features: - Product Categorization: A way of classifying each product for straightforward identification and reference. - Stock Tracking: The prime functionality we're seeking. Notably, it should track items by product name. This will ensure precision in monitoring our inventory and prevent replication or confusion. - Comprehensive SKU Tracking: It should encase a complete and precise representation of our stock movements. Specifically, it should include incoming stock, outgoing stock, and current stock levels. An ideal candidate for this job should have extensive experience in Excel, particularl...
I'm in need of a freelancer who is skilled in designing both process and workflow flowcharts via Microsoft Visio, as well as project management checklist forms in Excel. The checklist should be of an intermediate level complexity, incorporating features such as drop-downs and validation. Prior experience in constructing Visio flowcharts and Excel forms is imperative to understand the project's need thoroughly. Proficiency in Excel functionalities would make tackling this task comparatively easier.
I am seeking a skilled programming expert, proficient in either Ruby or Python, with intermedi...primary task involves intelligently executing aggregations and nested queries in ElasticSearch, extracting data, in JSON format, and then transposing it into Excel or CSV format. I'm open to whichever format you are more comfortable with, so long as it is either of the two mentioned. In addition to this, having familiarity with job automation via GitHub is critical for this project role. This background should include understanding how to automate and schedule tasks to regularly extract, convert, and save this data. Ideal Skills: - Proficiency in Ruby or Python - Intermediate level ElasticSearch querying - Experience with JSON to Excel/CSV conversion - Familiarity with Git...
Entering data into an Excel sheet is the primary task for this project. Unfortunately, I cannot specify the volume of data that needs entering as I skipped this information. However, please rest assured that there is no immediate rush, so you can complete the project at a pace that suits you. Ideal skills and experience for this job would include: - Proficiency in Excel data entry - High attention to detail - Excellent typing speed and accuracy - Relevant experience in data entry jobs If your profile matches these criteria, I'd be delighted for you to submit a bid. Looking forward to potentially working with you.
I'm in need of a skilled developer to create an Android application with ASP.NET C# backend and SQL SERVER database. Key Features: - The app should primarily function as an e-commerce platform, allowing users to browse through products and services. - I require the app to have a chat functionality where users can communicate with the sellers. - Users should also be able to leave reviews for products. Specific Chat Features: - The chat functionality should support text messaging, image sharing, and voice messages. Skills and Experience: - Proficiency in Android app development - Strong experience with ASP.NET C# and SQL SERVER - Previous experience in developing e-commerce apps - Proven track record in integrating chat functionalities within an app - Familiarity with i...
I'm looking for a skilled data entry professional who can assist me with inputting data. The exact details of ...data and proficient in working with different formats. Your responsibilities will include, but are not limited to: - Efficiently and accurately entering data into the required format - Ensuring that the data is correctly categorized and organized - Checking for errors and handling them appropriately Ideal Skills and Experience: - Proven experience in data entry - Proficiency with Microsoft Excel and other relevant software - Strong attention to detail and accuracy - Excellent time management and organizational skills Please note that the volume of data may vary depending on the project, so a flexible approach and willingness to adapt to different task size...
I need a proficient expert in Excel to type numeric data and carry out basic arithmetic calculations. The scope of the project includes: - Data entry of numeric information into an Excel sheet. - Applying basic arithmetic operations to the input data. The ideal candidate should have: - Proficient skills in Excel, specifically with numerical data entry and calculations. - A keen eye for detail ensuring accuracy in calculations. - An excellent understanding of basic arithmetic operations.
I need a detail-oriented and focused individual who excels in manual data entry to convert data from my physical documents into a spreadsheet. Requirements include: - Transferring data from paper formats into a computer system - Strong typing speed and accuracy - Experience with MS Excel or similar spreadsheet software - Ability to maintain confidentiality when handling sensitive information. Accuracy is absolutely critical for this project, so keen attention to detail is a must. Previous experience with similar projects will be highly regarded.
Company name: Pacific Trading Alliance Name: Adam Cai Title: Director Mobile: +61 4 9999 8999 Landline:+61 3 9015 9388 Address: Level24, 570 Bourke Street, Melbourne, VIC3000 Need to include a “PTA” logo Company is for import export As simple as possible Check Apple’s business card design for inspiration NOT using apple logo please
