Find Jobs
Hire Freelancers

Match Excel Sheets data and import into MySQL + create website(Wordpress if possible) power-search mask for that data

€250-750 EUR

Cancelled
Posted almost 4 years ago

€250-750 EUR

Paid on delivery
PLEASE READ CAREFULLY DONT SEND AUTO BIDDINGS My Problem: - I have several, different big sized excel sheets (8-10) different with many data entries.(nearly 700mb total, 700k-1mio lines, 80 columns each) - When I load the excel sheets or/and do any change, filtering and sorting of data it takes a lot of loading time - i need a better visualisation of the data (maybe Wordpress, Tableau, Qklik, GoogleTables) accesible for other persons too (by www, therefore i would like to integrate into my WP site), considering own methodology/algorythms Steps to do: 1. excel sheets must be merged (also some existing duplicates should be deleted) 2. excel sheets must be matched (some excel contain data that needs to be merged into existing lines of other excels) , for example one excel has in one line organization name "LA Lakers", other excel has country and associtation title for this organization, like "USA", "NBA". 3. I need all that merged and matched data then in a database (pref. MYSQL) where i can put all data mentioned above together at one place 4. some logics/algorythms have to build from the existing data...there is for example 40 attribues of sports statistics, but for some "roles" some attributes are not relevant, some are more some important some are less, also in step 5. important to highlight them... 5. visualisation: a powerful search mask that can be executed by anyone, filtering sortering by all lines, fields, columns in the database, output in nice-looking table within an existing website (algorythms mentioned in 4. must be considered) Only bidders that put the codeword "NONSENSE" in first line of bid, will be considered. Pref. to be inserted into Wordpress, if not we will need to create an own site and i will link my WP to this site later on, as plan b this would work to
Project ID: 24755033

About the project

