How to read an excel file into a database jobs

I'm looking for someone with strong data gathering skills who can create a comprehensive Excel spreadsheet. The spreadsheet must contain a list of all Australian suburbs along with their corresponding Local Government Areas (LGA). The essential points to be kept in mind are: • The list should be sorted by council areas for easy navigation. • Only the name of the suburbs and their corresponding council areas are required. No additional components such as population or region data are necessary. This project might require advanced web searching capabilities and attention to detail to ensure accuracy of the compiled list. Experience in data extraction is highly desirable.

...someone who can create a database in MS Excel for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List). 2- A list of all Contracts. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. There should be a Dashboard (Main Page) with link to the pages (Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages) on the top, and below the page list there should be the statistical data of the database. For Add New Invoice page, I should be able to add an invoice details, an...

I'm in need of someone skilled in Microsoft Excel for a couple of tasks. - **Formatting:** Firstly, I require assistance in formatting the spreadsheet. This will include ensuring that the data is clear and easy to read. I would like the spreadsheet to look professional. - **Formula checking:** While the formulas used are not too complex, I still want them to be checked thoroughly for accuracy and consistency. This will mainly involve basic arithmetic operations. I'd appreciate it if you have a background in financial analysis. It would be helpful to have a good eye for detail as well.

I'm in need of a skilled VB.Net developer to assist with an urgent task. I have a JSON file that needs to be deserialized in order to extract its text content. This data migration task is quite simple - the JSON structure is not complex with only a few nested elements. This project is of utmost urgency, and therefore, needs to be completed as soon as possible. I'm looking for someone who has experience with: - VB.Net - JSON deserialization - Data migration Your task will be to create a script in VB.Net that can efficiently read the JSON file and extract the text content. This script will be a crucial part of our data migration process. If you have the necessary skills and can ta...

The target is to write a Java, console program (public static void main) that will generate a docx Word file. Program needs to use docx4j library () Programm needs to generate many parts: Heading1, Heading2, Heading3, every with some content (lorem ipsum) Make a table of contents (showing on which page is a given Heading1, Heading2, Heading3 - not hard coded, but detected) Heading1 --Heading2 ----Heading3 ----Heading3 --Heading2 ----Heading3 ----Heading3 Heading1 --Heading2 ----Heading3 ----Heading3 --Heading2 ----Heading3 ----Heading3 In the text put links to a concrete Headings, eg. "read in Heading2 - abc (page 4)" - it should be link to this section and "(page 4)" shou...

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample

I require an experienced and proficient VBA developer to create a code that automates data entry tasks in Microsoft Excel. The main objective is to significantly increase productivity and ensure accuracy by automating repetitive data entry procedures. Ideal skills would include: - Vast knowledge of VBA and Excel - Prior experience in developing automation scripts - Exceptional attention to detail - Ability to work within strict deadlines

Please read the content of the requirements - ONLY SPANISH SPEAKER I am seeking an experienced 360 marketing specialist for my social media platforms which include Facebook, Instagram, LinkedIn, and Twitter. The successful candidate will need to be a native Spanish speaker. To sell Point of sale For B2B sells of software Key responsibilities include: - Creating engaging and compelling content that will resonate with my target audience - Designing and implementing a comprehensive social media strategy aimed at driving sales - Creating and designing the Ads - Monitoring and analyzing metrics to ensure the effectiveness of campaigns

I need a simple web application developed using the Scriptcase platform. The main functionality of the project will be integrating a database into the application. This will include data for user profiles and product listings. Key Requirements: - Development experience with the Scriptcase platform is a must - Proficiency in PHP and web application development - Experience in integrating databases into web applications Other Details: - The application must be user-friendly and intuitive - No specific user roles or permissions are required, all users will have the same level of access.

I'm in need of a seasoned Excel expert who's proficient at conducting optimization analysis to solve a real-world problem. Key Requirements: - Profound understanding of optimization analysis - Ability to work efficiently and quickly - Experience with diverse Excel functions Please note that the specific goal of the optimization analysis requires maximizing profits, minimizing costs, or optimizing resource allocation. Your expertise in this area will be crucial to our success.

I need an expert to convert tables from a PDF file into an Excel spreadsheet. The job involves transferring text and numbers from a multi-page PDF table to an Excel document. I have attached the PDF. The analysis should start from page 7. Here's what the project entails: - Converting data from a PDF table that includes both text and numbers - Handling tables that span across multiple pages in the PDF - Transferring the data to Excel without any need for specific formatting or layout changes - Provide the developed script used to obtain the records from the tables. As a freelancer, you should have: - Proficiency in PDF to Excel data conversion - Ability to...

