GETTING STARTED

How to use GISGP

Everything you need to import, export and work with ArcGIS Online data — answered in one place.

No articles found for "". Try a different keyword or contact support.
🚀 Quick start — import or export in 5 minutes
1

Find your ArcGIS FeatureServer layer URL

In ArcGIS Online, open Content → click your hosted feature layer → click View item details. Scroll to the bottom and copy the Service URL. It ends with /FeatureServer/0 (or another layer index).

Example: https://services.arcgis.com/abc123/arcgis/rest/services/MyLayer/FeatureServer/0

2

Connect your ArcGIS Online account

Easiest way: Register or log in with Sign in with ArcGIS Online (the blue button on the login page). Your token is set automatically — no copying required. You can then browse and add your services directly from the Services page.

Manual way: In ArcGIS Online, click your profile avatarMy Profile → scroll down → Generate Token. Set expiry (24 h is enough for testing), click Generate, copy the token, and paste it into the Token field when adding a service in GISGP.

If you use the "Sign in with ArcGIS Online" button, GISGP refreshes your token automatically. You never need to generate a new one manually.
3

Upload your file and map the fields

Go to Operations → Excel / CSV Import. Upload your file, select your service, and map your columns to AGOL fields using the dropdowns. A Preview & Confirm step shows your first 10 rows before anything is written — then click Confirm & Import. Your data lands in AGOL with no Pro license needed.

4

…or export your layer instead

Only need data out of ArcGIS Online? Skip straight to Exports. Paste your FeatureServer URL (steps 1–2 above), pick a format — Excel, CSV, GeoJSON, Shapefile or PDF report — optionally set a target coordinate system, and download. No import required.

Want it hands-free? Paid plans can schedule exports to run automatically and email you the file. Explore all one-off helpers on the free tools page — attachment downloader, Survey123 repeats export, schema comparator and more.
🔗 Service URLs & Tokens
What is a FeatureServer URL and where do I find it? +

A FeatureServer URL is the REST API address of your hosted feature layer in ArcGIS Online. GISGP uses it to read and write your GIS data directly.

To find it: ArcGIS Online → Content → your layer → View item details → Service URL (bottom of page). Copy the URL — it should end with /FeatureServer/0.

If you have a MapServer URL (/MapServer/0), you can use it for exports and tools but not for imports (MapServer layers are read-only).

How do I get an AGOL token? +

Tokens prove that you have permission to access a private layer:

  1. Log in to ArcGIS Online (arcgis.com)
  2. Click your profile avatarMy Profile
  3. Scroll to the bottom → Generate Token
  4. Set the expiry (we recommend 24 hours)
  5. Click Generate Token → copy the result
Tokens expire. If you get an "Invalid token" error, generate a new one.
Do I need a token for public layers? +

No. If a layer is shared publicly (Everyone) in ArcGIS Online, leave the Token field empty. You only need a token for layers that are private or restricted to your organisation.

Will GISGP work with my organisation's ArcGIS Enterprise Portal? +

Yes — paste your portal's FeatureServer URL (e.g. https://portal.mycompany.com/arcgis/rest/services/…/FeatureServer/0) and a token generated from that portal. The workflow is identical to ArcGIS Online.

Make sure your token has Editor or higher permissions on the target layer.

🌐 ArcGIS Online connection
What is "Sign in with ArcGIS Online" and should I use it? +

It is the easiest way to connect GISGP to your ArcGIS Online account. Click the blue Sign in with ArcGIS Online button on the login page, log in with your usual ArcGIS credentials, and you are done — no token needed.

Benefits vs. manual token:

  • Token is set and refreshed automatically — never expires unexpectedly
  • Your AGOL services appear automatically on the Services page — one click to add them
  • The Import wizard auto-fills your token for any private layer
Works with ArcGIS Online accounts (arcgis.com). Enterprise Portal users should use the manual token method.
How do I add my ArcGIS Online layers after signing in with OAuth? +

