title: Creating charts from sql files
body: <p>I have a sql file containing information about a potential clients website keywords. I have exported this file from an ipad SEO app and got a sql file. I would like be able to show the information as charts or tables but Ive never worked with this file format before. Are there any good programs that can do this or is this a "hardcore programer task"?</p>
  
  <p>Thank you! </p>
  
  <p>Few lines taken from the sql file</p>
  
  <pre><code> SQLite format 3@  Ô    Ô-‚%
  ‡‡bgÅÅ_tabledomainsdomainsCREATE TABLE domains (domain_name varchar(100), id INTEGER PRIMARY KEY, sort integer, country varchar(2))Å--Ågtablekeywords_historykeywords_historyCREATE TABLE keywords_history (position integer, date_added varchar(10), id INTEGER PRIMARY KEY, kid integer)^ÅatablekeywordskeywordsCREATE TABLE keywords (sort integer, domain_id integer, id INTÅÇ  tablekeywordskeywordsCREATE TABLE keywords (sort integer, domain_id integer, id INTEGER PRIMARY KEY, keyword_text varchar(500), country varchar(2))
  ÉÓ◊¬∞ñÉliving.seSE-unifiedsweden.seSEes√§k.seSE#virotell.seSE)  mediaanalys.seSEapple.comUS˚˚≤£ìiT6 Ï› ¥ûÑo]D%÷¡•ëvW1·ƒ®˛ãtV)1hallm√∂bler malm√∂SE(#hallm√∂blerSE'/f√•t√∂ljer malm√∂SE%-belysning malm√∂SE#/
  inredningskonsultSE"3heminredning malm√∂SE!%
  heminredningSE$belysningSE$Atr√§dg√•rds m√∂bler malm√∂SE3
  tr√§dg√•rds m√∂blerSE+  soffbord malm√∂SEsoffbordSE-k√∂ksbord malm√∂SEk√∂ksbordSE$Avardagsrums m√∂bler malm√∂SE&amp;!f√•t√∂ljerSEsoffaSE3vardagsrums m√∂blerSE  )m√∂bler malm√∂SEm√∂blerSE  visitkortSE)webbutvecklingSE!webbdesignSE!web designSEadwordsSE
  ppcSE
  /sponsrade l√§nkarSE
  seoSE   3s√∂kmarknadsf√∂ringSE
  3s√∂kmotoroptimeringSE  !v√§rmepumpSE!abonnemangSEvirotellSE    mobilSE
  teleSE
  ppcSE   3s√∂kmotoroptimeringSEseoSE apple )˚˚∏•íÄn\J9&amp;Ì⁄»∂§íÄn\J8&amp;Ó€…∑•ìÅo]K9'ÒﬁÀ∏¶îÇp2!2013-02-07
  1!2013-02-070!2013-02-07/!2013-02-07
  .!  2013-01-24-!2013-01-24,!)2013-01-24+!2013-01-24
  *!2013-01-24)!2013-01-24(!2013-01-24
  '!2013-01-23&amp;!2013-01-23%!2013-01-23
  $!2013-01-23#!2013-01-23"!2013-01-23
  !!2013-01-11
   !2013-01-11!2013-01-11!    2013-01-11!2013-01-11!)2013-01-11!2012-12-24!2012-12-24!2012-12-24!2012-12-24!2012-12-24!2012-12-24!2012-12-24
  !2012-12-24!2012-12-24!2012-12-24
  !2012-12-19 !   2012-12-19!2012-12-19!%2012-12-19
  !2012-12-16!'2012-12-16 !   2012-12-16
  !2012-12-16     !2012-12-16!2012-12-16!2012-12-16!2012-12-16!2012-12-14!)2012-12-14 !   2012-12-14! 2009-06-05! @2009-2
  2pÓ‹À∏•íÄn\J9&amp;Ì⁄»∂§íÄn\J8&amp;Ó€…∑•ìÅo]K9'ÒﬁÀ∏¶îÇp2!2013-02-07
  1!2013-02-070!2013-02-07/!2013-02-07
  .!  2013-01-24-!2013-01-24,!)2013-01-24+!2013-01-24
  *!2013-01-24)!2013-01-24(!2013-01-24
  '!2013-01-23&amp;!2013-01-23%!2013-01-23
  $!2013-01-23#!2013-01-23"!2013-01-23
  !!2013-01-11
   !2013-01-11!2013-01-11!    2013-01-11!2013-01-11!)2013-01-11!2012-12-24!2012-12-24!2012-12-24!2012-12-24!2012-12-24!2012-12-24!2012-12-24
  !2012-12-24!2012-12-24!2012-12-24
  !2012-12-19 !   2012-12-19!2012-12-19!%2012-12-19
  !2012-12-16!'2012-12-16 !   2012-12-16
  !2012-12-16     !2012-12-16!2012-12-16!2012-12-16!2012-12-16!2012-12-14!)2012-12-14 !   2012-12-14! 2009-06-05! @2009-06-01
  !¶Ó‹ ∏¶îÇo]K'›À∏î¶Å9o]J8%Ó‹ ∏¶U!2013-02-180T!2013-02-18/S!2013-02-18.R!2013-02-18-Q!2013-02-18,P!2013-02-18+O!2013-02-18*N!
  2013-02-18)M!2013-02-18(L!2013-02-18'K!2013-02-18&amp;J!2013-02-18%H!2013-02-18#F!2013-02-18!G!2013-02-18"D!+2013-02-18C!2013-02-18B!2013-02-18A!2013-02-18@!2013-02-18?!2013-02-18&gt;!2013-02-18I!2013-02-18$&lt;!2013-02-18;!2013-02-18:!
  2013-02-189!2013-02-188!2013-02-077!2013-02-076!2013-02-075!2013-02-074!2013-02-073!2013-02-07
  'VÌﬂ¡≤£ìiT6 Ï› ¥ûÑo]D&amp;÷¡•ëvW1·ƒ®˛ãtV)1hallm√∂bler malm√∂SE(#hallm√∂blerSE'/f√•t√∂ljer malm√∂SE%-belysning malm√∂SE#/
  inredningskonsultSE"3heminredning malm√∂SE!%
  heminredningSE$belysningSE$Atr√§dg√•rds m√∂bler malm√∂SE3
  tr√§dg√•rds m√∂blerSE+  soffbord malm√∂SEsoffbordSE-k√∂ksbord malm√∂SEk√∂ksbordSE$Avardagsrums m√∂bler malm√∂SE&amp;!f√•t√∂ljerSEsoffaSE1vardagsrumsm√∂blerSE   )m√∂bler malm√∂SEm√∂blerSE  visitkortSE)webbutvecklingSE!webbdesignSE!web designSEadwordsSE
  ppcSE
  /sponsrade l√§nkarSE
  seoSE   3s√∂kmarknadsf√∂ringSE
  3s√∂kmotoroptimeringSE  !v√§rmepumpSE!abonnemangSEvirotellSE    mobilSE
  teleSE
  ppcSE   3s√∂kmotoroptimeringSEseoSE apple macUS
  [Ì”¡®ñ|[07sovrumsm√∂bler malm√∂SE/)sovrumsm√∂blerSE.sovrumSE-'mattor malm√∂SE,mattorSE+)matbord malm√∂SE*matbordSE
  </code></pre>