Author Topic: Excel for Android  (Read 10349 times)

Judi_bk

  • Administrator
  • Hero Member
  • *****
  • Posts: 3,294
Excel for Android
« on: 06 Jun, 2019, 11:36:05 am »
I am on Windows and have been asked to set up a database which will be used by someone on a tablet (not sure if it is ipad or not).  I think I am asking Drax really.  Will it work?, any guidelines? I can manage the database but the tablet user needs to see it and possibly input into it.  Tablet user not very computer literate and I know just enough to be dangerous

shelav

  • Slimmers group
  • Hero Member
  • *
  • Posts: 526
Re: Excel for Android
« Reply #1 on: 06 Jun, 2019, 02:54:47 pm »
I have a windows laptop and can access/change excel spreadsheets on both my iPad and Android phone using an excel app and signing into my Microsoft account.  I guess if the other person has a Microsoft account and downloads the app and you share the spreadsheet with them via tools they would be able to access it on their mobile device.  Not sure exactly how to do it though!

Drax

  • Hero Member
  • *****
  • Posts: 964
Re: Excel for Android
« Reply #2 on: 06 Jun, 2019, 03:23:52 pm »
Databases and spreadsheets are two different creatures. For excel shelav I'd also explore the google chrome options as well: https://www.google.com/sheets/about/

Judi databases are far more tricky, google won't entertain them as shareable so you are probably going to need the Microsoft Access route.
https://support.office.com/en-gb/article/ways-to-share-an-access-desktop-database-03822632-da43-4d8f-ba2a-68da245a0446

A bit more further information about sharing databases at: https://www.pcworld.com/article/165079/share_databases_online.html

 :tiphat:

Judi_bk

  • Administrator
  • Hero Member
  • *****
  • Posts: 3,294
Re: Excel for Android
« Reply #3 on: 06 Jun, 2019, 03:29:17 pm »
Thank you both for that.  I will look into that.  I agree Excel is not a database as such, it is a spreadsheet but you can use it as a database.  I prefer Access which is wonderful but too clever for the other intended users and they would have to pay to use it.   Excel will do  nicely for this.

Drax

  • Hero Member
  • *****
  • Posts: 964
Re: Excel for Android
« Reply #4 on: 06 Jun, 2019, 03:59:00 pm »
Google sheets is a great option in that case, we've used and shared them without any problem for some years now  :thumbsup:

Create on your computer, go to File / Import / Upload file and pow!!
« Last Edit: 06 Jun, 2019, 04:01:06 pm by Drax »

Judi_bk

  • Administrator
  • Hero Member
  • *****
  • Posts: 3,294
Re: Excel for Android
« Reply #5 on: 06 Jun, 2019, 04:07:43 pm »
Just what I need, thanks Drax  :tiphat: