<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <br>
    <font face="Helvetica, Arial, sans-serif">SQL Workbench/J can
      read/write Excel files directly.   It's pretty much a replacement
      for pgAdmin and for most of the things that are done in psql.<br>
      <br>
      Ruven Brooks<br>
    </font><br>
    <br>
    <div class="moz-cite-prefix">On 8/15/2020 10:39 AM, Paolo Cavallini
      wrote:<br>
    </div>
    <blockquote type="cite"
      cite="mid:E5A4141C-735B-45DE-AFE4-3FE0F8FBA0AB@faunalia.it">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      The easiest I know of is through QGIS.<br>
      Cheers.<br>
      <br>
      <div class="gmail_quote">On 15 August 2020 17:07:06 CEST, Imre
        Samu <a class="moz-txt-link-rfc2396E" href="mailto:pella.samu@gmail.com"><pella.samu@gmail.com></a> wrote:
        <blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt
          0.8ex; border-left: 1px solid rgb(204, 204, 204);
          padding-left: 1ex;">
          <div dir="ltr">> Is there a simple way for users to load
            their data into PostGIS?
            <div><br>
            </div>
            <div>CSV?</div>
            <div>-  save as a CSV file  ( contains LAT , LON columns )</div>
            <div> - import CSV to Postgres<br>
              -  convert LAT/LON  to geometry columns ... <br>
              <a
href="https://stackoverflow.com/questions/2987433/how-to-import-csv-file-data-into-a-postgresql-table"
                moz-do-not-send="true">https://stackoverflow.com/questions/2987433/how-to-import-csv-file-data-into-a-postgresql-table</a><br>
            </div>
            <div><br>
            </div>
            <div>or scripting?  ( Python; Julia, R , ...  )</div>
            <div>or any DB tool?  ( <a
                href="https://dbeaver.com/docs/wiki/Data-transfer/"
                moz-do-not-send="true">https://dbeaver.com/docs/wiki/Data-transfer/</a> ;
              PGAdmin4: <a
                href="https://www.youtube.com/watch?v=Ikd2xSb00UI"
                moz-do-not-send="true">https://www.youtube.com/watch?v=Ikd2xSb00UI</a> )</div>
            <div><br>
            </div>
            <div>Imre</div>
            <div><br>
            </div>
            <div><br>
            </div>
            <div><br>
            </div>
          </div>
          <br>
          <div class="gmail_quote">
            <div dir="ltr" class="gmail_attr">Shaozhong SHI <<a
                href="mailto:shishaozhong@gmail.com"
                moz-do-not-send="true">shishaozhong@gmail.com</a>>
              ezt írta (időpont: 2020. aug. 15., Szo, 15:35):<br>
            </div>
            <blockquote class="gmail_quote" style="margin:0px 0px 0px
              0.8ex;border-left:1px solid
              rgb(204,204,204);padding-left:1ex">
              <div dir="ltr">Scenario:  Many Excel users seek to
                contribute data to PostGIS.  Excel can be connected to
                PostGIS via ODBC.
                <div><br>
                </div>
                <div>Is there a simply way for users to load their data
                  into PostGIS?</div>
                <div><br>
                </div>
                <div>Regards,</div>
                <div><br>
                </div>
                <div>Shao</div>
              </div>
              _______________________________________________<br>
              postgis-users mailing list<br>
              <a href="mailto:postgis-users@lists.osgeo.org"
                target="_blank" moz-do-not-send="true">postgis-users@lists.osgeo.org</a><br>
              <a
                href="https://lists.osgeo.org/mailman/listinfo/postgis-users"
                rel="noreferrer" target="_blank" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote>
          </div>
        </blockquote>
      </div>
      <br>
      -- <br>
      Please excuse my brevity.
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <pre class="moz-quote-pre" wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre>
    </blockquote>
    <br>
  </body>
</html>