Import Product list in csv format to appsheet

[tatiya]

I am making an app for Inventory Managent. There are arround 2000 Products which needs to be added to appsheet. Its not practicle to add one by one to appsheet. I have all 2000 Products in Excel/csv format.

How can I import these in Appsheet?

[LeventK]

Open the CSV file with Google Spreadsheet and use that sheet to create an AppSheet app.

[tatiya]

Yes I know that. The point is the app is already created.
One option is to copy paste the product list to the Appsheet Excel but it doesnt work.

[Lynn]

Hi @tatiya
What do you mean by “it doesn’t work” You should be able to do that.

[Francios]

If you have the csv opened as excel or gsheet format you can add it to your app as a table.

[MultiTech]

tatiya:

There are arround 2000 Products which needs to be added to appsheet. Its not practicle to add one by one to appsheet. I have all 2000 Products in Excel/csv format.

How can I import these in Appsheet?

I’ve gone down roads like this before, here’s my workflow:

• Copy and paste all the data into the appropriate spreadsheet
  • making sure to put each column’s value into the correct column, skipping one’s that don’t have values, etc.
• Inside the app, implement a quick update system and use that to recalculate any app formulas that might be missing from the imported data.

One thing to check is that the column marked as the KEY for the table in AppSheet needs to have unique values in the table - but since we’re talking about products, there’s likely some unique product code already included in the data.

• I’m just pointing out that sometimes the data you try and import won’t have a key value; when that happens, AppSheet can’t see the records - it’s like there not there.

---

Here’s a post I just made about how to implement the quick update system I mentioned above:

Quick Update System - How to update records in your app with a push of a button Tips & Tricks 💡

“How can I update a parent record when a child record is changed?” “How can I mark all the line items in an invoice as paid when I mark the invoice as paid?” “If I have App Formulas inside a physical column, how can I get those to update like a virtual column?” “How can I recalculate formulas with a push of a button?” All of these situations can be solved by implementing a Quick Update System inside your app. What is the Quick Update System? A way to update app formulas and recalculate v…

[MultiTech]

Why couldn’t you utilize the Import CSV feature?

Import data from CSV Tips & Tricks 💡

I conducted quick testing for New Action of “Import CSV file” as it seems to be functional right now. [image] I save the CSV file (made out of Excel) and saved to local. This CSV have first row with exactly same names of column against the target table This is observation so far. Add new row It works. Make sure to add “unique value explicitly” on the csv file otherwise this action wont add new rows (for rows missing the key value) Even we have initial value set and leaving the value in…

Did you even search for this? It was the first thing that popped up.

This might help with finding answers:

Guide on How To Create a Community Post Tips & Tricks 💡

Dear valuable members and users, For a long time I’m seeing a lot of multiple and concurrent posts, posts like novels seeming to aim the Pulitzer Price, exactly the same questions by the same user but paraphrased/re-phrased etc. Being a dedicated community member and an AppSheet developer who is reading around 2.5K posts per day, I urged myself to tip on some good advice and best practice BEFORE posting something in the community: #1 - APPSHEET DOCUMENTATION AppSheet has a very good help do…