Excel to CSV Question Catalog Transformation

  • État: Closed
  • Prix: €50
  • Propositions reçues: 27
  • Gagnant: zferd

Résumé du concours

I am looking for a data expert to help transform my Pdfs question catalog into a specific CSV format. The targeted CSV format is as follows: number;Filename;question;answer1;answer1correct;answer2;answer2correct;answer3;answer3correct;answer4;answer4correct.

- Purpose: The purpose of this project, namely, is to make the data compatible with a specific system.

- Assistance Required: Depending on the case, some data entries may need reformatting prior to transformation, ensuring they are structured correctly.

- Data Type: The 'question' and 'answer' columns contain mixed data, both textual and numerical.

Ideal Candidate Skills & Experience:
- Experience in data manipulation and transformation using Excel and CSV formats.
- Proficiency in data cleaning and standard standards application.
- Attention to detail to ensure entries are formatted correctly.

All Question has 2 - 4 answers with multiple right answers wich are marked by an X


The Excel i published is one of 4 Excel .. sum are 1400 questions

Compétences recommandées

Commentaire de l'employeur

“excelent Work!”

Image de profil BurgerA, Italy.

Meilleures propositions de ce concours

Afficher plus de propositions

Tableau de clarification publique

  • EmadOwaida
    EmadOwaida
    • il y a 1 mois

    Hello Contest holder, do you prefer each question along with related answers in one row!? Or you prefer each question in multi row based on answers numbers (4 rows) ?! (Please advise based on your new system requirement). Regards Emad

    • il y a 1 mois
    1. EmadOwaida
      EmadOwaida
      • il y a 1 mois

      #CONTEST HOLDER , even if you already choosed the winner, I'll appreciate if you please check and evaluate/Rate my Entry #24 And 5 tools created for your project. Regards Emad

      • il y a 1 mois
    2. EmadOwaida
      EmadOwaida
      • il y a 1 mois

      #CONTEST HOLDER , thanks a lot for your Rating. I really appreciate it ?

      • il y a 1 mois
  • mailtoafaqCEO
    mailtoafaqCEO
    • il y a 1 mois

    ???

    • il y a 1 mois
  • rekoleksitaktara
    rekoleksitaktara
    • il y a 1 mois

    hello sir, I have posted an example of the results of creating my CSV file in your link. you check at #22 by Rekoleksi Taktaradisi Laia. If you want to work with me, I am very happy to accept the job.

    • il y a 1 mois
  • Amrghazal
    Amrghazal
    • il y a 1 mois

    hello MR please check #21 is this like what you looking for ? thanks in advanced

    • il y a 1 mois
  • chintanshah97
    chintanshah97
    • il y a 1 mois

    Please check #7

    • il y a 1 mois
    1. chintanshah97
      chintanshah97
      • il y a 1 mois

      Sir! can you please share your feedback!

      • il y a 1 mois
  • zferd
    zferd
    • il y a 1 mois

    Also you said "All Question has 2 - 4 answers with multiple right answers wich are marked by an X". This is incorrect, there are questions with 5 and 6 answers or lines. Take for example question number 1080. Not only that number but there are others. How to proceed?

    • il y a 1 mois
  • zferd
    zferd
    • il y a 1 mois

    Another issue in xlsx, in question number 1479, the answer description is empty and it is marked as one of the correct answers. I believe this is incorrect. How to proceed?

    • il y a 1 mois
  • TayyabDastgir
    TayyabDastgir
    • il y a 1 mois

    out of four questions you want correct to be written in front of the answer where X is in column C, but what bout the one incorrect? Do you want to write incorrect or want to left it blank?

    • il y a 1 mois
    1. BurgerA
      Titulaire du concours
      • il y a 1 mois

      let it blank ! its ok

      • il y a 1 mois
  • zferd
    zferd
    • il y a 1 mois

    Parsing thru your xlsx file, I can see there are 6 answers or lines in question number 1166. And the word "vorgeschrieben" appears 3-times. Something is not right. The answer selections must be unique. How do we proceed?

    • il y a 1 mois
    1. BurgerA
      Titulaire du concours
      • il y a 1 mois

      it could be that the excel file has some error . possibile answers are 2-4 if there are more than 4 answers maybe the export of the answer was made in 2 ore more lines

      maybe i llpost a project with the original files

      • il y a 1 mois
  • Farrukh Saeed
    Farrukh Saeed
    • il y a 1 mois

    check #9

    • il y a 1 mois

Montrer plus de commentaires

Comment commencez des concours

  • Publiez votre concours

    Publiez votre concours Rapide et facile

  • Obtenez des tonnes de propositions

    Obtenez des tonnes de propositions De partout dans le monde

  • Attribuez la meilleure proposition

    Attribuez la meilleure proposition Télécharger les fichiers - Facile !

Publier un concours maintenant ou rejoignez-nous maintenant !