Wrong data displayed from Excel Sheet in Google Drive

AppSheet AppSheet Q&A
1

Hi,
I have recently uploaded an Excel sheet onto my Google Drive and imported this table to use in my app. The data, however is not showing when I select “view data” in Tables > Data.

Could this be because of the type of data or is it because of the .xls file in Google?

I’ve simplified the data down to three entries in order to try and find the issue, see the screenshot:

3X_3_e_3e69988e782b1cd212d03c63f9e4e08227b9aa65.png
3X_3_e_3e69988e782b1cd212d03c63f9e4e08227b9aa65.png1960×148 21.7 KB

Please help if you have any suggestions on how to fix this?

Regards
Gerhard

2

Your data in Excel looks fine. Please provide the AppSheet side table and column definitions for further assistance.

Also, are you certain you are pointing to the datasource you thin you are?

1 Like
3

WillowMobileSystems:

Also, are you certain you are pointing to the datasource you thin you are?

Yep. This is a relatively common problem. Instead of using View Data, try View Source, which will take you to the actual file.

4

Thanks.

I presume you mean you would like to see this table?:

3X_8_6_867795c4f5e6fe422cfab4dab37978c957bf71a5.png
3X_8_6_867795c4f5e6fe422cfab4dab37978c957bf71a5.png1714×890 55.4 KB

Pretty sure it is pointing to the right datasource. I have reloaded the same tab from the same sheet three times afresh, with no change…

5

This is possibly a problem:

3X_8_0_80c03d42f0507503fd3a0ab3162d5fc025a61dc9.png

Date is your key column. Each key column value may only occur once in the column of that table. If a second row is created with the same key column value, it will replace the previous row with that key column value. If your table somehow gets multiple rows with the same key column value, AppSheet will only use one of them, and you can’t predict which one will be used.

I recommend you choose a different key column.

See also:

6

Thanks Steve,

I took this into account as the Date will always be a month to month counter and will always be unique. Nonetheless, I created a new column and added unique keys, set it as the key. I then regenerated the column structure, synced the app, and - still the same issue…

1 Like
7

Did you try View Source?

8

Yes, it takes me to the right spreadsheet. Doesn’t open the right tab though from the start. But the dummy data shows that it picks up the right columns from the right tab in the spreadsheet.
Can the formulas in the sheet have any effect on the representation of data or Appsheet vetting it as unacceptable?

9

Gerhard_Viljoen:

Excel sheet onto my Google Drive

I totally blew past the fact this was an Excel workbook on a Google Drive. Here is an excerpt from the article below:

AppSheet supports Excel .xlsx files. It does not support Excel .xls or .xlsm files.

Do you have to use Excel or is Google Sheets an option?

2 Likes
10

Thanks man.
I’ll rework it all into a Google sheet for the team then. We also have One Drive and I’ll see if I can access the file through that channel.

1 Like
11

Once yo have the Excel workbook in G-Drive, I believe there is a handy conversion option to generate a G-Sheet from the file.

For what its worth, from AppSheet, G-Sheets work much better, IMHO, they are more performant, better supported within the framework and more widely used throughout the community. And now that AppSheet is part of G-Cloud, it is promising that over time there will be seamless integration with other Cloud services.

1 Like