Converting dat file excelJobs

The goal of this project is to significantly speed up an already existing data import script (see ). The steps needed to import the data consist of: - Setup the necessary tables for the import to work (I already provide you with the postgres init script, see ) - Downloading/fetching the large ±24GB .JSONL data dump - Importing and converting this single .JSONL-dump into two postgres tables running in a docker container Requirements: - The resulting tables should be exactly the same as when you run the original import script. - The import time should be significantly reduced compared to the import time of the original import script using the same hardware requirements. - It should be easy to run everything: clearly document how to run it How you achieve this is completely

I have an Excel workbook with 7 source sheets and 1 LV (Landing View) sheet. The task is to automatically consolidate data from the 7 sheets into the Main sheet using either Excel formulas or Power Query (VBA and Macros are strictly off-limits). Requirements: - The solution needs to be dynamic, updating the LV sheet in real time as data in the 7 source sheets changes. Deliverables: - A fully functional Excel file where the LV sheet updates in real-time based on data from the 7 sheets. - Clear documentation, or a short instructional guide, explaining how the solution works. Ideally, the freelancer will have strong Excel skills, expertise in using Power Query, and a good understanding of data mapping. Experience with creating dynamic Excel solu...

El objetivo principal del Dashboard es monitorear el avance y control de la etapa de preparación de diversas obras públicas, incluyendo el seguimiento de entregables, plazos, presupuesto, riesgos y adquisición de recursos, todo ello en EXCEL. El Dashboard es clave para controlar los avances de múltiples obras, asegurando que el presupuesto no se exceda, que los plazos se respeten y que los recursos (personales y materiales) estén disponibles a tiempo. La toma de decisiones debe ser ágil y basada en datos claros, por lo que los indicadores y las alertas deben estar configurados para resaltar cualquier problema (retrasos, sobrecostos, falta de recursos). Cuento con el alcance y datos claves que deberia tener el dashboard. Contactarme al +*5*1...

Scrape agent's full name, company, mobile number, and suburb from the provided RealCommercial link. Store the data in a structured spreadsheet format. Remove duplicate entries to ensure clean data. Deliver the final CSV or Excel file.

I am seeking a seasoned Google Ad expert to manage my campaigns. The main goal is to generate valuable leads - specifically, contact form submissions. Ideal skills and experience: - Proven experience in Google Ads management - Focus on lead generation - Expertise in converting leads to contact form submissions - Excellent understanding of digital marketing strategies While there's no immediate deadline for this project, I am looking for quality work that can consistently deliver results over time. Your task will be to optimize ad performance and lead conversion rates for my Tallahassee Kitchen website.

...Scientific research labs • Medical and clinical labs • School/educational labs • Governmental labs • Food testing labs • HPLC labs • Cytogenetics labs • Industrial labs Data Requirements: Each laboratory entry must include the following: 1. Laboratory Name 2. Address 3. Telephone Number 4. Email Address (mandatory) 5. Website (if available) Project Deliverables: • A spreadsheet (Excel, Google Sheets, or CSV format) containing at least 1,500 unique laboratory contacts. • Each row should represent one laboratory, with columns for the required data points above. Important Details: • Labs from Mexico or Brazil will NOT be accepted. Please do not include any contacts from those countries. • All data must be acc...

I need assistance in exporting questions, answers, and explanations from a ChatGPT report into an Excel document. The data consists of 400 items formatted as text paragraphs in the report. Please see example link below: If you open the file above, you will see there are 400 questions organised into: 1) questions 2) correct answer 3) Explanations When you try to ask ChatGPT to export all data into an excel document it doesn't do this properly. It only gives a sample of the questions. I want a freelancer to find a way so that you can instruct ChatGPT to properly export all data so it matches what is produced from before. We have over 100+ documents with each document containing 400+ questions. If you can do it for 1 correctly

I'm looking for a freelancer who can set up an automated process that transfers my inventory details from QuickBooks Desktop to an Excel sheet on a daily basis. Key Requirements: - Data Transfer: The project entails transferring inventory details from QuickBooks to an Excel sheet on a daily basis. - Data Processing: After the data is transferred, I need it to be summarized in the Excel sheet. Ideal Skills: - Proficiency in QuickBooks Desktop - Advanced Excel skills - Experience with data automation Please ensure you have the relevant experience and skills before bidding. I look forward to your proposals.

