Import excel data database jobs
i have a few functions that need to be done. you will have to load a excel doc to get everything to work but most aren't horrible.
I'm looking for an expert in data entry to help me with a particular task. - This will include rearranging the columns or just retyping into a new speadsheet. Super easy, I just don't have the time. Using the Fedex Fissler spreadsheet information, and inputting only the necessary information in the format provided on the second spreadsheet called Fissler Spreadsheet corrected. We only need to capture; Name, Address, city, state, zip, service type and actual weight. This project requires a meticulous eye for detail and an ability to work efficiently with data. Experience with Excel or Google Sheets is a must. Please get in touch if this sounds like a job you'd be interested in.
I am in need of a freelancer who can help me gather contact details from a couple of websites and organize them neatly in an Excel sheet. Key Details: - Websites: I have a couple of websites I need information from. The information is public and doesn't require any special access. - Information Needed: I'm interested in contact details such as phone numbers and email addresses. - Excel Organization: I want the contact details to be listed in a single list without any specific categorization. Skills and Experience: - Web Scrapping: You should have experience in web scrapping to efficiently extract the contact information required. - Data Entry: Proficient in Excel and attentive to detail to ensure the information is accurately documented. - Profici...
I'm in need of an experienced Excel programmer to create a customized program for data analysis. The primary purpose of the program is to assist in data analysis. Thus, it should help in organizing and interpreting large sets of data. The program will need to handle data from two main sources: - Text files (CSV, TXT) - Manual input The ideal freelancer for this job should have a strong background in Excel programming and data analysis, with specific experience in handling various data types and creating efficient, user-friendly Excel programs. Key Skills: - Proficient in Excel programming - Skilled in data analysis - Experience working with text files and manual input - Ability to create user-friend...
...another account in Zerodha. Functionality – 1) Login: Take credentials from excel like username, password ,API key , secret code, totp key and totp from authenticator for all accounts (master and child both) (basically after generating token) - all these on a single click on starting python file. 2) Order Punch: Copy all orders including NRML (SL-M , SL – limit) and MIS (SL-M , SL – limit) GTT, and trades (only completed- not rejected) from the main account to child accounts 3) Order Modification: If we cancel/modify any order on price and quantity, the cancellation/modify should also be cancelled/modified in all accounts 4) Primary account selection : Should have functionality of changing the primary account in excel , we can have predefined criteria for...
I'm looking for a professional to help in setting up an SQLite database which will store and manage moderate data with multiple attributes. Key requirements: - The database should be optimized for storing and retrieving moderate data, such as an inventory system with multiple attributes. - No complex data analysis is necessary, just a user-friendly system for managing and retrieving stored data. - Basic search and filter functionalities are required. Ideal skills for the job include: - Proficiency in SQLite database design and management. - Experience in setting up databases for inventory systems or similar systems. - Ability to implement basic search and filter functionalities.
I'm seeking a skilled professional who is proficient in FEMM for a magnetostatic simulation. Below is the automatic description. Before that, a few words from myself. I need to setup a simulation that I will be able to run easily myself. I will need to import shapes from CAD and be able to chose materials (N52, N42 seem the first ones to try). I will need to measure field in mGauss in different points away from the magnet. Key Requirements: - Proficiency in FEMM: Experience in using this software for magnetostatic simulations is crucial. - Magnetic Field Distribution: The main goal of this simulation is to analyze and visualize the magnetic field distribution. You should have a good understanding of this aspect. - Materials Expertise: While I haven't specified the mate...
I have a challenging case study that requires a thorough analysis of sales data and survey data. I'm looking for an expert who is well-versed in Excel to help me with this task. Key tasks and requirements: - You'll need to perform trend analysis on the sales data. - You'll also be required to visualize the sales and survey data. This will include a detailed geographical analysis. - The data visualization should be able to provide clear insights and comparisons between different variables. Ideal Skills & Experience: - Proficiency in Excel, including advanced data analysis features. - Experience with trend analysis and data visualization. - Previous experience with geographical analysis is a plus.
I have a photo that contains a mix of text, tables, charts, and images that need to be converted into Excel and Word formats. The key requirements are: - The data in the photo must be completely editable in both Excel and Word. This includes all text, tables, charts, and images. - The photo contains a mix of content, including text, tables, charts, and images. It's important that the freelancer is able to accurately capture and translate all of this information into the Excel and Word formats. Ideal skills and experience for this job include: - Proficiency in data entry and extraction. - Advanced skills in using Microsoft Excel and Word. - Experience in handling mixed content (text, tables, charts, images), and the ability to accurately r...
I'm currently experiencing slow performance from my WordPress database that appears to be most apparent when using Mysql/MariamDB which is affecting my admin and dashboard areas. Ideally, I'm seeking assistance from a professional with substantial experience in WordPress and database optimization. The main skills and experience required include: - Knowledge and skills in MySQL/MariaDB - Expertise in WordPress database management - Experience working with websites having more than 20 plugins. Your task will include performing necessary optimizations to significantly enhance the performance of the website, specifically the admin and dashboard areas. Please, include examples of similar projects you've worked on when bidding.
The developer must be able to create an app that can ... 1. open a video of a wrestling match. 2. app will be able to "mark" various spots within the wrestling match that will interest an evaluator. 3. the marks are created by clicking on a button where the evaluator must go to review. 4. The app will create a score using Google Sheets. We are seeking a skilled video editor to mark several training videos using a custom screen. The marked areas will not only serve copyright protection interests but also provide necessary instructions to aid in understanding video content. Key tasks include: An ideal candidate would have noteworthy experience editing training videos and a solid understanding of copyright protection. A flair for seamlessly conveying instructions through such ...
I require an Excel expert to help me create and modify spreadsheets. Specifically, I need assistance in incorporating certain functions and features in the spreadsheet, as well as handling various types of data. Key Requirements: - Spreadsheet Creation and Modification: I need someone who is proficient in Excel and can help me set up and adjust spreadsheets to my specifications. - Data Visualization: The ability to create charts, graphs, and other visual representations of the data is crucial for my project. - Automated Reports: I'm seeking assistance in automating certain processes in my spreadsheet to generate reports efficiently. - Conditional Formatting: I will also need help with setting up conditional formatting in the spreadsheet. Data...
I'm on the hunt for a creative designer to craft a minimalist logo and packaging design for my organic product brand. Here's what's important for this role: - A knack for creating sleek, minimalistic design; simplicity is key. - Experience in creating memorable logos. - Capability to develop eye-...designer to craft a minimalist logo and packaging design for my organic product brand. Here's what's important for this role: - A knack for creating sleek, minimalistic design; simplicity is key. - Experience in creating memorable logos. - Capability to develop eye-catching, yet minimalist packaging. - Proven track record – please include examples of your past work in your application. If you excel in minimalist design and have a passion for creating str...
I am in immediate need of a comprehensive database containing information about IT professionals with 2-3 years of experience. This is crucial for a current initiative, thus I need it ASAP. The database should provide: - Name - Phone Number - Skills - Educational Background - Work Experience - Salary Precision is of utmost importance to me. Therefore, an ideal freelancer for this task should have proven experience in data collection and data entry, with a keen eye for detail to ensure the accuracy of the database. Experience in the IT or HR industries would be a significant advantage.
I need assistance in setting up a mail merge (publipostage) in Excel to report information from the Excel sheet into a Word template. Key requirements: - Excel Data Analysis: You should have experience in data analysis using Excel. - Mail Merge: Proficiency in creating mail merge documents in Excel advanced - Word Template Populating: Understanding of how to populate Word templates with data from Excel. It's important that only the text information from the Excel file should be included in the Word template. Ideal skills and experience: - Proficiency in Excel and Word - Experience in data analysis - Familiarity with mail merge functionality - Previous experience in setting up similar Excel...
Hi everybody, We need a full time data organizer who will be putting out bank statements into a proper excel format (which we will give). Please note that you will 70-90% of monthly work and you can keep taking other projects as well but we will give you full time pay of USD 500 and you have to remain available to us We have access to Able2Extract and can provide you a proper converted excel statement. However, in some cases, bank statements could be a scanned copy and hence you may need to manually enter data. This is a full time job and budget is reasonably fixed. Require an excel expert pro as there has to be a lot of data shuffling and data organizing into different folders. Need someone who can start immediately Thak you.
I need to import 70,000 products into my new Amazon store. The project requires someone with a strong understanding of Amazon’s product template, and the ability to work with large datasets in CSV format. There are three main components to this project: - Importing a large number of products: You will need to be able to handle a large volume of data and ensure that it is correctly entered into my Amazon store. - Managing product variations: Each product will need to be listed as a separate entity rather than a variation, so you will need to have a good understanding of Amazon's product listing system. - Updating existing products: You will also need to be able to manage and update existing products in my store. I am looking for a professional who has experienc...
I am looking for someone to assist me with data entry and related tasks in Excel and Word. I need some typing, copy and paste type of data, that needs to be entered in systematic way. Skills and Experience: - working in Excel/Word - Attention to detail - Experience with data entry or typing - Ability to follow instructions and work independently Preferred Format or Template: While I don't have a specific format or template in mind, I have a rough idea of how I would like the data to be arranged. I am open to suggestions and willing to collaborate on finding the most useful format for the data. If you have experience in data entry and are comfortable working with Excel and Word, please submit your proposal and include a...
I'm looking for an Excel expert to create a robust three-level lookup function that can handle text data. The primary goal of this function is to facilitate data analysis, and it needs to be followed by basic arithmetic operations based on the result of the lookups. Key requirements: - The Excel function should have a three-level lookup that can handle text data. - The primary goal of the function is data analysis. - After the lookup, basic arithmetic operations should be performed based on the result. - The work needs to "live" in only two places - the reference table worksheet, and the worksheet doing the calculations. Because of how I'm structuring multiple sheets, I can't have a "scratch pad" sheet with inte...
...with a typed data entry project that involves organizing the data into a database. While the data entry itself isn't particularly complex, a certain level of basic data cleaning will be required. Key Requirements: - Data Entry: The main task is to accurately input data from PDFs into a database. The data is mostly textual, so typing proficiency and attention to detail are essential. - Database Organization: The entered data needs to be organized in a clear, logical manner to ensure it's easily searchable and can be efficiently used. - Basic Data Cleaning: The data will need to be reviewed and cleaned up to ensure accuracy and integrity. This will involve identifying and removing any du...
...proficient Excel programmer who can assist with both data analysis and process automation. The project entails: - Data Analysis: Proficiency in sorting, filtering, and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process autom...
I'm looking for a skilled individual to assist with a less than ten PDF documents data entry project. Key Responsibilities: - Copy typing of content from PDFs - Extraction of specific data points - Validation for accuracy and completeness This role will suit someone with proven expertise in data entry and validation. The ideal candidate is detail-oriented and proficient in handling PDF documents. Experience with Microsoft Excel is a plus.
...+-1-|-2-|---------+ # ++++a+++|----5----+ # +-3-|-4-|---------+ # ++++++++b++++++++++ # +-------|--7-|-8--+ # +---6---|++++c+++++ # +-------|-10-|-9--+ # +++++++++++++++++++ the approach should return 10 as the total number of patches. (The numbers in the simplified case above are just added for the sake of clarity. The image data does not contain those numbers, obviously). - finally, given that the real estate registry needs to book-keep all the boundaries created, the program shall build an output image of the size of 1x(N+1). The image encodes as the first pixel the color of the background. Then it should encode "the color hierarchy" of all the N colors used to subdivide the ...
I'm urgently in need of a skilled professional who can swiftly deploy a database server for me. Key Responsibilities: - Establishing a server primarily intended for databases - Choosing the suitable database management system (DBMS) Ideal Competencies: - Extensive experience with multiple DBMSs as I'm not yet decided on which one to use - Ability to work under pressure and deliver swiftly since the project is urgent - Prior experience with server deployments will be highly advantageous.
I need a freelance expert to assist in calculating heat loss and heat gain through an Excel spreadsheet. Key Responsibilities: - Conduct heat loss and heat gain calculations just for the packaged plantroom. - based on the gains find the required fan flow rate to offset those gains Must be done on excel Skills and Experience: - Proficiency in Excel is a must. - Previous experience in heat loss and heat gain calculations for commercial buildings. - Knowledge of HVAC systems and how to optimize them is highly preferred. I can provide the equipment in the plantroom and the internal and external design conditions
...experiencing a persistent issue with lagging or delayed replication in my SQL Server database. The primary problem revolves around the replication process not effectively happening in a timely fashion. Ideal Skills-needed: - Solid skills in SQL Server management - Proficient understanding of database replication processes - Excellent problem-solving and diagnostic abilities in the context of database administration The ideal freelancer for this project will be able to not only identify the source of this issue but will provide a solution to improve the replication time. It's crucial that you have managed SQL Server databases before, ideally in a high-transaction environment, and have a deep understanding of data replication....
I'm in need of a data entry freelancer with a good command of Microsoft Excel. The task involves inputting data into a spreadsheet. The data is simple and involves just a few columns. This is an ideal project for a freelancer who is available to work from home. Ideal skills for this job include: - Proficiency in Microsoft Excel - Attention to detail - Ability to maintain accuracy while working with data Please note that I don't require any specific software knowledge other than Microsoft Excel. Looking forward to working together.
I need a freelance expert to assist in calculating heat loss and heat gain through an Excel spreadsheet. Key Responsibilities: - Conduct heat loss and heat gain calculations just for the packaged plantroom. - based on the gains find the required fan flow rate to offset those gains Must be done on excel Skills and Experience: - Proficiency in Excel is a must. - Previous experience in heat loss and heat gain calculations for commercial buildings. - Knowledge of HVAC systems and how to optimize them is highly preferred. I can provide the equipment in the plantroom and the internal and external design conditions
...an Access database that can primarily handle generating reports and analytics. The main goal is to keep track of internal data for further analysis and reporting. Key Features and Functions: - **Reports & Analytics:** The database should have the capacity to generate comprehensive and insightful reports from the data gathered. It's crucial that these reports are insightful and easy to understand. - **Data Tracking:** The database will be used for tracking internal data. This needs to be done with precision and the ability to link data for comprehensive tracking. - **Data Input & Updates:** The system should allow for easy input of data and updating when needed. This will facilitate the generation of acc...
I'm seeking an experienced professional who excel...seeking an experienced professional who excels in sophisticated data analysis, chart creation and process automation using Excel. You'll need to leverage data visualization techniques to deliver insightful dashboards, with a key focus on developing pie charts for clear, concise, and impactful data representation. Your responsibilities will include: - Analyzing and interpreting complex data sets - Crafting well-structured and insightful pie charts - Automating repetitive processes to improve productivity Core competencies required for this role include a strong background in Excel and data analytics, proficiency in dashboard creation, a keen understanding of automation process...
I am currently looking for talented Excel, VBA, and Macros developers who can assist in editing four planning files and managing their data in one main Excel file. The duties you'll be executing are as follows: Automating data entry: This will streamline the process of inputting inventory data, making it quick and efficient. Creating formulas and calculations: To aid in the management and manipulation of our inventory data. Generating reports from the data: We need detailed, clear reports to help analyze and evaluate our inventory. You should also know how to: Use Conditional formatting Work with Data validation Create and manage Pivot tables Set up an interactive Dashboard Knowledge and experience working with ‘In...
...workforce. Key Responsibilities: - Develop a structured sales training program encompassing various selling techniques, customer service, and product knowledge reinforcement. - Create engaging and interactive product training sessions that educate employees about our offerings, benefits, and unique selling points. - Implement a series of on-the-job training modules that help employees grasp and excel in their roles, while aligning their efforts with organizational goals. Ideal Candidate: - Experience in designing and delivering comprehensive sales and product training programs. - Proven track record in conducting engaging and effective online and offline training sessions. - A solid understanding of adult learning principles, particularly in a corporate setting. - Excellent com...
...APIs for seamless communication with the Flutter client. 3. Integrate third-party services to enhance platform features. 4. Manage data storage solutions and optimize database performance. 5. Ensure server-side code is optimized for performance and reliability. 6. Implement security measures to protect user data. Requirements: To excel in this role, you should: 1. Have proven backend development experience. 2. Be proficient in backend programming languages like Python, Node.js, or Java. 3. Have familiarity with web frameworks such as Django, Flask, or Spring Boot. 4. Understand RESTful API design principles. 5. Have experience with database management systems like PostgreSQL or MySQL. 6. Be comfortable working with cloud platforms...
I am in need of a skilled professional, capable of reorganizing my database of approximately 1,000 customers. To be specific: - The Excel database contains the following data field: Name, Email, Phone number, Address, City, and Country. - The organization should be done alphabetically by name. - The new Excel template format should have each field in a separate column. For this job, it'll be ideal if you possess exceptional Excel and data organization skills and have prior experience in Database Management. Efficiency in Excel, coupled with keen attention to detail, will aid in the successful completion of this task. Anyone with a seasoned approach to the task will be greatly appreciated.
I'm seeking a freelancer who can develop an automated system in Excel to manage backorders. This system must create new data for efficient backorder handling. Specific requirements include: • Creation of an automation tool that handles numeric values, text strings, and dates and times. • The system should adequately track product lead times and inventory levels, despite not automatically generating reports. Please note, having prior experience in backorder management and Excel automation will be advantageous for this project. The ideal freelancer should have strong data handling capabilities and excellent knowledge of Excel. Proven experience in similar projects is preferred.
...photographers under me. My current solution for managing workflow (job status, assigning photographers, accounting for payouts) is done through Google Sheets. I'd like to explore the potential of Airtable (and possibly other platforms) as a replacement. Objective 1 Consolidated Spreadsheet/Database. I currently use a spreadsheet (Google Sheets) for each photographer when assigning jobs. This requires excessive data movement and tracking. If feasible, I'd like to construct a spreadsheet/database where all the data is consolidated. Access by users (photographers) will be confined to the jobs they are assigned. Ideally, a more centralized and manageable solution can be put in place for assigning, tracking, and making payments on jobs. Obj...
I need an experienced freelancer to create a chart with interest rates in Canada for every month between January 2015 and the current month. K...between January 2015 and the current month. Key Requirements: - The chart should accurately reflect the fluctuation in interest rates over the specified time period. - The format must be an excel which is easy to read and interpret. - No additional analytics features such as trend lines or forecasts are necessary, the primary focus is to clearly display interest rates by month. Ideal Skills: - Research historical interest rates in canada - Proficient in Excel and creating line graphs. - Strong understanding of financial data, specifically interest rates. - Eye for detail and ability to ensure the data is clearly pr...
I need an experienced freelancer who can convert Excel data to 2D DWG files on an urgent basis. Key Requirements: - Utilize the Excel data to create 2D contour plots, specifically representing the height distribution on a bridge surface and the riverbed levels. - Create these contour plots in a DWG format. - Accuracy and precision are crucial for this project. Ideal Skills and Experience: - Proficiency in AutoCAD for DWG creation. - Prior experience with data visualization from Excel. - Immediate availability to start and complete the project as soon as possible. Please include any relevant portfolio items or examples of similar projects you've done in the past. I am looking for a quick turnaround without compromising on quality.
I need someone to add a total of 50 bookmarks to my Word document. Essential Requirements: - Add 50 bookmarks to the document - create a excel; audit xls with 50 rows listing the bookmark name and the section text name (we use that as quality control and testing)
I'm seeking a proficient freelancer who can handle all aspects of setting up, running, and ensuring the success of my Shopify dropshipping account. My business focuses on a specific nich...SEO: I prefer to attract customers to my store through organic SEO strategies. Practical knowledge of SEO tools and techniques is a must. 3. Social Media Proficiency: In addition to SEO, I'd like to integrate targeted advertising on Facebook and Instagram into my marketing strategy. Ideally, the freelancer should have a track record of optimizing Shopify stores for effective dropshipping. To excel in this task, the freelancer should possess excellent SEO skills, social media advertising knowledge, and a clear understanding of dropshipping mechanics. Your bids should reflect your compet...
I'm looking for an expert with exceptional skills in Microsoft Access/Database, Excel, and VBA coding. The main focus of the project is on Access/Database, the specific tasks include: - Data Entry - Query Building - Database Design Ideally, I need someone who can efficiently handle a database containing 10-20 tables. You should be detail-oriented, experienced in managing medium-sized databases, and proficient in maximizing the functionality of Access. Excel expertise and VBA coding skills will also be highly valuable in this project. ONLY ACCEPT TASK IF YOU CAN DELIVER WITHIN 3 HOURS
...unfortunately that company no longer exists. Fortunately - we have some imaging and data to provide that can help point you in the right direction. This tool will essentially serve as a centralized hub for tracking sales data, generating custom reports, and integrating with our existing CRM and PayRoll management software. The main features I need include real-time sales data updates during business hours, customizable executive reports, and seamless integration with our CRM system. We have an open API so that you can investigate what data is available. Key requirements: - Developing an API Salesboard tool with a user-friendly interface and robust functionalities. - Ensuring real-time updates on sales data during business hours in 20 minute int...
I'm looking for a proficient person that can go into links and write emails and phone numbers. There are 15,000 Rec...I need all records completed real time from a file on google drive. Must be complete with 24 hours Currently, I'm using Excel spreadsheets, which is proving inefficient. I require an effective solution to input data and offer functionality that makes the information more accessible. Your Tasks: Go into profile and extract email, phone number , link in the bio and also any nics in the bio Required Skills and Experience: - Understanding of search functionalities - Data Entry - Knowledge in data export would be a plus. You should have a strong track record of creating functional, efficient databases and exhibit a keen eye for det...
I'm in need of an experienced data analyst who can help me merge and clean up my Excel database. - Database Type: It is an Excel database that's in need of expert merging and clean-up. - Number of Files: The project revolves around a single Excel file with 4 sheets - Data Type: The data in question falls under the category of customer data. We have exported 4 databases from all our software. Basically we want all the duplicates to be deleted and the final file to be clean and able to be uploaded to mailchimp
I am seeking a proficient web scraper to extract specific data from The data I need includes venue details and contact information. I require the end product to be delivered as a well-organised Excel file. Key aspects to focus on: * Meticulous detail on venue data * Comprehensive contact information * High level data formatting skills The ideal candidate has demonstrated experience in web scraping, data management and Excel. A background in music or event-based data is a plus. Efficiency, precision and respect for the source website's terms of service are crucial for this project.
I’m in need of an Excel specialist who is adept at enhancing operational efficiency through the automation of repetitive tasks, namely the creation of reports utilizing sales and operational data. Key Requirements: - Creating a system for report generation on Excel, extracting key insights from extensive datasets. - Reports should conveniently display revenue, profit margins, sales growth, as well as production metrics and efficiency metrics. Ideal skills: - Proficiency in Excel and data analysis - Experience with big data and automating report generation - Strong attention to detail and the ability to make data actionable.
...utilizing their expertise in researching, content writing, and data entry to deliver high-quality results. Responsibilities: Conduct thorough research to identify and compile a targeted list of individuals in America relevant to our business objectives. Utilize various online resources, databases, and tools to gather accurate and up-to-date information. Organize and maintain the collected data in a structured format, ensuring accuracy and completeness. Collaborate closely with our team to understand specific criteria and requirements for the list. Requirements: Proven experience in researching, content writing, and data entry, preferably in a business or professional setting. Excellent attention to detail and accuracy in data collection and entry. Strong or...
...seeking a dedicated property manager. This position will be part-time or full-time. Responsibilities: •Gathering data from one source (Google Drive) to enter into document management (databases or partner websites by case) • Checking and reviewing documents for accuracy and completion • Attaching supporting files to the document management • Searching for additional information for documents that are incomplete • Verifying, correct, and delete unnecessary data, or combine data The requirements for the applicant include strong attention to details, college degree, access to email and knowledge of use a device (computer or phone), basic software tools (Microsoft Office - Word & Excel). We need fast, accurate and specialized mem...
...interactive dashboard that will help track and analyze market data more efficiently. It is important that the dashboard connects to Excel spreadsheets and other Power BI resources to provide an all-round perspective of the metrics. Ideal skills and experience: - Proficient in Power BI - Excellent knowledge of Excel - Deep understanding of retail market data analysis - Excellent in crunching and interpreting numbers - Strong attention to detail Responsibilities: - Gather and interpret market data - Create a user-friendly and highly interactive dashboard - Connect the dashboard to Excel spreadsheets and Power BI resources - Regularly update the dashboard with relevant market data - Identify trends and patterns based on the data p...
