AppAlloy Documentation
Home
  • Glossary
  • 🚀Getting Started
    • Introduce AppAlloy Documentation
    • Build your first AppAlloy app
    • From sheet to app
  • 🗃️Data management
    • Learn data structure
    • Set up data source
      • Integrate with Google Sheets
      • Integrate with Microsoft Excel
      • Build Alloy table
      • Upload local file
    • Manage data type
    • Ultimate guide for data sheet
  • ⚒️Manage table views
    • Design Record View
    • Design Actions
      • Update current record
      • Delete current record
      • Delete many records
      • Create record
      • Open external URL
      • HTTP Request
      • Open phone call popup
      • Open SMS Popup
      • Open email popup
      • Send notification
    • Design Record Components
      • Plain Text
      • Phone number
      • Email
      • URL
      • Map
      • Barcode
      • Checkbox
      • Number
      • Currency
      • Rating
      • Voting
      • Date time
      • Relative date
      • Count Down / Count Up
      • Single Photo
      • Photo Gallery
      • Carousel
      • Audio Player
      • Video Player
      • Youtube Player
      • Vimeo Player
    • Design Form View
    • Design Form fields (synced tables)
      • Text (for synced tables)
      • Number (for synced tables)
      • Date time (for synced tables)
      • Checkbox (for synced table)
      • Options (for synced table)
      • Photos (for synced table)
      • Files (for synced table)
      • Table lookup (for synced table)
      • Signature (for synced table)
    • Design Form fields (Alloy tables)
      • Single line Text (for Alloy table)
      • Long Text (for Alloy table)
      • Phone number (for Alloy table)
      • Email (for Alloy table)
      • Barcode (for Alloy table)
      • Number (for Alloy table)
      • Currency (for Alloy table)
      • Checkbox (for Alloy table)
      • Date (for Alloy table)
      • Photos (for Alloy table)
      • Files (for Alloy table)
      • Single select (for Alloy table)
      • Multiple select (for Alloy table)
      • Address (for Alloy table)
      • Table lookup (for Alloy table)
  • 🎨Manage pages
    • Manage page types
    • Design 'View From' Page
    • Page Layouts
      • List Layout
      • Grid Layout
      • Card Layout
      • Map Layout
      • Checklist Layout
      • Calendar Layout
      • Kanban Layout
    • Design Canvas View Page
    • Canvas Charts
      • Line chart
      • Area Chart
      • Pie Chart
      • Donut Chart
      • Column chart vs. Stacked Column chart
      • Bar chart vs. Stacked bar chart
      • Table
    • Design Form of... Page
  • ⚙️Manage workflow
    • Introduce Workflow
    • Design a workflow
  • 🔌Manage Integration
    • Manage AppAlloy Integration
    • Manage Slack Integration
    • Manage Gmail Integration
    • Manage Google Drive Integration
    • Manage Google Calendar integration
  • 📱Manage App Settings
    • Manage app appearance
  • 🌎App distribution
    • Publish your app
    • Use app as Mobile Web app
    • Use app on AppAlloy Air
  • 🚹Account, team, and plan
    • Manage Account
    • Manage Apps
    • Manage Users
    • Manage Plans
    • Manage Teams
  • #️⃣Learn Power FX
    • Introduce Power FX
    • Operators & Identifiers
    • Formula References
      • Average
      • Concatenate
      • Date
      • DateAdd
      • DateDiff
      • DateValue
      • DateTimeValue
      • Day
      • If
      • Month
      • Now
      • Rand
      • RandBetween
      • Round
      • RoundDown
      • RoundUp
      • Sum
      • Text
      • Today
      • Weeknum
      • Weekday
      • Year
Powered by GitBook
On this page
  • Overview
  • How it works
  • How to set it up
  • Manage table & data
  • Special note
  • Troubleshooting issue
  • Changing data type causes data loss

Was this helpful?

  1. Data management
  2. Set up data source

Upload local file

Learn to bring your existing data files to AppAlloy, simplifying the data manipulation steps of your app creation.

Last updated 8 months ago

Was this helpful?

Overview

Uploading CSV or XLSX files from your local device to AppAlloy is a convenient way to import existing data into the platform, allowing you to leverage the full power of native tables.

This method is ideal for scenarios where data is stored in local files, and you need to transition to a more integrated and dynamic data management system within AppAlloy.

This is ideal for use cases that include importing legacy data, conducting initial data setup for new applications, and managing periodic data updates.

How it works

When you upload a CSV or XLSX file to AppAlloy, the platform converts the file into a native Alloy table.

This process involves parsing the file, creating columns based on the file's structure, and populating the table with the data from the file.

Once uploaded, the native table can be used like any other Alloy table, supporting CRUD (create, read, update, and delete data) operations and seamless integration with other app components.

How to set it up

AppAlloy supports files in format .csv, .xlsx, .xls, and under 10MB.

To upload your file onto AppAlloy and turn it into Alloy table:

  • Go to tab Data, on the section All Tables, click the + icon

  • Choose Upload files

  • Drag & drop, or click to select your file in the uploading window

  • Select the checkbox to choose the sheet(s) for syncing

  • Select the check box Automatically create new pages for selected sheets if you want AppAlloy to create the collection view, form view, and record view for the newly-synced sheets

  • Click Save to start uploading your file

Manage table & data

When a local data spreadsheet file is uploaded successfully onto the data tab of AppAlloy, it can be managed as a native Alloy table with full access to the built-in one.

Read more about how to manage tables & data of an uploaded file here:

Special note

AppAlloys doesn't support exporting the file with new data. In case you plan to save the future updated data back to your local file as well, consider importing your file to spreadsheets then set up the synchronization. Read more about this type of data source:

Troubleshooting issue

Changing data type causes data loss

You can try to press F5 to refresh the browser first.

The situation of losing data often happens when you just import data into the Alloy table and then change the column's data type immediately while the new data is not saved into the database yet.

Then, try to import the data again. On this next try, please wait for about 1-2 minutes until the saving of your data is complete. Then, you can change your data type.

🗃️
Build Alloy table
Integrate with Google Sheets