I'm seeking a proficient accountant with strong financial analysis skills and expertise in Microsoft Excel. Key Responsibilities: - Conduct comprehensive financial analysis - Manage accounts payable and receivable Ideal Skills: - Proficient in Microsoft Excel - Strong financial analysis capabilities - Experienced in managing accounts payable/receivable

...a tailored Excel template to streamline my work checks. Currently, I have to manually copy and paste complicated formulas and use text replace functions to substitute keywords like LESS and PLUS with their mathematical counterparts. For examples sake, I want to put in "(25%LESS1/8LESS1/16 of 7/8) of 1/2 of 1/2 of 8/8" in A1, and have a Cell then automatically output that info. I have used substitute functions, then did evaluate formulas, but doesn't turn out right. Key Responsibilities: - Develop an Excel template that can process long form mathematical expressions and return values automatically, saving me the tedious work. - Ensure the template can handle mixed operations including addition, subtraction, multiplication, and division. Ideal Skills: - St...

I'm in search of a proficient Excel specialist to assist with various tasks related to public data and knows how to do formulas ! . Your primary responsibilities will include: - Data Entry: Accurately inputting information into Excel sheets. - Data Analysis: Utilizing Excel's powerful tools to make sense of the data, organize it and seperate it - Report Generation: Creating comprehensive reports based on the data analysis. Key skills and experience required for the job include: - Proficiency in Excel, with a particular focus on data entry, analysis and report generation. - Experience working with public data. - Expertise in generating charts and applying formulas.

Woork Scoop I need to update only some text an HTML template file through a plugin's admin page. The update primarily involves adding some new text content to the main section of the html template. Some area and text in the html template file have to be untouched or locked for updating due to functionality. Plugin : The admin plugin page is already created , this HTML approach is an aditional functionality to the page. The html file is located in the wordpress plugin folder structure. This html file is connected to the dompdf library function to attach a pdf file to customer mail when order is completed. Ideal Skills: - Proficiency in HTML - Experience with WordPress plugins - Attention to detail for content placement - Experience in PHP ...

I'm looking for an Excel expert to help me create a comprehensive spreadsheet for an educational charity. Key Responsibilities: - The main purpose of the Excel Spreadsheet will be to compare various metrics of specific areas (London Boroughs) within the Region. - We need to compare a variety of metrics. The specific metrics will be populated later, but they could include population statistics, crime rates, and educational outcomes. - The level of detail in the comparison needs to cater for both high-level overviews and detailed analyses. Ideal Skills and Experience: - Proficiency in Excel is a must, with experience in data analysis and spreadsheet creation. - Understanding of educational metrics and social statistics would be a plus. - Ability to create user-f...

I have an old and heavy Excel sheet that often lags. I need an updated, optimized, and improved version without any errors. My primary use for this Excel sheet is data analysis. Specifically, I use it for: - Statistical analysis - Data visualization - Using pivot tables The sheet typically handles more than 100,000 rows of data. Ideal skills for the job include: - Advanced expertise in Excel - Experience with data analysis - Skills in optimizing Excel sheets for heavy data usage - Proficiency in creating error-free and efficient spreadsheets Please note, I need this task completed as soon as possible.

I'm looking for an Excel expert who can help me automate my spreadsheets to reduce manual data entry, specifically dealing with financial data. The ideal freelancer for this job should have extensive experience in Excel, particularly in spreadsheet automation. Skills in handling financial data and creating efficient solutions to streamline processes are a plus. Please include your relevant experience in your bid.

...Responsibilities: - Implement and integrate Zoho CRM, Zoho Books, and Zoho Projects into our operations via Zoho One. - Ensure the systems work seamlessly together to enhance efficiency and productivity. - Facilitate improved tracking and reporting of our financials through Zoho Books. - Optimize our project management processes through Zoho Projects. Data Migration: - I have existing data from excel on customers and past histrorical data that needs to be migrated from another accounting software to Zoho Books. This includes financial records, customer data, and project history. Ideal Skills: - Proven experience in Zoho One implementation and integration. - Proficiency in Zoho CRM, Zoho Books, and Zoho Projects. - Strong understanding of financial tracking and reporting. - Exp...