**Contest: Excel Specialist Wanted for Comprehensive Property Portfolio Management Tool!** Are you an Excel virtuoso with a passion for crafting intricate and comprehensive spreadsheets? We're embarking on a quest to develop the of a cutting-edge Property Portfolio & Financial position Management Tool for our discerning clients. If you possess the expertise to meticulously organize data, create advanced formulas, and design visually captivating presentations, this contest is tailored for you! Join us in revolutionizing property portfolio management with a document that sets the standard for clarity, accuracy, and usability. I would like to be able to edit if required in the future therefore 2 copies will...

I'm in need of a skilled computer expert to help me develop a database. This database will essentially serve as an accounting tool for food. It's crucial for me to keep track of various aspects of my food-related transactions, including purchases, sales, and expenses. I require a professional who can translate these needs into a well-structured database. Key requirements include: - Data on food purchases, sales, and expenses should be efficiently stored and easily accessible - The database should be designed to facilitate clear accounting procedures - The system should be user-friendly and reliable, making it easy for me to input data and generate reports as needed Ideal skills an...

...need of a graphic designer who can help me with converting my existing logo into various file formats. Requirements: - I already have the logo, I just need it converted into PSD, JPG and PNG file formats. - The logo will be used for printing on shirts, so it's important to ensure that the converted files are high-quality and suitable for this purpose. Preferences: - I have specific color preferences for the logo and would like the designer to match the colors to the copy sent. - The font and typography used in the logo are the same as the image I've sent, please ensure this is kept consistent when converting to the different file formats. Ideal Skills: - Proficiency in graphic design and editing softwar...

problem one database erp hosting program

I need a software expert to develop a program that scrapes text content off of multiple websites and then cross-references this data against another site. Key Requirements: - The software should effectively pull out text content from all provided sites. - The text content should be in a plain text format, ready for easy analysis and interpretation, preferably in an excel spreadsheet or comma delimited list. - The cross-referencing component is crucial, as the software will need to compare the data scraped with that of another website. Qualifications: - Background in Data Scraping and Software Development. - Previous experience with cross-referencing data. - Proficiency in handling different data formats. In essence, I'm looking for...

I am looking for someone skilled in Microsoft Excel and Power Automate. This task involves creating an automation system that sends emails to our internal team members based on given triggers. The automation should trigger when: - An event's start date is approaching - An event's deadline is nearing The email content should serve as a reminder of the approaching start dates. It's pivotal that the chosen freelancer can work with accurate detail to ensure that no deadlines are missed. A deep understanding of Excel, or similar spreadsheet software, automation, and email systems is required for this task. Experience working with scheduling and deadline tracking will be an advantage.

...require an expert in Excel to help me with a statistical analysis of my sales data. The key tasks for this project are: - Conducting statistical analysis: I need you to run a detailed statistical analysis on my sales data. This will involve using advanced Excel functions to analyze variables such as sales trends, forecasts, and correlations. The ideal candidate for this project should have: - Proficiency in Excel: The chosen freelancer should have a deep understanding of Excel and be skilled in using advanced functions. - Statistical Analysis Expertise: Experience in statistical analysis is crucial, as you will be required to interpret the data and provide insights. - Attention to Detail: The ...

...with our Oracle database under heavy loads, leading to frequent hangs and disruptions in our operations. To address this critical situation, we are seeking the expertise of an experienced Oracle Advanced DBA freelancer. We require a professional with the following qualifications and skills: - Extensive experience in Oracle Database Administration, particularly in high-load environments - Proficiency in performance tuning, query optimization, and troubleshooting - Familiarity with Oracle Enterprise Manager and other monitoring tools like aws performance insights The main responsibilities will include: - Diagnosing and resolving performance issues - Implementing best practices for database management and optimization - Ensuring high a...

I need to improve the existing features of an Excel macro, focusing on enhancing the user interface and experience. Key points: - The primary goal is to make the macro more user-friendly, interactive, and provide better feedback to users. Ideal skills: - Advanced Excel Skills - VBA and Macro Programming - Strong UI/UX design capabilities - User Feedback Integration Please bid if you have experience in enhancing Excel macros in a user-friendly manner and can improve the UI/UX by adding interactivity and feedback. I have a macro working fine. We need 3 improvements: 1- Label photos as A, B and C / 1, 2 and 3 then macro relabel photos per photo matrix 2- Instead to use “SN” in the folder name I want...