Go to Services in the left sidebar. You will see a blue banner — Connected to ArcGIS Online — with a Browse my services → button. Click it to see all your Feature Services from ArcGIS Online. Click + Add next to any layer to save it to your profile with your token pre-filled.

If you are not connected via OAuth, you can still add services manually by pasting the URL and token.

Will GISGP work with my organisation's ArcGIS Enterprise Portal? +

Yes — paste your portal's FeatureServer URL (e.g. https://portal.mycompany.com/arcgis/rest/services/…/FeatureServer/0) and a token generated from that portal. The workflow is identical to ArcGIS Online.

Generate a token from your Enterprise Portal: Portal URL/sharing/rest/generateToken, or from the Portal's web UI under My Profile → Generate Token.

Make sure your token has Editor or higher permissions on the target layer.

Do I need a token for public layers? +

No. If a layer is shared publicly (Everyone) in ArcGIS Online, leave the Token field empty. You only need a token for layers that are private or restricted to your organisation.

📥 Import
What is a "dry run" (validate only)? +

A dry run validates your data and field mapping without actually writing anything to your AGOL layer. It shows you exactly how many rows would succeed and what errors exist — useful for checking a new import before committing.

The demo import always runs as dry-run. Your own imports push real data to AGOL.

What file formats can I import? +
  • Excel (.xlsx) — any sheet; first row = headers
  • CSV (.csv) — comma or semicolon separated
  • CSV / Excel with coordinates — columns named Latitude/Longitude (or X/Y) → creates Point features
  • KML / KMZ — Google Earth exports
  • Geotagged Photos (.jpg/.jpeg) — GPS EXIF → Point features
What is the Preview & Confirm step? +

Between field mapping and the actual import, GISGP shows a dedicated Preview & Confirm step. It displays your first 10 rows exactly as they will appear in ArcGIS Online — with AGOL field aliases as column headers — so you can verify the mapping before committing.

You also see a summary chip showing the number of mapped columns and the import mode (Add or Upsert). Only mapped fields are shown; skipped columns are excluded. Click ← Back to Mapping to adjust, or Confirm & Import → to proceed.

What are saved field mapping profiles? +

After you have configured the field mapping dropdowns, click 💾 Save profile and give it a name (e.g. "Monthly Survey"). Next time you import the same format of file to the same service, your profile appears in the Load saved profile dropdown — click it and all mappings are restored instantly.

Profiles are saved per service. You can delete outdated profiles with the 🗑 button.

What is "Update / add by key" (Upsert) mode? +

By default, imports add all rows as new features. If you run the same import twice you get duplicates.

Update / add by key (Upsert) prevents this: choose a key field (e.g. asset_id) and GISGP will:

  • Update existing features where the key field value matches
  • Add new features for rows whose key is not yet in AGOL

Use this for monthly data refreshes where you want to update existing records rather than duplicate them.

My import failed — what do I do? +

Check the import log shown after the run. Common causes:

  • Type mismatch — a text value in a number field. Fix the data in your Excel file.
  • Domain violation — a value not in the coded-value domain. Use the free Domain Extractor tool to see valid codes.
  • Token expired — generate a new token, or use "Sign in with ArcGIS Online" for automatic token refresh.
  • Row limit exceeded — your plan allows a limited number of rows per import. Upgrade or split the file.
  • No edit permissions — your AGOL token must have Editor or higher rights on the target layer.
📤 Export & Free Tools
What export formats are available? +
  • Excel (.xlsx) — attributes only
  • CSV (.csv) — attributes only
  • Shapefile (.zip) — geometry + attributes, WGS84 projection
  • KML (.kml) — geometry + attributes, for Google Earth
  • KMZ (.kmz) — compressed KML
  • GeoJSON (.geojson) — geometry + attributes, standard web GIS format

All formats include all selected attributes. Use the WHERE filter in the export wizard to export a subset of features.

Do the free tools require a GISGP account? +