I'm looking for an experienced data analyst who excels in working with Excel spreadsheets. Your primary tasks will involve: - Data entry and formatting: I have a substantial amount of data that needs to be inputted and formatted correctly in Excel. - Data analysis: Once the data is properly formatted, you'll be responsible for analyzing it in Excel. The ideal candidate will have: - Proficiency in Excel, including advanced functions and formulas - Strong skills in statistical analysis - Attention to detail to ensure data accuracy - Ability to meet deadlines If you're up for the challenge, I'd love to hear from you!

I need a straightforward Excel sheet that helps me calculate my monthly expenses. I want to be able to input daily amounts and have them total automatically. Expenses to Track: - Material - Invoices - Tools - Gas - Other - W9 - Cash - Cows Key Requirements: - The Excel sheet should be organized for daily entries with a monthly total - No charts or visual aids are required, just a simple, functional design Ideal skills for this project include: - Proficiency in Excel - Experience in creating user-friendly spreadsheets - Ability to understand and cater to specific data tracking needs

I'm in need of an auth...The role includes using applications like Klaviyo and Vitals, running marketing campaigns, sending automated emails, and conducting specific campaigns. Additionally, I need help with stock revision and control. The primary goal of these marketing campaigns is to increase sales. Currently, I'm using email marketing as the main platform, targeting primarily new subscribers, but with a focus on converting them into loyal customers. Ideal Skills: - Proven experience with Shopify - Proficiency in Klaviyo and Vitals - Strong sales and marketing background - Excellent stock management skills - Skilled in creating engaging email content for new subscribers Ultimately, I'm looking for someone who can help me boost my sales through effective use of t...

I'm looking for a professional to apply on my behalf to various job platforms like Indeed, LinkedIn and Glassdoor. Apply For The following 1. software developer 2. desktop support analyst 3. programmer analyst Ideal skills for the job:...Indeed, LinkedIn and Glassdoor. Apply For The following 1. software developer 2. desktop support analyst 3. programmer analyst Ideal skills for the job: - The roles should be mid level or senior-level with a salary of 70K or more - I'm only interested in jobs located in Orange County or LA County in California. - You will need to send my resume to each application. - I expect a comprehensive excel list of all applications made. Please note that the applications should be tailored to each platform and role, showcasing my relevant ski...

I need expert assistance to set up and manage my MySQL database on a Windows server. Specific Tasks: - I have MySQL installed. I have several very large files I want to import, but MySQL is telling me they are to large - Database Optimization: Once imported I want the database set u...a Windows server. Specific Tasks: - I have MySQL installed. I have several very large files I want to import, but MySQL is telling me they are to large - Database Optimization: Once imported I want the database set up in a certain way - Generally need advice on how to update the database - Report generation: I need specific reports generated . I'm not sure the best tool to do this but maybe excel? I'd like to form an ongoing relationship with an expert to help me develop the database an...

I'm seeking an experienced data engineer for a project focused on building and managing a data warehouse using Amazon Redshift. Key Responsibilities: - Design and implement a comprehensive data warehouse on Amazon R...data warehouse on Amazon Redshift. - Work on optimizing the performance of the warehouse. - Able to potentially integrate various data sources in the future. Ideal Skills: - Proficient in Amazon Redshift. - Strong background in data warehousing concepts. - Experience with performance tuning of data warehouses. - Knowledge of various data source types (Relational databases, NoSQL databases, CSV/Excel files). Please note that the integration of diverse data sources is a potential future requirement, so having the skills and experience to handle this would be hig...

...(Delhi, Mumbai, Bangalore, Chennai, Hyderabad) Landing Page: Requirements & Deliverables: Database & Email List Management: Procuring/validating an opt-in business email list for targeted outreach. Ensuring high deliverability rates and avoiding spam filters. Email Campaign Execution: Crafting compelling email copies with strong CTAs. Designing high-converting email templates. A/B Testing for subject lines, email content, and layouts. Managing bulk email sending infrastructure for maximum inbox reach. Lead Generation & Qualification: Defining a lead as a business expressing interest via email reply, form submission, or scheduled demo. Ensuring lead quality with verified business contacts. Passing leads directly to our CRM or designated contact point