I'm looking for a skilled freelancer who can help automate various tasks in Excel. This includes, but is not limited to, data entry, formulas, and calculations. Key responsibilities: - Automating data entry processes within Excel - Implementing advanced formulas and calculations to streamline calculations - Generating reports and carrying out data analysis using Excel - Ensuring the accuracy and integrity of automated processes Ideal skills and experience: - Proven experience in automating tasks in Excel - Advanced knowledge of Excel functions and formulas - Ability to understand complex data sets and create accurate reports In your application, I'd like to see: - Examples of similar projects you've wor...

I need a simple static HTML banner ad designed, sized at 250x250 pixels. The banner is intended to promote my business by displaying a clear message, 'We Pay for our Clients Inspections!'. i was thinking "We Pay" could be larger on the first of 3 lines and 2nd line could be smaller and read "for Clients" and the bottom line would be "Inspections" it should be colored similar to this page coloring: Key requirements: - The banner should be static, no animations are needed. - The design should be eye-catching and present the message in a clear, visually appealing way. - It should be suitable for web placement. Ideal skills and experience for this job: - Proficiency in HTML and CSS to design the banner...

...in need of an experienced Visual C# developer with expertise in User Interface (UI) design and database integration. The ideal freelancer for this project should have: - Proven experience in Visual C# programming - Ability to create a clean and minimalist user interface. - Proficiency in database integration, specifically with handling user data and profiles. Main tasks and features include: - Developing an intuitive and minimalist UI using Visual C#, to ensure easy navigation and optimal user experience. - Integrating the system with a database that handles user data and profiles. This includes setting up, managing, and maintaining the database to ensure its smooth operation. This project requires a...

I am seeking an expert in data entry, particularly in the tasks of document conversion, data processing, and data verification. This role necessitates the management of confidential and sensitive information, hence, a demonstrated respect and understanding for data privacy is paramount. Key Responsibilities: • Document conversion • Data processing • Data verification Required Skills and Experience: • Proficient with MS Excel • Demonstrated experience in similar roles handling sensitive data • Strong attention to detail • Respect for privacy and confidentiality Note: Familiarity and experience with utilizing formulas and pivot tables within Excel are highly desirable, given the nature of tasks to be performed....

I'm seeking an experienced C++ developer to create an effective Parallel File System based on the Google File System (GFS) - a system we'd like to dub as miniGFS. This project seeks to achieve: - Efficient storage and access of large files: The miniGFS should handle large data quantities seamlessly, allowing both read and write operations swiftly. - Data replication and fault tolerance: This project prioritizes data integrity and availability, necessitating a system designed for data replication and recovery in the occurrence of a fault. - Parallel processing: Optimum speed during file operations can be achieved through parallel processing functionality and the miniGFS should capitalize on thi...

I need assistance with copying & pasting data from spreadsheets. The dataset is less than 1,000 entries. Ideal skills and experience for this job: - Experience with data entry, especially from spreadsheets - Attention to detail - Proficiency in Excel - Ability to meet deadlines It's a straightforward task. The goal is to ensure the data is accurately copied and pasted.

I need an experienced Excel programmer to automate repetitive tasks and create custom VBA macros for my project. This assignment requires basic level tasks, so extensive experience in complex macros isn't necessary. Here is what I expect: - Automation of several repetitive tasks to streamline workflow and increase productivity - Creation of custom VBA macros from scratch Ideal Candidate: - Extensive experience with Excel automation and VBA macros - Ability to comprehend and successfully complete basic level assignments - High attention to detail and accuracy Please include your Excel automation and VBA macros experiences in your application. I look forward to working with you on this project.

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample

**Please read the attached job post carefully and apply if interested. This is a full-time at least 6 months contract to be renewed. An interview will be required before selecting the right candidate.** I am looking for a marketing specialist with a strong understanding of various marketing strategies and the ability to target specific audiences. The goal of the campaign is to increase brand awareness. Ideal skills for this job include: - Flyers creation - Proficiency in social media marketing, email marketing, and influencer marketing. - Experience in creating and executing multi-channel marketing campaigns. - Strong understanding of the target audience of young adults (18-24), working professionals (25-35), and parents (30-45). -...

The task consists of uploading an Angular application to AWS, its API and the database. It has to be done by anydesk and I need it now. Please write "ragnar" to see you read the post, you must be an expert in AWS. I can pay $30 for this. Thank you.

