E
Sourcetable Integration

EVE Online Plugins For Excel

Jump to

    Overview

    Welcome to the definitive resource for integrating the complex universe of EVE Online with the analytical power of Microsoft Excel. EVE Online plugins for Excel revolutionize how players interact with in-game data, opening new horizons for data analysis, in-game trading, and strategic planning. On this page, we'll delve into the essence of EVE Online, explore the groundbreaking plugins that bridge EVE Online with Excel, examine common use cases that enhance gameplay, and address frequently asked questions to ensure a seamless experience. Whether you're managing interstellar markets or tracking your fleet's prowess, these plugins are designed to make EVE Online more accessible and empower players with information that's just a formula away.

    What is EVE Online?

    EVE Online is a space-based, persistent world massively multiplayer online role-playing game (MMORPG) that has been captivating players for over 20 years. Developed and published by CCP Games, it provides a deeply social and highly customizable gaming experience set within the expansive EVE universe. From the moment players embark on their space-faring journey, they are connected to a universe that is dense with opportunities and challenges.

    The game offers a plethora of in-game professions and activities, appealing to a wide range of playstyles. Players can engage in mining, piracy, manufacturing, trading, exploration, and various forms of combat. This diversity ensures that EVE Online is not just a game, but an intense experience that can be tailored to each player's preferences, making it a unique and enduring fixture in the landscape of online gaming.

    EVE Online Excel Plugins

    Accessing Game Data in Excel

    The EVE Online Excel add-in allows players to access a wide range of game data directly in Microsoft Excel. This includes both public data such as universe or blueprint information and private data like character or corporation assets and wallet records. It is compatible with Microsoft 365 on Mac and Windows, as well as Excel on the web.

    Installation and Setup

    Players can easily download the add-in from the Microsoft Store through Excel. After installation, a new EVE Online button appears in Excel, which when clicked, opens a side panel for adding characters. To import character information, players must log in and authorize the add-in.

    Utilizing Functions

    The add-in features functions categorized into Public, Character, and Corporation, which are accessed through the EVEONLINE.function_name namespace. Public functions can be used without adding characters, while Character and Corporation functions provide more detailed private information and require additional permissions.

    Working with Data Types and Attributes

    Returned data comes as an entity data type or an array of entities, with multiple attributes that can be further extracted. Attributes are easily viewed by clicking on the icon in the cell, and chained notation is available for accessing attributes of nested entities. For handling multiple entities, some functions return arrays allowing for attribute referencing across these entities.

    Additional Resources

    For those seeking to familiarize themselves with the add-in's capabilities, an example workbook is provided. It is also important to note that if Excel is already running, the add-in requires a page reload to update. Players can report any bugs encountered using the F12 key in-game and selecting the Report Bug option.

    Common Use Cases

    • E
      Sourcetable Integration
      Financial analysis and tracking by importing wallet records into Excel
    • E
      Sourcetable Integration
      Strategic planning through analysis of universe or blueprint data
    • E
      Sourcetable Integration
      Management of personal or corporation assets by accessing private information
    • E
      Sourcetable Integration
      Organizational decision making aided by function arrays returned from in-game data
    • E
      Sourcetable Integration
      Automated updates and bug reporting simplify maintenance and troubleshooting



    Frequently Asked Questions

    How do I install the EVE Online Excel add-in?

    You can install the add-in by going to the 'Insert' tab in Microsoft Excel, either on the desktop or web version, and clicking on the 'Get Add-ins' button. Alternatively, you can find it in the Microsoft Store when using Excel online via 'excel.new'.

    What kind of data can I access with the EVE Online Excel plugin?

    The plugin allows you to access a wide range of data including assets, market orders, item prices, wallet transactions, skills, and corporation finances.

    Is the EVE Online Excel plugin free to use?

    Yes, the EVE Online Excel plugin is a free add-in for Microsoft Excel.

    How can I view and use the data after installing the EVE Online Excel add-in?

    Once installed, a new EVE Online button will appear in the Home menu. Clicking the EVE Online icon opens a side panel where you can add characters and authorize Excel to import their information. The add-in provides functions categorized into Public, Character, and Corporation to access different types of information.

    What should I do if I encounter a bug with the EVE Online Excel add-in?

    Bugs with the add-in can be reported by pressing F12 in-game and using the Report Bug button.

    Start working with Live Data

    Analyze data, automate reports and create live dashboards
    for all your business applications, without code. Get unlimited access free for 14 days.