Answers.Body: <p>The question would need clarification. I'm new here so I will try to give an answer.
  The easiest way would be to prepare the data in comma separated values (CSV). It is possible to export your data in this format from excel.
  For downstream applications it will depends what programming language is used but in general it is possible to import CSV files and the data they contain for training (example panda data frame in python).</p>
  
  <p>Hope this helps!</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-08-24T20:54:30.333Z
Answers.LastActivityDate: 2019-08-24T20:54:30.333Z
Answers.UserDisplayName: Dr. H. Lecter
Body: <p>I want to use AI to extract data from spreadsheets in different format.</p>
  
  <p>Example</p>
  
  <pre><code>Shop Name Product 1.  Product 2.  Product 3.
  Shop Name
  Product 1.
  Product 2.
  Product 3.
  </code></pre>
  
  <p>We will teach the algorithm the name of the profits and shops but it needs to know how to extract and put in a format that can be used downstream.</p>
  
  <p>Can anyone recommend a tool?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-08-10T13:37:45.343Z
Comments.Text: What do you mean by " extract data from spreadsheets in different format.". Even with the example, it is not clear. Please, clarify your question a little more.
Comments.UserDisplayName: nbro
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-08-12T15:27:46.077Z
Comments.Text: more elaboration is needed,for effective feedback!
Comments.UserDisplayName: quintumnia
Tags: <ai-design>
Title: Excel in multiple formats
UserDisplayName: Glenn Channon
ThreadText: # Excel in multiple formats
  
  (Asked by: username_0 on 2019-08-10)
  
  I want to use AI to extract data from spreadsheets in different format.
  
  Example
  
  ```
  Shop Name Product 1.  Product 2.  Product 3.
  Shop Name
  Product 1.
  Product 2.
  Product 3.
  
  ```
  
  We will teach the algorithm the name of the profits and shops but it needs to know how to extract and put in a format that can be used downstream.
  
  Can anyone recommend a tool?
  
  **Tags:** ai-design
  
  > **Comments:**
  > **username_1**: What do you mean by " extract data from spreadsheets in different format.". Even with the example, it is not clear. Please, clarify your question a little more.  
  > **username_2**: more elaboration is needed,for effective feedback!  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_3 on 2019-08-24. Score: 1
  
  The question would need clarification. I'm new here so I will try to give an answer.
  The easiest way would be to prepare the data in comma separated values (CSV). It is possible to export your data in this format from excel.
  For downstream applications it will depends what programming language is used but in general it is possible to import CSV files and the data they contain for training (example panda data frame in python).
  
  Hope this helps!
  
  
  ---
  
  