Integration of the clients CRM/ERP's so that the bot can answer to the client with human language. with the Intranet. 2 When the CUSTOMER MESSAGES DETECT If it is Customer or not and create a different communication based in the data in the system so answer the questions. After answering the questions, read our intranet If there is no response, I will pass it on to my colleague and pass it on to Human.

I have a logo concept that I need help with. It's a vertical chain of letters, linked with a connecting feature (arrow). Key Requirements: - Enhance and align the letter chain effect and connecting arrow - Clean up stray pixels and prepare it for higher resolutions After the design adjustments, I need the final logo delivered in 18 different formats: - JPEG, PNG, and GIF - Black background, white background, and clear / no background - one medium resolution (modest file size for easy web browsing) and one high resolution (max 4 MB) file size Your advice on appropriate image and file sizes will be of value; I am not an expert in this matter. Your work will ensure that the logo is versatile, visually appealing, and ready to be...

Product Description: - FamPe is a platform that enables viewers to interact with their influencers through messages and monetary contributions. Adding a monetary contribution prioritizes and highlights their comments/messages. Brand Name: FamPe "Fam" is a keyword used by influencers to refer to their fans because it creates a sense of closeness and community. This platform enables fans to contribute (monetary contribution) to their influencers, especially in Live Streams. That's where the name FamPe comes from. Brand Values:- - Innovation - Reliability - Efficiency - User-Friendly Logo Style Preferences:- - Audience: YouTube streamers and viewers, ages 15-45, worldwide demographic - Type: Wordmark logo, modern...

I'm seeking an experienced Excel wizard capable of making my inventory report more dynamic and adaptable. Here's what I need: - Total Calculations: The report doesn't currently update the total inventory count and monetary value when I adjust the count of individual items. I require this to be automated so the totals are accurately recalculated whenever an inventory count changes. - Regular Updates: Going forward, I will be regularly updating inventory counts on a weekly basis. I would appreciate if the system is simplistic and user-friendly for regular updates. Ideal Freelancer Skills: - Advanced knowledge of Excel functionalities - Experience on inventory management systems - Meticulous attention to detail - Ability t...

I'm looking for a skilled engineer who can design a self-supported steel chimney for a metal manufacturing plant. This chimney will be integral to industrial emissions control. Tasks Include: - Tailoring the design to accommodate the specific needs of a metal-manufacturing environment. - Incorporating robust safety features and compliances for high-temperature metal emissions. Ideal skills: - Structural Engineering - Industrial Design - Knowledge of industrial emissions standards - Experience with metal manufacturing processes.

ONLY RESPOND IF YOU CAN WORK ON THIS NOW. I urgently need assistance with my potentially damaged Microsoft Exchange 2016 database. I'm not sure if it's damaged, but I'd like an expert to mount it.

I'm in need of a skilled developer who can create an AI portal that is capable of efficiently extracting table data from PDF documents. The extracted data should be organized and saved into a customized Excel template. Additionally, the system should be designed to assign different user IDs with varying levels of access control. Key Requirements: - Develop an AI portal with the capability to extract table data from PDFs. - Organize and save the extracted data in Excel using customized templates based on the source PDF. - Implement a user management system that assigns different access controls to various user IDs. Ideal Skills and Experience: - Proficient in AI development and data extraction techniques. - ...

I am in need of an experienced SQL database administrator to help me move an entire SQL database from one server to another. The new server has Windows Server 2012 R2 installed and the SQL software is up and running. However, I am unsuccessful in attempting to access this via the network. Key Tasks: - Transfer the entire SQL database to a new server - Setup proper network access - Continue all ongoing operations from the source server on the new server Ideal Skills: - Rich experience with SQL and Windows Server 2012 R2 - Understanding of maintaining active operations during server shift - Firewall setup and operations Security isn't to be compromised during this relocation. The current server has a...

...Processing for User Face Image with Clothing Overlay I am looking for a freelancer who can utilize AI technology and image processing to create a single image that combines a user's face image with clothing overlay. The specific requirements for this project are as follows: AI Technology: - The freelancer should have expertise in image processing techniques to achieve the desired result. API Preferences: - There are no specific API preferences, and the freelancer can use their discretion in selecting the most suitable API for the task. Final Output: - The final output should be a single image that contains the user's face image with clothing overlay. - The clothing overlay should include a t-shirt from a second image ...

