This makes data processing to clean up columns way easier. I had a bunch of timestamped data and I needed to update the format to be in HH:MM:SS.mmm (for mmm = milliseconds), and it was able to do this in a single prompt. Basically by just saying that! Then I said, "replace rows with no time data to be 'N/A'." and it did that as well. In my usual workflow I do all my data processing in Python or SQL, since this tool can achieve a lot of that processing in sheets without having to learn anythi... Show more
The Arcwise AI plugin utilizes OpenAI's ChatGPT and GPT-4 to provide features such as cleaning data, assisting with formulas, explaining spreadsheets, and web scraping
Users can ask questions about a spreadsheet, clean data with text commands, access a formula copilot, and scrape the web directly into Google Sheets
The plugin aims to bring the power of modern data tools to spreadsheet users and is available for beta testing with free usage during the beta period