# Data Import Upload up to 100,000 Solana wallets and get every metric per wallet in a table you can sort, filter, export and save as presets, refreshed hourly. Data Import turns any list of wallet addresses into a table: every wallet a row, every one of the 164 metrics a column, the same numbers `/pnlplus` gives you in Discord, in a view you can sort, filter, save and export\. Lists come from the bot, from the Wallet Database, or from anywhere else\. Up to 100,000 wallets per list, as many lists as you like\. Included in both plans\. ```mermaid flowchart LR A["Drop in a .txt or .csv"] --> B["Processing"] --> C["Completed"] --> D["Sort and filter"] --> E["Export or refresh"] ``` ## Create a list 1. ### Open Data Import Click **Data Import** in the sidebar\. The page lists every import you have made\. Click **Create Data Import** at the top\. 2. ### Name it Give the list a name you will recognise tomorrow; the name is required\. The source and the date work well, for example "toptraders 1h, 12 Sep"\. 3. ### Drop in the file Drag the file onto the upload area or click **choose file**\. Two formats work: - A **\.txt** file with one wallet address per line and nothing else on the line\. This is what the bot commands give you\. - A **\.csv** file with a header row that has a column named `address` or `wallet`, in lowercase\. Other columns are ignored\. > [!WARNING] > The file extension has to be lowercase, \.txt or \.csv\. 4. ### Click Create Data Import The list appears with the status **Processing** while every wallet is analysed, then switches to **Completed**\. A few thousand wallets take a couple of minutes\. Click the list name, or the arrow at the end of its row, to open it\. > [!TIP] > Coming from the bot? `/toptraders`, `/earlybuyers`, `/botwallets` and the other wallet commands return exactly the file Data Import expects\. Save it and drop it in\. The [Quickstart](/quickstart) shows the whole path\. ## See your lists and their status The Data Import page shows one row per list: - **Import Name**, **Date of Import**, **Date of Update** \(the last refresh\), **Wallets** \(how many are on the list\) and **Status**\. - At the end of the row: **refresh** \(two arrows\), **add wallets** \(a wallet with a plus\), **delete** \(a bin, with a confirmation\), and the **arrow** that opens the list\. Only a Completed list can be opened\. Lists also show up in the search: press Ctrl K, or Cmd K on a Mac, and type the name\. ## Narrow a list to a shortlist The header carries the list name with **Rename Data Import** and **Delete Import**, then four buttons that shape the table: **Filtering and Sorting**, **Columns preset**, **Import Wallets** and **Export Wallets**\. Under them, the table\. ### Read the table The first column is the wallet: the name you gave it, if any, the shortened address, a pencil to name it, a copy button, and two icons, an eye for the watchlist and a no\-entry sign for the blacklist\. Every other column is a metric\. Profit is green with an up arrow or red with a down arrow, percentages that can go negative the same; durations read like 2d 4h 13m; dates are relative, with the exact time when you hover; a dash means no data\. Scroll sideways for more columns\. The count at the bottom is how many wallets match your current filters\. Fifty show per page; switch to 10 or 20 next to it\. ### Sort Click the chevron next to a column name: highest first, click again for lowest first\. One column at a time, across the whole list\. A new list opens sorted by profit over the last 30 days\. ### Filter Click the funnel next to a column name\. Numbers, prices, percentages and durations get a **From** and a **To** field; dates get a calendar with a time range under it\. Type the range and click **Filter**; **Reset** clears it\. A solid funnel marks every filtered column\. Filters stack, and each one narrows the whole list, not only the page you see\. > [!TIP] > Start wide and tighten: win rate and profit over the last 7 days first, then a holding\-time range that matches how you trade, and a few thousand wallets become a few dozen\. ### Save the filters as a preset Click **Filtering and Sorting**: - **Default** clears every filter and restores the default sort\. - Tick **Save as Preset**, type a name, click **Save**\. The preset keeps every active filter and the sort\. - To update a preset, select it, change the filters and save under the same name; a pencil next to the name field confirms it will be overwritten\. - The trash icon deletes a preset\. The same panel shows which blacklist is active and how many addresses it holds, with a cog to manage it\. See [Blacklist](/blacklist)\. ### Choose the columns **Columns preset** shows which column set is on; Default is the set Wallet Master picks\. To build your own, click **Columns preset**, then **Customize Columns**: 1. A panel opens with every available column and a search box\. Starting from Default, only Wallet Address is ticked\. 2. Tick the columns you want, or use **Select all** and **Clear all**\. Wallet Address is always first\. 3. Drag the entries in the **Columns Selected** list to set their order\. 4. Name the selection and click **Apply**\. From a saved preset, choose between updating it and saving a new one\. Click **Set as Default** on the preset you use most and every list opens with it\. One preset per thesis works well: the columns you read when hunting scalpers are not the ones for holders\. ### Hide blacklisted wallets The switch at the bottom of the table drops every wallet on your blacklist or on the community blacklist you follow\. The no\-entry icon in a row adds a wallet to your blacklist or removes it; a small person badge means your blacklist, a globe the community one\. ### Open, watch or remove a wallet - The **arrow** at the end of a row opens the wallet in [Wallet Deep Dive](/wallet-deep-dive), the **Solscan** icon opens it on Solscan, and the **bin** removes the wallet from this list only\. - The **eye** next to the address adds the wallet to a watchlist or removes it; a green check means it is already on one\. See [Watchlist](/watchlist)\. ## Add wallets to a list Click **Import Wallets** inside a list, or the wallet\-with\-plus icon on the Data Import page\. Drop in a file with the same rules as above, or type a single wallet address\. The list goes back to **Processing** while the new wallets are analysed and to **Completed** when they are in\. The 100,000 limit counts the whole list, not the upload\. Bring in tomorrow's bot results this way and the list grows into your own database\. ## Refresh a list Wallet Master recomputes every metric hourly\. To bring a list up to the latest numbers, click the two\-arrows icon in its row on the Data Import page\. The status goes to Processing and back to Completed, and **Date of Update** moves\. Refresh as often as you like\. ## Export to CSV or JSON **Export Wallets** downloads the list as CSV or JSON\. Two switches decide what goes in: - **Use applied filters**, on by default: only the wallets that match your filters, in the current sort\. Off: every wallet on the list\. - **Use applied columns**, on by default: only the columns of your current preset\. Off: the default columns\. The file is prepared on our side and the download starts when it is ready\. ## Rename or delete a list **Rename Data Import** in the header changes the name\. **Delete Import** in the header, or the bin on the Data Import page, deletes the whole list after a confirmation\. Your watchlists and your blacklist are separate and stay as they are\. ## Lists from the Wallet Database > [!INFO] > On the Wallet Database \+ API plan you can skip the upload: run a query in the [Wallet Database](/wallet-database) and save the result as a Data Import list\. It appears here like any other list, with the same table and the same controls\.