Data Sandbox

Upload Excel files into PgAdmin

  • 1.  Upload Excel files into PgAdmin

    Pitney Bowes
    Posted 07-30-2019 15:17
      |   view attached

    Excel is a powerful tool for compiling data, making tables, graphs, and more.  But, after learning basic SQL, Excel became far less superior in terms of faster, broader analyses.  This is just my opinion, of course (perhaps I should take a course on Excel).  In order to utilize SQL as part of my job, I had to be able to move Excel tables into PgAdmin.  The attached Word document is a step-by-step guide for users who already have some experience with PgAdmin/PostgreSQL and QGIS.  I hope it makes sense and has some benefit!

    Carlton Hemphill
    Spatial Data Analyst
    Schools Team
    White River Junction, VT