31 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
31 freelancers are bidding on average €518 EUR for this job
User Avatar
NONSENSE Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
€500 EUR in 7 days
4.9 (413 reviews)
8.2
8.2
User Avatar
Nonsense Hello. Wordpress development expert ready to help you with data importing. . I have more 500 good reviews and more 10 years of development experience behind. Best quality and timeframe. Tnx, and hope to hear you soon.
€500 EUR in 7 days
4.9 (574 reviews)
8.0
8.0
User Avatar
NONSENSE, I can assist you with giagentic excel sheet and them merging them. Also will improve load speed when you execute search query as well. I have worked with Dbs with data in around Terabytes. Please respond and ill list down execution plan and provide you some more details. how we can integrate this new module with wordpress. Thank you for your consideration. Asad Sajjad
€550 EUR in 15 days
4.9 (27 reviews)
6.4
6.4
User Avatar
Hi, I have read the brief details on the job listing. I am a full stack developer with 9 years of coding experience. I have worked with multiple similar jobs before. I have completed 150+ major projects just on this website in last 5 years. Apart from that I have a good team of developers for doing web based jobs of any kind. You can check my portfolio here: https://www.freelancer.com/u/AwaisChaudhry?w=f I believe I can do this job. Lets discuss ! Awais
€750 EUR in 10 days
5.0 (8 reviews)
5.7
5.7
User Avatar
NONSENSE Hi there! I'm an experienced software developer (+10 years) My suggestion is to develop a website using some specialized controls ( like Devexpress) on top of a MSSQL Server. I have the required skills for all the required steps for this project. Best Regards
€611 EUR in 15 days
5.0 (26 reviews)
5.8
5.8
User Avatar
Hi , I have read your project description carefully and i understand that you need a professional wordpress developer. I am an experienced wordpress developer having 6 years of Designing & Development experience. I can develop website and wordpress plugins that can extend your website functionality.. I am Good at Excel, Data Processing, Database Administration, WordPress and Editing.... Please send me a message so that we can discuss more about this project...
€555 EUR in 6 days
5.0 (23 reviews)
5.1
5.1
User Avatar
Hello, NONSENSE : )) I carefully read the description of your project. What can I tell you first of all, you are doomed to failure if you expect great performance from the site and the database, which will be formed after the cleaning, merging, and other processes specified in the task. Yes, merging sheets, cleaning duplicates, etc. will reduce the amount of data in the database, but it will be not small any case, and the multi-attributes (40 fields) will be slower than expected during a search. Although in this regard a lot depends on database planning. It will be a mistake to think that if all the data will be together in one table, then the database will become more mobile. Alas, not so. Attributes should be distributed in different tables grouping them by their types (string, date, numeric) linking tables with a references. This is my daily work and this is my specialty. I can do this work. I am also ready to give some tips on what I wrote above, which will help you in choosing the right solution to the problem.
€500 EUR in 20 days
5.0 (18 reviews)
4.9
4.9
User Avatar
Hello there, Expert here, Sir i have read your description i'm very confident about your project i provide you quality work on time Can you please come to the chat box so we can easily discuss about project details. Thank You
€560 EUR in 5 days
5.0 (8 reviews)
4.5
4.5
User Avatar
Hi sir, I've extensive experience ready to start work when you ping me. I'll see the details of the project its easy work for me. I'll do the work that will be absolutely perfect and sound which can able to make you 100% satisfy with my work. Please full free ask and any query necessary. Thank you.
€400 EUR in 4 days
4.9 (11 reviews)
4.2
4.2
User Avatar
NONSENSE Hello!! Am very interested in ur project and I'm an expert in PDF/Word/Excel/Excel Marcos/VBA/Visual basic/Copy typing/Data Entry/Data processing and would like to help you with your project. Please ping me for further discussion.
€250 EUR in 2 days
5.0 (22 reviews)
4.0
4.0
User Avatar
codeword "NONSENSE" Hello, We have read your project about Match Excel Sheets data and import into MySQL + create website(Wordpress if possible) power-search mask for that data. We can surely do it because we have experience in all the relevant skills required for this project i.e. Data Processing Excel WordPress Editing Database Administration We can give you great design and Free SEO tips. We carry rich experience in building over 500+ websites. PM me for more details so that we can start work immediately. About us We are experts in WordPress, Core PHP, Codeigniter Programming, HTML, CSS, Bootstrap, Laravel, JavaScript, JQuery, Angular Js ,Node Js technologies, Software Architecture and Software Development. Project milestone 1:- Prototype Project milestone 2 :- Back-end Project milestone 3:- Testing Project milestone 4:- Deployment Thanks SJ
€450 EUR in 3 days
4.8 (8 reviews)
3.9
3.9
User Avatar
Hi, Thanks for sharing your requirements here. I’m an Experienced Freelancer with a demonstrated history of working in the internet industry. Skilled in Core PHP, MySQL, HTML, CSS, JQuery, JavaScript. I have worked many PHP related CMS like.. Wordpress, Laravel, CI, Typo3, Magento, Prestashop, OXID eSales, Modified Shop CMS, xtCommerce, OpenCart. I have also created some good extensions in Typo3 and Magento. Let's get connected and can take this further. Awaiting your reply, Thanks & Regards, Urvisha Nayee.
€450 EUR in 20 days
5.0 (2 reviews)
3.4
3.4
User Avatar
NONSENSE Hi there, I read and understood your requirements that you want to develop a dashboard using data from multiple large excel files. I am very good at ETL process using excel and data visualization and I am confident that I can deliver your project to your satisfaction. Let us connect and discuss this further to take it forward. The bid may change upon a clear understanding and complexity of the project.
€1,000 EUR in 20 days
5.0 (1 review)
3.0
3.0
User Avatar
Hello! I read and understand your project description. I am very interested to build your website. I am a Full Stack Developer with 5+ years of working experience as a WordPress developer. I can make a sure beautiful, responsive and user-friendly website. I can start your project right now and I am available 40+ hours a week. And I can work on your timezone. Let's discuss more in details. I am looking forward to hearing from you soon. Thanks.
€500 EUR in 8 days
5.0 (3 reviews)
2.1
2.1
User Avatar
NONSENSE, Hi, I can solve your problem with Excel, PowerBI, TableAU or mysql. I will decide that after seeing your files. Hire me if you are interested in. Thanks
€250 EUR in 3 days
5.0 (2 reviews)
1.1
1.1
User Avatar
Hello sir, I have work experience in data entry field most of 8 years so i have complete your work before end of the time and i have work more faster so share me details for further. Thanks Anees
€500 EUR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
NONSENSE Hi. there? I have just read your description in detail. I am glad to meet you with your project. because I have a full skill you need on your project. I am living in development for 9 years. so I can help you easily and fastest. I hope to go forward with you. but if you only need my help, please contact me. Have a good day.
€250 EUR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello It's not auto bid. I do understand perfectly about your requirements. I can handle any amount of data like 700k-1M and more than that. I can create the database with specific fields. And function to import from excel or export MySQL to excel. It's difficult to explain all here. Can we have a chat for more details. I can start now. Quality of work and satisfaction is assurance Thanks
€722 EUR in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
NONSENSE Hi, There are two options. 1. Create a wordpress plugin 2. Create a seperate dashboard Both options should use an algorithm to merge files. I have my own way and can deliver it within 10 day. Btw, I have one question. The format of excel files are static or changeable. Let's discuss details via chat. Kasidit
€1,000 EUR in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Key word "NONSENSE" Good Day, I have a team of multiple experts, WordPress professional, designer, developer, and content writer. We will provide our services. We will provide quality on first priority. We believe on long term working relations. We will discuss other details via chat. Expecting a reply soon. Thank You
€500 EUR in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of GERMANY
frankfurt, Germany
5.0
6
Payment method verified
Member since Dec 31, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.