No. All 20 free tools are available without registration, including:

  • GeoJSON Viewer — view, convert and export GeoJSON/SHP/KML/CSV/Excel/DXF
  • REST Explorer — browse any AGOL service
  • Health Check — test connectivity and performance
  • Domain Extractor — see all coded-value domains
  • Field Type Checker — inspect field schema
  • SQL WHERE Builder — build and test filter queries
  • Coordinate Converter — convert between coordinate systems
  • Web Map Layers — inspect all layers in a Web Map
  • Survey123 Lookup — find and export Survey123 form data
  • Feature Count — count features in any Feature Service
📊 Plan limits
PlanPriceImports / monthMax rows / importExports / monthTeam seatsSchedules
Free$0 31005
Starter$9 202,00050
Pro$19 1005,0002003
Team$49 30050,0007505 seats10
Business$99 999,99910 seats25

Limits reset on the 1st of each month. Demo operations never count against your limits.

🕐 Scheduled Exports
What are Scheduled Exports? +

Scheduled Exports automatically export data from your AGOL Feature Service on a recurring schedule (daily or weekly) and send the file as an email attachment. No manual action is needed after setup.

Available on Starter, Pro, Team and Business plans (Starter = 1 schedule, Pro = 5, Team = 10, Business = 25).

How do I set up a scheduled export? +
  1. Go to Schedules in the sidebar (visible on Pro+ plans)
  2. Select a service, format, and optional WHERE filter
  3. Choose Daily or Weekly and the UTC hour to run
  4. Enter the email address to receive the file
  5. Click Create Schedule

The first run will happen at the next occurrence of the selected time. You can pause, resume or delete any schedule from the same page.

What formats can a scheduled export produce? +

Six formats are available: Excel (.xlsx), CSV, Shapefile (.zip), KML, GeoJSON, and PDF Report. The file is attached directly to the email.

For PDF schedules, select the PDF format and optionally choose a saved PDF Template — the report will use your saved layout, accent colour and basemap automatically on every run.

Can I preview the email before creating a schedule? +

Yes. The Email Delivery Preview card on the Schedules page shows you exactly what the recipient will receive — From address, Subject line, body text, and the attachment filename — before you click Create Schedule. The preview updates live as you change the service, format, frequency, or recipient address.

Can I send the export to a different email than my account? +

Yes. Each schedule has its own Send to email field — you can send to a colleague, a shared inbox, or any address. Your account email is the default but can be changed per schedule.

🗄 Service Hub
What is the Service Hub? +

Each saved service has a dedicated Hub — a tabbed workbench that gives you a complete view of that layer without leaving GISGP. Click the Hub button on the Services page to open it.

The Hub includes:

  • Overview — metadata: geometry type, feature count, capabilities, CRS
  • Map — interactive Leaflet map with your layer's original AGOL symbology (simple, unique-value and class-breaks renderers). Features display at the correct geographic position.
  • Attributes — table of all records; click a row to highlight the feature on the map
  • Quick links to Import and Export for that service
Why do the features show in the wrong position on the map? +

This does not happen in GISGP — all map requests include outSR=4326 to ensure coordinates are returned in WGS84, which is what Leaflet expects. If you see features at the wrong location in an external tool, it is likely because the tool is missing this parameter and receiving Web Mercator coordinates instead.

💾 Saved Queries
What are Saved Queries? +

Saved Queries let you store frequently used WHERE clauses (SQL filters) and reload them in one click. Instead of typing status='Active' AND district='North' every time, save it once and load it from any export or filter panel.

Go to Saved Queries in the sidebar to manage your library. You can optionally associate a query with a specific service, or keep it generic.

How do I save a query from the Export wizard? +
  1. In the Exports wizard, Step 2 — build your WHERE filter
  2. Click Save Query and give it a name
  3. The query is saved to your Saved Queries library

Next time, click Load Saved Query in the export filter panel and select it from the dropdown.

📄 PDF Template Builder
What is the PDF Template Builder? +

