Hi,
I have been using Excel on Windows using the following functionality, and would like to move to PlanMaker on Android and keep the same or equivalent functionality:
- I have an Excel file with multiple sheets. One sheet (sheet1) contains data from csv files. I regularly pull updated csv files from the internet and store them in the same folder in Windows. This allows me to use the Data > Refresh All function to pull the latest data from the csv file. This updates the data in the sheet linked to the csv file (sheet1), and the cells are then linked to other cells in another sheet (sheet2) so I have all the data I need on that other sheet (sheet2)
- I cannot see this function in PlanMaker. What is the best/easiest way to get the data from the external csv file into the spreadsheet so that I can still have the data from the csv showing on sheet2?
Thanks!
using csv data in spreadsheet
Re: using csv data in spreadsheet
Unfortunately we don't have that feature yet, but I have forwarded your suggestion.
Re: using csv data in spreadsheet
Switching from Excel to PlanMaker can be a bit tricky. Unfortunately, PlanMaker doesn't have a direct ""Refresh All"" function like Excel. What you can do instead is manually import the CSV file each time you update it. Save your updated CSV file on your Android device, then go to PlanMaker, open your spreadsheet, and use the import function to bring in the new data to sheet1. You’ll need to update the links in sheet2 manually, but this method keeps your workflow somewhat intact.
Growing a business is pretty hard, and getting the right tools can make a big difference. A friend told me about Crispy Software Solutions; they can help you figure out How to Choose the Right Airtable Consulting Agency for Your Business. This company really helped me streamline my processes. So you can check out here about airtable partners .
Growing a business is pretty hard, and getting the right tools can make a big difference. A friend told me about Crispy Software Solutions; they can help you figure out How to Choose the Right Airtable Consulting Agency for Your Business. This company really helped me streamline my processes. So you can check out here about airtable partners .