Take screenshot of websites and compress the file and send Total 116 sites Use screely web extenstion Example attached

I am facing permission issues on my Ubuntu Linux system, specifically concerning access to files in my home directory. I need assistance in gaining Read/Write access to certain files and changing ownership of some files. Ideal skills for this task include: - Proficiency in Ubuntu Linux - Experience with file permission management - Ability to change file ownership Please bid if you have the necessary skills and experience. Thank you.

I need assistance with combining 1-2 Excel documents for the purpose of archiving. Ideal Skills and Experience: - Proficiency in Excel - Attention to detail - Data management skills

I need a comprehensive Excel-based ERP application that focuses primarily on Financial Management. This mini-ERP should help me manage my processes, see projections, and calculate finances seamlessly. Key features of this Excel Dashboard should include: - Real-time tracking of income, expenses, and cash flow. - Advanced income and expense categorization and tracking (e.g., specific projects, departments). - Trend analysis and forecasting capabilities. - Automatic bank reconciliation with accounting records. I require a professional who has: - Proficient Excel skills and experience in creating ERP applications. - Strong understanding of financial management principles. - Ability to incorporate advanced tracking and forecasting features. Please note, while Financial ...

Buscamos un par freelancers para la creación de una base de datos de clientes potenciales. El trabajo consiste en: Extraer información de clientes desde una plataforma específica. Investigar y encontrar el correo de la persona de contacto. Si no se encuentra el correo de la persona, buscar el correo general de la empresa. Organizar la información en un Excel compartido Se paga €2 a €3 la hora. Y se requiere poder empezar directamente.

I need a comprehensive HTML help file for our bespoke software application. It should include a complete description of the code and its workings, detailed on a function-by-function basis. Ideal skills: - Proficient in HTML - Experience with technical writing and creating in-depth help files - An understanding of software code and the ability to explain it in an accessible way

...proficient Excel macro developer who can automate a series of tasks for me. The primary objectives include: - Data Cleaning: Streamlining and organizing data to enhance its quality and usability. - Report Generation: Automating the process of report creation to save time and effort. - Complex Calculations: Building macros to perform intricate computations seamlessly. The macros will primarily interact with Excel files and Databases. As for triggering the macros, I would like to initiate them manually. Ideal skills and experience for this job: - Strong proficiency in Excel and VBA (Visual Basic for Applications). - Prior experience in developing macros for data cleaning, report generation and complex calculations. - Familiarity with databases and ability to integ...

...skills. Good presentation skills and comfortable with providing product demonstrations and pitching sales proposals to clients and partners. Strong organizational and time management skills, and ability to work under pressure and tight deadlines. Responsible for generating own leads through online research, email campaigns and industry specific events. Identifying requirements of business sectors, converting leads into wins. Building solid relationships with a wide variety of clients. Building a robust pipeline leveraging pertinent industry connections. Overseeing and directing complex, long-term sales negotiations. Ideal Candidate: - Extensive B2B sales experience - Preferably with a background in the trading industry - Competent in navigating complex technical sales Your rol...

I'm in need of a detailed Excel sheet for my company, specifically for the Operations department. This sheet should include various registers and time sheets, all interlinked with formulas for seamless data flow. Key Components: - Invoice Register - Expense Register - Salary Register - Employee Time Sheet - Invoice Incoming - Invoice Outgoing - Outgoing Purchase Order - Purchase Order Incoming (Sales Order) - Apex and Opex Register - Asset List - Billing Forecast - Expense Forecast - Hire Employee List and Salary Register - Payroll Master and ESOB Calculator and Register The project also requires the creation of a single dashboard. The main purpose of this dashboard is to track the financial performance of the company. It should prominently display: - Total revenue and exp...