The PDF Template Builder (PDF Builder in the sidebar) is a visual editor for customising how Feature Report PDFs look. You can set:

  • Accent colour — choose from presets or enter any hex colour
  • Map aspect ratio — Standard (4:3) or Wide (16:9)
  • Basemap — Topographic, Satellite or Streets
  • Report title
  • Sections — toggle Summary, Location Map, Attributes, Geometry, Notes on or off

A live preview with a real Leaflet map updates in real time as you make changes. When you are happy, click Save Template.

How do I use a saved template in the Service Report tool or a Schedule? +

Service Report tool (Tools → Service Report PDF): After loading a layer, open the Saved Templates card and click Load next to any template. The layout, accent colour and basemap are applied to the live preview immediately.

Scheduled PDF export: When creating a schedule with format PDF, a PDF Template picker appears. Select a saved template — every automatic PDF run will use that layout.

Can I email a PDF report directly from the builder? +

Yes. Once you have selected a feature in the Browse Features panel and the preview looks correct, scroll to the Email Delivery card, enter a recipient address and click Send PDF. The PDF is generated and delivered within a few seconds (requires a GISGP account).

🔑 Connected Accounts
What are Connected Accounts? +

Connected Accounts let you store tokens for multiple ArcGIS Online organisations in one GISGP profile. This is useful if you work with more than one AGOL org — for example as a consultant with several clients, or as staff in two organisations.

Go to Connected Accounts in the sidebar to add, check or remove accounts. Each account stores the org URL, your username and a token. The Check Connection button verifies the token is still valid.

Do Connected Accounts replace the main OAuth login? +

No — they are complementary. Your main GISGP login (email + password or Sign in with ArcGIS Online) stays unchanged. Connected Accounts store additional org tokens you can reference when adding services manually from other organisations.

⚙️ Settings
What can I configure in Settings? +

Go to Settings in the sidebar to customise your experience:

  • Organisation name & footer text — appear in generated PDF reports
  • Default basemap — pre-selects the map background in all tools
  • Default export format — pre-selects the format in the Export wizard
  • Default PDF orientation — Portrait or Landscape
  • Email notifications — toggle alerts for completed imports, exports, scheduled runs and errors
How do I add my organisation name to PDF reports? +

Go to Settings → Organisation name, enter your organisation name and footer text, and save. This text will appear in the header and footer of all Feature Report PDFs you generate from the Service Report tool or via Scheduled Exports.

👥 Team seats
How do Team seats work? +

Team (5 seats) and Business (10 seats) plans let the account owner invite additional users who share the plan's limits. Each invited member gets their own GISGP login and can run imports and exports independently.

The member's usage (imports, exports) is counted against the owner's plan limits. Members cannot manage billing, team seats, or scheduled exports — those are owner-only actions.

How do I invite a team member? +
  1. Go to Team in the sidebar (visible on Team and Business plans)
  2. Enter the email address of the person you want to invite
  3. Click Send Invitation

The invitee receives an email with an acceptance link. They need a GISGP account with that email address — if they don't have one, they can create it for free and then accept the invitation.

An invitation is tied to a specific email address. The invitee must sign in with the exact address the invitation was sent to.
Can I remove a team member? +

Yes. On the Team page, click the Remove button next to any member. They immediately lose access to the team plan and revert to a Free account.

🛡 Security & GDPR
Does GISGP store my GIS data? +

No. Files you upload (Excel, CSV, KML, photos) are stored temporarily on AWS S3 only to perform the operation. They are automatically deleted from our servers immediately after the import or export completes — typically within 60 seconds.

Your GIS data is written directly from the upload to your own ArcGIS Online account. We do not maintain a copy.

Is GISGP GDPR compliant? Can my organisation use it? +

Yes. GISGP is designed for EU compliance:

  • Temporary files auto-deleted after each operation
  • Infrastructure hosted in AWS EU (Ireland, eu-west-1)
  • All traffic over HTTPS/TLS; passwords stored as bcrypt hashes
  • A full Data Processing Agreement (DPA) is available — required by GDPR Art. 28 for Controller–Processor relationships
  • Sub-processors listed in the DPA; international transfers covered by Standard Contractual Clauses