...based on the specific skills required to answer them correctly. The task will be to review 50 past papers - containing approx 50 questions each. For each question, I need someone to: - cut & paste an image of the question into a Google slides / Powerpoint document - 1 question (or sub-question if it requires a different skill per page - 1 document for each paper - name the skill(s) that are required to answer each question - as the title for each page - create a new line in a Google Sheets / Excel document with the following information: - skill required (copied from title of Google Slides document) - page number of Google Slides document that the question appears on Key Requirements: - The ...

I'm looking for a Python developer to assist me in creating a web scraper that can extract specific text content from a website on a weekly basis. The scraped data should be efficiently saved to a CSV or Excel file for easy review. Capable of being plugged to a distribution app. Key Requirements: - Develop a Python-based web scraper that targets a website to extract text data - The scraper should be designed to run on a weekly schedule - Ensure that the code is concise and easy to understand for potential future modifications - Store the scraped data in a CSV or Excel file format Skills and Experience: - Proficiency in Python programming - Expe...

I'm looking for a proficient Excel professional to develop a multi-country income tax calculator. This tool will primarily serve individual taxpayers, and potentially other user groups. Key Requirements: The calculator should support income tax calculations for multiple countries. This requires a deep understanding of tax laws and calculations in each country. - The tool should be user-friendly and intuitive, catering to users with different levels of tax knowledge. - It should be well-structured, with separate sections for each country to avoid any confusion for the end-users. Ideal Skills and Experience: - Advanced Excel proficiency, with experience in creating complex calculators or financial models in Excel. - ...

I need an expert to develop a macro tailored to automating report production tasks in Microsoft Excel. The main purpose of this project is to streamline the process of regular report production and increase overall efficiency. Ideal skills and experience include: - Proficient in Microsoft Excel - Experience in macro development to automate tasks - Knowledge in automating report production Your role will involve designing and implementing a suitable macro for regular report production in Excel. I'm looking for someone who can provide a timely and efficient solution.

...for an experienced translator to adeptly translate a self-help book from English to Gujarati. The book is approximately 10,000 to 50,000 words long. Key responsibilities: - Accurately convert the nuances of the self-help genre in Gujarati. - Maintain the integrity and voice of the original text. - Deliver a high-quality translation free from grammatical mistakes. Ideal skills for the job: - Excellent written proficiency in English and Gujarati. - Knowledge and understanding of the self-help genre. - Proven experience in book translation. This project requires a balance of precision and creativity to achieve an engaging and faithful translation of the self-help book. Candidates should have a proven track record ...

I'm seeking an exam invigilator with at least a Bachelor's degree to administer an on-site exam in Salmiya, Kuwait. This is a one-time gig with the potential for future opportunities. We provide test administration and accommodation solutions to test-takers nationwide. For this purpose, we look for professionals who we contact on an "as-needed" basis to see if they are available to assist test takers for their approved accommodations. We provide complete training and assignments pay hourly for the entire scheduled time, even if the exam ends early. We have a computer exam coming up where a test taker has been approved for communication assistance. The candidate is deaf or hard of hearing but ...

I'm seeking a skilled virtual assistant with proven communication abilities, to work specifically in US timezone. Your main duties will include: - Bidding on projects: You will need to represent our brand professionally and persuasively when bidding on projects. - Communicating with leads: You'll be responsible for using various messaging platforms to engage with potential clients and leads. Ideal candidates should excel in written communication and have a knack for sales. Proficiency in project management tools is a plus. Our preferred mode of communication with leads is through messaging platforms.

Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.

I need a comprehensive and professional formatting of a government project report. This report is aimed at analyzing the effectiveness of current government programs, identifying areas for further improvements and suggesting recommendations for future initiatives. The needed formatting requirements include: - Font style and size - Heading styles - Margins and spacing - Including images, tables etc. Ideally, you possess a keen eye for detail and an understanding of government report structures. A background in preparing and formatting formal documents or reports is a plus. The project has to be completed ASAP, so time management skills are crucial. Please bid, outlining your relevant skills and estimated turnaround time.

Need 2 hours tutoring. I have a wix website and I want to understand how to add and remove blogs on the wix website. please let me know the price for 2 hours tutoring.

I need help with my Microsoft Excel project! Specifically, I require assistance with the following: - **Formulas and Functions:** - Basic arithmetic operations. I don't need anything too complex, just fundamental formula structures. - **Automation:** - No macros for repetitive tasks are required, but I need guidance on setting up conditional formatting rules within the document. I'm looking for a Freelancer who is experienced in Excel and is comfortable with basic arithmetic operations and conditional formatting. You should be able to provide clear, concise, and easy-to-follow guidance. A strong attention to detail and excellent communication skills are a must. If you're proficient in these areas, I'd l...