I'm looking for a skilled Excel VBA developer. I need a worksheet modification that will control data entry into cell H8 based on the status of cell D8, and enforce data type constraints. Requirements: - If cell D8 is BLANK: Allow user to enter data into cell H8. - If cell D8 IS NOT BLANK: Populate cell H8 with data from cell H12 and lock the cell from user changes. - Implement numeric-only validation for cell H8. Additional Information: - Cells D8, H8, H12 are unlocked and the sheet is password protected. - The functionality should persist for future users, even after data row 8 has been saved and cleared by an existing VBA script. Ideal skills include: - Proficiency in Excel and VBA - Experience with implementing data validation and conditional cell behavior - Under...

I need a freelancer who can help me to create a bill from an Excel sheet and convert it into both an Excel file and a PDF. Ideal skills and experience for the job: - Proficiency with Excel - Experience with creating bills - Knowledge of PDF conversion - Attention to detail - Ability to meet deadlines

Hello! I just need simple excel sheet work in under 5 hours!

Create an excel file, with macros and forms (VBA development) to facilitate the folow up of work

UK Furniture retail website is in need of a seasoned marketing professional to spearhead a comprehensive PPC and Socail Media campaign, with a keen focus on Google Ads. Main Objectives: - Primarily, the campaign's goal is to generate leads or sales. Hence, your expertise in converting clicks into customers will be pivotal. - SEO, Social Media, and Location-Specific campaigns will be secondary but equally important. A well-rounded marketing strategy encompassing these channels will fortify our online presence. - An understanding of the furniture retail sector will be an added advantage. Ideal Skills and Experience: - Proven track record in managing successful PPC campaigns, particularly on Google Ads. - Strong understanding of SEO and Social Media marketing. - Able to create ...

I'm seeking an Advanced Excel professional capable of creating comparative analysis charts and graphs for financial data, specifically comparing work progress. Key Requirements: - Remote work capability - Expertise in Excel chart/graph creation - Experience with financial data - Strong understanding of comparative analysis - Excellent ability to visualize complex data Ideal Skills: - Advanced Excel skills - Financial analysis experience - Data visualization expertise - Strong attention to detail - Excellent communication skills for remote work

...trainers, and management for effective collaboration and follow-ups. OneDrive Integration: Integrate OneDrive with Odoo to facilitate document sharing and cloud storage for contracts, project reports, training content, and more. Allow users to upload, access, and manage files directly within Odoo through the OneDrive interface. 22-Direct Collaboration Tools: Use Microsoft Office tools such as Word, Excel, and PowerPoint to manage documents and integrate them with Odoo for easy document generation. Ensure seamless synchronization between Odoo and Microsoft Office applications to improve productivity. Staffing and Organizational Structure: We operate with three main departments: Sales: Manages client acquisition and sales operations. Operations: Handles day-to-day consulting and se...

I'm seeking someone to help me create a data web scraping from different car-selling websites. I need to get the prices of the cars during the time (create a timeline) of prices and characteristics of the vehicles. Getting the data from those websites, for example: You can export the data to Excel or PDF format if you like. I need the prices of the cars and their characteristics. Ideal skills for this job would include: - Proficiency in web scraping tools and programming languages like Python, BeautifulSoup or Scrapy - Experience with data extraction from eCommerce or product websites - Ability to deliver clean, structured data Please ensure you can commit to delivering this project promptly and efficiently

I'm looking for a skilled frontend developer with expertise in Microsoft Excel. The primary task will involve creating a frontend that interacts with Excel for report generation. Ideal Skills: - Proficient in frontend development - Extensive experience with Microsoft Excel - Strong understanding of report generation processes in Excel Please note, the specific data types for the reports and the frontend framework have not been predetermined, so flexibility and adaptability are key. I look forward to your bids.

I need an experienced Excel expert to rewrite my complex, formula-heavy and macro-utilizing XLSX file for use on a Mac M3 Sequoia. This project involves ensuring the formulas remain unlocked and adding filters to the spreadsheet. Key Tasks: - Convert the current XLSX file for compatibility with Mac - Ensure all complex formulas and macros are functional and unlocked - Implement filters into the file - Add Pivot tables as per the original file - Apply basic styles and colors for customized formatting Ideal Skills: - Extensive experience with Excel and XLSX files - Proficiency in creating and modifying Pivot tables - Strong understanding of basic Excel formatting - Familiar with Mac M3 Sequoia compatibility issues - Able to unlock formulas a...