Public sector organisations needing a countersigned DPA can request one via email — returned within 2 business days.
Does GISGP use any third-party AI services? +

Not currently. Automatic AI field mapping is planned for a future release. When enabled, only column headers, up to 10 sample rows, and AGOL field metadata would be sent — never the full dataset.

All other operations (import, export, validation, scheduled exports, free tools) are processed entirely within GISGP's own infrastructure. No GIS data is shared with any external AI service.

Still have a question?

Write to us and we'll reply within one business day.

Contact Support

How to Export ArcGIS Online Data to Excel

GISGP Help · Export · 2 min read

Export any ArcGIS Online Feature Service to Excel, CSV, Shapefile, KML or GeoJSON in two clicks — no ArcGIS Pro, no Python. Open Export Studio, paste your Feature Service URL, optionally filter with a WHERE clause, pick a format and export — Shapefile and GeoJSON can be reprojected to any EPSG (target CRS) on the way out. Large exports (Team/Business plans) run in the background and arrive by email.

Full step-by-step guide, supported formats and FAQ: Export ArcGIS Online to Excel →

Export your data now → ▶ Watch: Export to Excel (60 sec)

How to Download All Attachments from ArcGIS Online

GISGP Help · Attachments · 2 min read

ArcGIS Online has no bulk "download all attachments" — the only built-in path is a full File Geodatabase export, which needs layer ownership and ArcGIS Pro to extract. The free Attachment Downloader covers that gap: paste a Feature Service URL (add a token for private layers), scan to see how many photos and files the layer holds, and download everything as one ZIP — a folder per feature, named by a field you choose, plus an _index.xlsx mapping every file to its record. Works with Survey123 photo submissions.

Need it recurring? On a paid plan, add a schedule with the Attachments backup format — a fresh ZIP link lands in your inbox daily, weekly or monthly.

Download attachments now →

How to Export Survey123 Repeats Joined with the Parent Survey

GISGP Help · Survey123 · 2 min read

Survey123 stores repeat answers in related tables, and ArcGIS Online exports them as separate tables — leaving you to match them by GlobalID with VLOOKUP or a script. The free Repeats Export tool does the join for you: paste the survey's FeatureServer URL, scan to see the repeat tables, and download one Excel with a Parent sheet, a sheet per repeat table, and a flattened Joined sheet where every repeat row already carries its parent record.

Join keys are read straight from the layer's relationship definitions, so it works with any related-records layer — not just Survey123. Filter parents with a WHERE clause for large surveys.

Export repeats joined →

How to Compare the Schemas of Two ArcGIS Layers

GISGP Help · Inspect · 1 min read

Appends fail and migrations bite when two layers' schemas quietly drift apart — and ArcGIS Online has no schema compare (it's a Pro-only tool). The free Schema Comparator diffs two layers in the browser: added and removed fields, plus type, length, domain and nullable changes, with a copy-ready report for your migration doc.

Compare two layers →

How to Schedule Automatic ArcGIS Online Exports

GISGP Help · Schedules · 4 min read

Manually exporting data from ArcGIS Online every week is slow and easy to forget. GISGP lets you schedule recurring exports — daily, weekly or monthly — and deliver the file directly to your inbox as an Excel, CSV or Shapefile attachment. No servers, no Python scripts, no cron jobs.

What you can schedule

  • Any ArcGIS Online or Enterprise Feature Service layer
  • Any export format: Excel, CSV, Shapefile, KML, GeoJSON — or an Attachments backup (ZIP of all layer photos/files, delivered as a 24h link)
  • Any WHERE clause filter — export only today's records, only "Open" status, etc.
  • Delta exports — only records changed since the last run
  • Multiple recipients — comma-separated email addresses

Setting up a scheduled export

  1. Go to Schedules and click New Schedule.
  2. Select your Feature Service and configure the export (format, fields, WHERE filter).
  3. Set the frequency: hourly (1–12h), daily, weekly or monthly.
  4. Enter one or more email addresses for delivery.
  5. Click Save. The first run will happen at the next scheduled time.

💡 Delta mode: enable "Only changes since last run" to export only records edited or added since the previous delivery. Ideal for large layers where you only care about what changed.

Frequency and timing

Schedules run on UTC time. For a daily export at 8:00 AM CET, set the run hour to 7. GISGP checks for due schedules every 5 minutes, so actual delivery is within 5 minutes of the configured time.

Plan limits

  • Free: no schedules
  • Starter: 1 active schedule
  • Pro: 5 schedules
  • Team: 10 schedules
  • Business: 25 schedules
Set up a schedule → ▶ Watch: Schedule automatic exports (90 sec)

See also: monitor your ArcGIS Online service for uptime and error alerts alongside your scheduled exports.

How to Import Excel or CSV Data into ArcGIS Online

GISGP Help · Import · 2 min read

Update an ArcGIS Online Feature Service from Excel, CSV or KML using GISGP's browser-based Import Studio — field mapping, AGOL dry-run validation, preview and bulk add/upsert, no ArcGIS Pro or Python required. Open Import Studio to get started.

Full step-by-step guide, supported formats, row limits by plan and troubleshooting: Import Excel to ArcGIS Online →

Import your data → ▶ Watch: Import Excel to ArcGIS (90 sec)

ArcGIS Online SQL WHERE Clause — Complete Guide

GISGP Help · Tools · 5 min read

The WHERE clause is the standard way to filter features in ArcGIS Online Feature Services. Whether you're exporting only this week's inspections, querying open work orders, or scheduling a daily report of changed records — you need a valid SQL WHERE expression. This guide covers the syntax, common examples and the free GISGP WHERE Builder tool.

Basic syntax

ArcGIS Online uses a subset of standard SQL for WHERE clauses. The general form is:

field_name operator value

Multiple conditions can be combined with AND / OR:

STATUS = 'Open' AND PRIORITY = 1

Field types and operators

Text fields

  • Equals: STATUS = 'Open'
  • Not equals: STATUS <> 'Closed'
  • Contains: NAME LIKE '%road%' (case-insensitive)
  • Starts with: NAME LIKE 'Main%'
  • List: STATUS IN ('Open', 'Pending')

Number fields

  • PRIORITY = 1
  • SCORE >= 80
  • SCORE BETWEEN 50 AND 100

Date fields

ArcGIS Online uses the timestamp keyword for date comparisons:

  • After a date: EditDate >= timestamp '2026-01-01 00:00:00'
  • Within a range: EditDate BETWEEN timestamp '2026-01-01 00:00:00' AND timestamp '2026-06-30 23:59:59'
  • Today's records: use the WHERE Builder date presets — it generates the correct timestamp automatically.

NULL values

  • Is empty: NOTES IS NULL
  • Has a value: NOTES IS NOT NULL

Common examples for GIS teams

  • Open work orders: STATUS = 'Open'
  • High priority items: PRIORITY IN (1, 2) AND STATUS <> 'Closed'
  • Last 7 days: EditDate >= timestamp '2026-05-30 00:00:00'
  • Specific inspector: INSPECTOR = 'J.Smith' AND INSPECTION_DATE >= timestamp '2026-06-01 00:00:00'
  • All records: leave the WHERE clause empty

💡 Use the free SQL WHERE Builder — paste your FeatureServer URL, pick your fields from dropdowns and the tool writes the SQL for you. No typing required.

Testing your WHERE clause

Before exporting or scheduling, test your filter in the WHERE Builder:

  1. Go to tools/where-builder
  2. Paste your FeatureServer URL
  3. Build your conditions using the field dropdowns
  4. Click Preview — see the matching record count instantly
Open WHERE Builder → ▶ Watch: Save and reuse WHERE filters (60 sec)