I'm looking for a Power BI expert to analyze my sales data for me. The data is stored across Excel files and Cloud storage, so familiarity with these sources is crucial. Your tasks will include: - Importing and cleaning the data from Excel and Cloud storage - Conducting in-depth analysis to uncover sales trends and insights - Visualizing data in a clear and engaging way Skills and experience ideal for this job: - Expertise in Power BI - Strong data analysis skills - Experience working with sales data - Proficiency in using Excel and accessing Cloud storage - Ability to present data in a clear and engaging manner

I am seeking a diligent and detail-oriented data entry professional from India to assist with online form filling, handling customer information and creating financial reports in Excel. Specific Tasks: - Online form filling - Working with customer information in Excel - Creating financial reports Ideal skills and experience for the job include: - Proficiency in Excel - Experience with online form filling - Previous work with customer information - Ability to create financial reports - Strong attention to detail and accuracy

We are looking for an experienced and motivated Sales Agent to join our team and manage hot leads, so potential customers who are already interested and ready to join. Your role will be to assist them with any final questions, guide them through the joining process, and help them choose the best package for their needs. Responsibilities: - Engage with inco...efficiently. - A customer-focused attitude with a problem-solving mindset. What We Offer: - High conversion potential—no cold calling, just hot leads! - Flexible working hours. - Competitive commission structure. - Long-term collaboration for the right candidate. If you have a passion for sales and enjoy helping customers make informed decisions, we’d love to hear from you! Apply now and start converting leads i...

I'm in need of a detail-oriented support secretary to assist with my weekly Excel report for our various mining exploration projects. The tasks involve basic data analysis and project management. Key Responsibilities: - Data Entry: Accurately inputting project data into the report. - Financial Tracking: Keeping tabs on project budgets and expenditures. - Performance Metrics: Monitoring and recording project performance indicators. Ideal Candidate: - Proficient in Excel with experience in data analysis and project management. - Some familiarity with mining industry terminology. - Excellent attention to detail and good with numbers. Bonus: - Previous experience in mining projects. The task should take around 3-4 hours each week, with the report needing to be complete...

I need my current HTML portfolio website converted to WordPress. The new site must match the existing design and layout exactly, preserving every detail of the original. Ideal Skills and Experience: - Proficient in HTML and WordPress - Strong attention to detail - Experience with website design replication - Understanding of WordPress themes and plugins. We request the service of converting our current HTML website to WordPress, maintaining the exact features and design of Below are the specific requirements: Design and User Experience (UX) Identical Design: The layout and aesthetics must be faithfully replicated from the current website. Drag and Drop Theme: Preferably free, fast, and equipped with visual editing tools to simplify internal management. Responsive

I'm looking for a skilled frontend developer with expertise in Microsoft Excel. The primary task will involve creating a frontend that interacts with Excel for report generation. Ideal Skills: - Proficient in frontend development - Extensive experience with Microsoft Excel - Strong understanding of report generation processes in Excel Please note, the specific data types for the reports and the frontend framework have not been predetermined, so flexibility and adaptability are key. I look forward to your bids.

I'm looking for a skilled frontend developer with expertise in Microsoft Excel. The primary task will involve creating a frontend that interacts with Excel for report generation. Ideal Skills: - Proficient in frontend development - Extensive experience with Microsoft Excel - Strong understanding of report generation processes in Excel Please note, the specific data types for the reports and the frontend framework have not been predetermined, so flexibility and adaptability are key. I look forward to your bids.

I'm looking for a talented developer to create a custom Windows program that can correct postal codes for a ...capabilities. Key Requirements: - The program should access addresses and postal codes for all countries. - It should be able to find and replace incorrect or misspelled postal codes based on provided addresses. - The input will be an Excel file containing customer data, including name, address, postal code, phone number, and email. - The program should output a corrected version of the input file. Ideal Skills: - Proficient in Windows program development. - Experienced in creating GUI and CLI. - Familiar with API integration. - Knowledgeable in handling Excel files in programming. Please note, I'm open to proposals for implementing this ...